PHP - Simple Referral Script

Hi can someone pls help, im tryin a tutorial but keep getting errors, this is the first one i get after registering.

You Are Registered And Can Now Login
Warning: Cannot modify header information - headers already sent by (output started at /home/aretheyh/public_html/nealeweb.com/regcheck.php:43) in /home/aretheyh/public_html/nealeweb.com/regcheck.php on line 46

db table    username------>id->username->cash->points->referrer db table    referral_levels------>id->level->earnings->signupBonusCash->signupBonusPoints->status

username    referrer
--------    --------
admin
kelly88     admin   // UPDATE USERNAME ADMIN WITH referral level 1 POINTS/CASH //
jacob       kelly88 // UPDATE USERNAME ADMIN WITH referral level 2 POINTS/CASH AND USERNAME kelly88 WITH referral level 1 POINTS/CASH //
david16     jacob   // UPDATE USERNAME ADMIN WITH referral level 3 POINTS/CASH AND USERNAME kelly88 WITH referral level 2 POINTS/CASH AND USERNAME jacob WITH referral level 1 POINTS/CASH //

Is this possible. If yes - HOW?   Current test registration code with referral level 1

<?php
if(!empty($_GET['ref'])){
	
	$referrerUsername = filter_input(INPUT_GET, 'ref', FILTER_SANITIZE_STRING);
	
	if(usernameExist($referrerUsername, $db) === TRUE){
		$_SESSION['ref'] = $referrerUsername;
	}
	
}

// define variables with the value for each field
// the value from POST,GET if this exist, or an empty value
$errors = array();
$username = isset($_POST['username']) ? filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING) : '';
$referrer = !empty($_SESSION['ref']) ? $_SESSION['ref'] : (isset($_POST['referrer']) ? filter_input(INPUT_POST, 'referrer', FILTER_SANITIZE_STRING) : '');

if(!empty($_POST['submit'])){
	
	if(empty($username)){
       	 $errors[] = $lang['error']['a_019'];
    }
	else if(validUsernameLenght($username) === FALSE){
        $errors[] = $lang['error']['a_020'];
   	}
	else if(validUsernameChars($username) === FALSE){
        $errors[] = $lang['error']['a_021'];
    }
	else if(usernameExist($username, $db) === TRUE){
       	$errors[] = $lang['error']['a_022'];
    }
	
	if(!empty($referrer)){
		
		if(usernameExist($referrer, $db) === FALSE){
			$errors[] = $lang['error']['a_037'];
		}
		else if($username == $referrer){
			$errors[] = $lang['error']['a_038'];
		}
			
	}
	
}

if(!empty($_POST['submit']) and empty($errors)){
	/*
	$queryOne = 'INSERT INTO users(username, referrer) VALUES (:username, :referrer)';
	$insertOne = $db->prepare($queryOne);
	$insertOne->bindParam(':username', $username, PDO::PARAM_STR);
	$insertOne->bindParam(':referrer', $referrer, PDO::PARAM_STR);
	$successOne = $insertOne->execute();
	*/
	if($referrer){
		
		$query = 'SELECT signupBonusCash AS sbc, signupBonusPoints AS sbp FROM referral_levels WHERE level = 1 AND status = "enabled"';
		$select = $db->query($query);
		$row = $select->fetch(PDO::FETCH_ASSOC);
		
		$queryTwo = 'UPDATE users SET points = points + :points, cash = cash + :cash WHERE username = :referrer';
   	 	$selectTwo = $db->prepare($queryTwo);
		$selectTwo->bindParam(':cash', $row['sbc'], PDO::PARAM_STR);
		$selectTwo->bindParam(':points', $row['sbp'], PDO::PARAM_STR);
		$selectTwo->bindParam(':referrer', $referrer, PDO::PARAM_STR);
		$selectTwo->execute();
		
	}
	
}

if(!empty($errors)){ 
	foreach($errors as $error){
		print $error.'<br>'; 
	}
}	

print '
<form method="POST">
<table style="width:100%">
	<tr>
    	<td style="width:30%;font-weight:bold">Username</td>
    	<td style="width:70%"><input type="text" name="username" maxlength="255" style="width:200px" value="'.cleanOutput($username).'"></td>
	</tr>';
	
	if(!empty($_SESSION['ref'])){
		
		print '
	<tr>
    	<td style="font-weight:bold">'.$lang['global']['a_047'].'</td>
    	<td><input type="text" name="referrer" readonly="readonly" maxlength="255" style="width:200px" value="'.cleanOutput($referrer).'"></td>
  	</tr>';
	
	}else{
		
		print '
	<tr>
    	<td style="font-weight:bold">'.$lang['global']['a_047'].'</td>
    	<td><input type="text" name="referrer" maxlength="255" style="width:200px" value="'.cleanOutput($referrer).'"></td>
  	</tr>';
	
	}
	
	print '
	<tr>
    	<td colspan="2" style="text-align:center"><input type="submit" name="submit" value="Submit"></td>
  	</tr>
</table>
</form>'; 

?>

Hi,

I have a fully pledged membership system and want to integrate my own user referral system but want some tips, advice really on the logic of it. Basically already registered users on my site will have the option to refer people, only registered users. I will try to explain my logic and what i have done so far.

My current registered users table is something like

Quote

    users (table)
    - id (user id)
    - email (user email)
    - password (hash of users password)
    - reg_date (date user registered)


I have some other fields but not relevant to what I want to do and to keep things as simple as possible I left them out.

I am thinking of creating a new table called referrals and for example when a registered user on my site from the users table goes to a member only page called referral.php it will display a form so they can enter an email address of someone they want to refer and it also displays the people they referred.

My referral table is like this so far and not sure if it's best way to go about the database logics and php logic.

my table so far looks like this:

Quote

    referrals (table)
    - id (auto incremented every time a new referral (row) is added to referrals table)
    - referrer_uid (id of referrer, this would be the unique id of a registered user from the users table)
    - referred_email (email address of person who has been referred)
    - status (when someone is first referred default will be `referred`, if they signup to site via referral link this will update to `completed`)
    - created_on (date the referral was made, unix timestamp)
    - updated_on (date the referred person actually clicks the referral link and completes signup)


Currently i added the database table above to my site on local. added some sample data for testing and created a referral.php page where there's a form so a registered member can enter a persons email and refer them to my site to signup. On referral.php there is also  the total people they referred and a table showing all the people they referred as follows:

Referred Email | Referred Date | Status | Completed On

Now so far everything is seems fine. I have my sample (pretend referrals i made) data showing in my test account. The part i am now not sure about is this:

Obviously to stop abuse i do my usual validation checks like: check to ensure the email being entered on referrals page does not exist in users table (registered member), check to ensure the email has not already been referred previously (for spam reasons) only allowed to refer an email address once and not allowed to refer someone who has previously been referred by someone else to (again for spam reasons)

Now onto the tracking the referral and link building.

I was first thinking this:

on sign up form have a hidden field. The sign up form would do a simple check to see if isset $_GET['ref'] like signup.php?ref=something_here

if it is prefill the hidden field, when user then signs up if the ref=something_here matches what's in the database then update referral to complete so the referrer knows that their friend for example signed up via their referral, unix timestamp of when referred person completed signup.

Now i was going to use the email address of referred person or username of person who made the referral signup.php?ref=username or signup.php?ref=referred_email . Now what i am thinking is what would be better and i guess stop random abuse is create another column and call it referred_id; this would be a random md5 hash that is unique to that referral and it will be appended to the url like signup.php?ref=md5_hash_here.



So my questions a

1) Is there anything you think i should change, improve on, alter etc ?

2) Do you think i am going about it the rite way or making a mess of it ?

3) Have i left anything out that i may have not thought of that could cause the system to be abused ?

Any suggestions, feedback, help on the whole logic would be great.

I coded allot of it last night and won't take me long to do the rest but need some help in terms of ensuring i am doing it the best way possible etc, the logic behind it all.

Thanks for any suggestions, help, advice, tips!

PHPFAN

I have a site where the user must view a timed loader before playing an audio bible.  I'm noticing some direct linking to the bible player instead of sitting through the loader...

I need to check the previous page's url before actually loading the player. I through together a script last ween in javascript and people reported error, so I assumed it would be best server side anyway.

I haven't coded anything in PHP since PHP3.  So, I'm asking for your expert options and help...

I haven't tested this yet, but is this the best method and are they any problems with this method (if it works).



$realname = basename($_SERVER[loader], ".php");

if ($realname == 'loader.php')
{
   return();
}

else
{
 // rediret to a notice to user that this isn't allow
 header( 'Location: http://www.yoursite.com/new_page.html' ) ;
}

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=346529.0

       Right now, the following PHP script claims to send an email for Google referrals, as your forum states.  I put it in the first few lines of index.php.  Is this wrong, because I still received zero emails, adding the site name to keywords below...?  And, of course, I searched the same keyword from Google without success.

<?php
// Script to email you when Google refers traffic to your site.
$name=""; // add your name here
$email_address="";
 // add your email address here
$keywords="";
$referrer=$_SERVER['HTTP_REFERER'];
if( (stristr($referrer, "google")) && (stristr($referrer, "search")) ) {
   
parse_str($referrer, $output);
   $keywords=$output['q'];
      $email_message="Hi $name, A visitor just arrived to your site after searching for '$keywords'. ($referrer)";   mail ("$email_address","Google referred a visitor","$email_message");
}
?>
    If this is wrong, how DO I use such a PHP within my phpmyadmin folder?  Need help.

<html>
<head></head>
<body>
My favourite bands a
<ul>

<?php

// define arrays
$morebands = array('Desturbed', 'Anthrax');
$artists = array('Metallica', 'Evanescence', 'Linkin Park', 'Guns n Roses', "$morebands");
// loop over it
// print array elements
foreach ($artists as $a) {
    if ($a != 'Array'){
   echo '<li>'.$a;
}
   Else {
foreach ("${$a}" as $b){
echo '<li>'.$b;
}
}
}

?>

</ul>
</body>
</html>

I can not figure out why this will not work:(
I would like the foreach to run through the array as normal, but if it encounters a nested array, loop it as well.

I know this likely is not the right, or best way to do this, but I am just learning PHP through a tutorial and I learn best by doing... So I take the lessons, make them more complicated, then figure out how to make it happen (like so).

right now I am working on
http://devzone.zend.com/node/view/id/635

anyhow thanks for any help!

i already have the front page that calls the script, but its not letting me login, i don't see the problem i know its returning the rows from the database but i don't understand why its not letting me login and when i do get it to login messing around with the code everybody logs in as an admin, my database has, user, pass, and role inside admin, poweruser, and reg user but when i get it to log in everybody logs in as an admin, can someone please help me ? i even tried the error thing but that doesn't seem to work either



ini_set('display_errors', 1);
error_reporting(E_ALL);
//echo ini_set('display_errors');

session_start();

$username = $_POST['username'];
$password = $_POST['password'];

if (mysql_connect("localhost", "root", ""))
    {
        //echo 'connect';    
    }
    
else
    {
        echo 'failure';
    }

if  (mysql_select_db("athentication"))
    {
        //echo 'connect';    
    }
    
else
    {
        echo 'no connect';
    }

    $result = mysql_query("SELECT * FROM login WHERE user = '$username'");
    $rows = mysql_num_rows($result);
    $role = $rows['role'];

if ($rows != 0)
{
    if ($role == 'admin')
           {
           header('Location: admin.php');
           $_SESSION['username'] = $username;
           }
           
    elseif ($role == 'poweruser')
           {
           header('Location: poweruser.php');
           $_SESSION['username'] = $username;
           }
           
    /*elseif ($role ==' reg')
           {
            echo "WHAT UP";
            $_SESSION['username'] = $username;
           }*/
 }
 else
    echo "enter a valid user name";

The attached script does everything I want it to do, but it's not very elegant.  I could use some help cleaning it up.  Any and all help is greatly appreciated.

Thanks!!!

I was told that you guys could probably help me with this, so heres my situation. I use this program called Activeworlds, and me and my buddies are makeing a "tv show" if you will within the program. To do so, you take screenshots, save the screenshots, and add the image files into a directory on your domain. You need a .php script to present them as a slideshow. Now the problem is, ive searched for scripts already made from other sites, but the thing is, they are all fancy slideshow viewers, meaning they come with control buttons to cycle through the pictures and all kinds of other banners and flashy looking things. The only script im needing, is a simple script that will display and cycle through the raw images, and nothing else, within the web browser, in a slideshow format. Id also like to have a value I can edit that will change how fast the pictures cycle through, 15 seconds or so would be perfect however. If someone could refer me to this code or even make it for me, it would be soo appreciated. I know im probably asking for alot, but it would help me soo much. I wish I knew a little more about .php files to do it myself, or else I would. If you do link me to a script, please give me simple instructions on what to do with it lol because like I said, I dont know anything about the world of .php yet. Thank you all for your time.

If you look at the botton of http://getminecraft.net/ you see my latest tweets. The problem is that it shows http://getminecraft.net/%22http://twitter.com/PC_Gamer%22 instead of the original twitter url, that results to a wrong url and wrong site. How can I fix it? so it shows the original twitter url. Here is the script:

<?php

$username = "getminecraft";

$prefix = "";

$suffix = "";

$feed = "http://search.twitter.com/search.atom?q=from:" . $username . "&rpp=1";

function parse_feed($feed) {

$stepOne = explode("<content type=\"html\">", $feed);
$stepTwo = explode("</content>", $stepOne[1]);

$tweet = $stepTwo[0];
$tweet = str_replace("&lt;", "<", $tweet);
$tweet = str_replace("&gt;", ">", $tweet);

return $tweet;

}

$twitterFeed = file_get_contents($feed);

echo stripslashes($prefix) . parse_feed($twitterFeed) . stripslashes($suffix);

?>

Hiya!

I need to create a simple PDF script that will always create A4 documents. I need the content to be controlled using HTML and CSS.

Where do you start in creating such a script?

Any help is greatly received.

I've tried Googling this for a long time but I only find complete member systems with ugly code, not something i'm looking for.

What I am looking for is just a simple tutorial or commented code to make a admin login.

What it's going to do is just:

Loading a MD5 salt hasched password from my MYSQL database.
You'll get to fill in one field: Password. If it validates with the MYSQL password it'll show the hidden content; if not it'll just give a "not correct error".

That's basicly it. I have only one page of secret admin stuff so yeah.. it would be awesome to have the ability to logout and I of curse want to have everything in sessions!

It would be to big help!

Hi all, Im coding a simple script for my website which just changes the users rank.

Code: [Select]
<?php
session_start();
include "../includes/db_connect.php";
include "../includes/functions.php";
logincheck();

ini_set ('display_errors', 1);
error_reporting (E_ALL);

$username=$_SESSION['username'];

$get = mysql_query ("SELECT * FROM users WHERE username = '$username'");
$fetch = mysql_fetch_object($get);

if ($fetch->userlevel >= "2"){
$newrank = $_POST['newrank'];
$user1 = $_POST['user'];
if (strip_tags($_POST['update'])){
mysql_query("UPDATE users SET `rank` = '$newrank' WHERE username='$user1'") or die (mysql_error());
echo ("You have updated $user1's rank to $newrank !");
}
}
else{
echo ("Your userlevel isnt high enouth to be here!");
}
?>
<html>
<head>
<title>Change Rank</title>
<link rel="stylesheet" href="../includes/in.css" type="text/css">
<style type="text/css">
.infobg {
font-family: Arial;
font-weight:normal;
font-size:12px;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
background: URL(textbg1.png);
font-weight:300;
}

.button {
font-size: 12px;
background:url(button.png);
vertical-align: middle;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
color: #FFFFCC;
height:23px;
font-weight:300;
border-radius: 10px;
padding-bottom:2px;
}

</style>
</head>
<body>
<form action='' method='post' name='form1'>
<table width='30%' cellpadding='0' align='center' cellspacing='0' border='1' bordercolor='#000000' bgcolor='#808080' style='border-collapse: collapse'>
<tr>
<td background='../header.jpg' colspan='2' align='center'>Change Rank</td>
<tr>
<td>Username:</td><td><input type='text' name='user'></td>
</tr>
<tr>
<td>Rank:</td><td><input type='text' name='newrank'></td>
</tr>
<tr>
<td>&nbsp;</td><td><input type="submit" name="update" value="Update Rank"></td>
</tr>
</form>
</table>
</body>
</html>
But there seems to be something wrong with that code, which I carnt see or work out. When I click Update submit button it does nothing, but can anyone see why it does nothing?

Thanks.

I'm very new to PhP and one of my asignments in class is to create a simple login using php and mysql. I made a simple page using html, php, and mysql and i keep getting errors. Here is my code so far:
This is my index.php page:
<html>
   <form action = 'login.php' method='POST'>
      Username: <input type='text' name='username'><br>
      Password: <input type='password' name='password'><br>
      <input type='submit' value='Log in'>
   </form>
</html>
This is my login.php page:
<?php
$username = $_POST['username'];
$password = $_POST['password'];

if ($username&&$password)
{
&connect = mysql_connect("localhost", "root", " ") or die ("Couldnt connect");
mysql_selct_db("phplogin") or die("Couldn't find db");
}
else
   die ("Please enter a username and password");
?>
mySql file is very basic: 3 columns, id, username, password

I dont think my problem is with the mySQL page that was the easiest to make

but everytime I hit login in the index.php, the entire script for login.php gets outputted on screen.

I would appreciate all the help.