Membership Registration Not Working...

Question

idskot 0 Newbie Poster

14 Years Ago

Hey, guys. I'm building a really simple member register / login, based off some other code. I added it to the server and set up the DB properly, and now I'm having an issue. Whenever I go to register a new user, it says the user field is not filled out. (Obviously, I put a detection system into place). However, it's also giving me an error in one of those areas. Obviously the string isn't being filled properly, but I can't figure out why.... here's the code for what I call the "process" part of it:

// EDIT THIS IF YOU MODIFIED THE SIGNUP PAGE OR
    // IF YOU ARE USING YOUR OWN SIGNUP FORM
    // We  use the addslashes() function on some variables to prevent SQL Injection
    $uname = addslashes($_POST['username']);
	$email = addslashes($_POST['email']);
    $password = $_POST['password'];
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
	$mname = $_POST['mname'];
	$dob = $_POST['dob'];
	$address = $_POST['address'];
	$city = $_POST['city'];
	$state = $_POST['state'];
    $zipcode = $_POST['zipcode'];
	$license = $_POST['license'];
	$carmake = $_POST['carmake'];
	$carmodel = $_POST['carmodel'];
	$engine = $_POST['engine'];
	$class = $_POST['class'];
	$doc = $_POST['doc'];
	$docnum = $_POST['docnum'];
	$primecon = $_POST['primecon'];
	$primecon = $_POST['primeconrel'];
	$primeconnum = $_POST['primeconnum'];
	$seccon = $_POST['seccon'];
	$seccon = $_POST['secconrel'];
	$secconnum = $_POST['secconnum'];

	// SIGNUP SETTINGS
	$qSetup = mysql_query("SELECT * FROM signupsetup");
	$SetupRow = mysql_fetch_array($qSetup);
	$ValidEmailDomains = $SetupRow['validemail'];
	$profile = $SetupRow['profile'];
	$defaultgroup = $SetupRow['defaultgroup'];
	$defaultlevel = $SetupRow['defaultlevel'];
	$AutoApprove = $SetupRow['autoapprove'];
	$AutoSend = $SetupRow['autosend'];
	$AutoSendAdmin = $SetupRow['autosendadmin'];
	
	// EMAILER SETTINGS
	$qEmailer = mysql_query("SELECT * FROM emailer WHERE profile='$profile'");
	$EmailerRow = mysql_fetch_array($qEmailer);
	$EmailerName = $EmailerRow["name"];
	$EmailerFrom = $EmailerRow["email"];
	$EmailerSubject = $EmailerRow["subject"];
	$EmailerMessage = $EmailerRow["emailmessage"];

	// SIGNUP FORM PROCESSING
	$EmailQuery = mysql_query("SELECT * FROM signup WHERE email='$email'");
	$email = strtolower($email);
	$EmailExist = mysql_num_rows($EmailQuery);	// Returns 0 if not yet existing
	$username = strtolower($username);
	$UsernameQuery = mysql_query ("SELECT * FROM signup WHERE username='$uname'");
	$UsernameExist = mysql_num_rows($UsernameQuery);
	
	if (trim($ValidEmailDomains)=="")
	{
		$EmailArray = "";
	}
	else
	{
		$EmailArray = split (" ", $ValidEmailDomains);
	}
	
	// Generate confirmation key for settings which require one
	$confirmkey =  md5(uniqid(rand())); 

	// CHECK FOR RESERVED USERNAMES
	if (trim($username)=='sa' || trim($username)=='admin' || trim($username)=='test')
	{
		$UsernameExist = 1;
	}
	
	// CHECK FOR REQUIRED FIELDS
	if (empty($username))
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Username field cannot be left blank!</b></font></p>";
		exit;
	}

On the registration form, the Username is under the name uname.

Any help would be great!

EDIT: I changed the name to uname on the registration page, and it fixed the 'error on line 68' issue I was getting.
However, I'm still getting 'username not filled out'.

php

Edited 14 Years Ago by idskot because: n/a

2 Contributors
2 Replies
113 Views
10 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by theonly

theonly 0 Light Poster

14 Years Ago

Since I have not seen your input form, try echoing the variables after you have assigned them to make sure all of them actually contain a value.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

idskot 0 Newbie Poster · Answer 1 · 2010-10-09T01:58:31+00:00

Well, I fixed that problem... however, now it won't add any information to the DB, but I'm not getting any errors! It just isn't adding it!

<? require_once ("signupconfig.php"); ?>
<html>
<head>
<title>Sign</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<?
	include ("auth.php");
	$connection = mysql_connect($dbhost, $dbusername, $dbpassword);
	$db = mysql_select_db($dbname);

       // EDIT THIS IF YOU MODIFIED THE SIGNUP PAGE OR
    // IF YOU ARE USING YOUR OWN SIGNUP FORM
    // We  use the addslashes() function on some variables to prevent SQL Injection
    $username = addslashes($_POST['username']);
	$email = addslashes($_POST['email']);
    $password = $_POST['password'];
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
	$mname = $_POST['mname'];
	$dob = $_POST['dob'];
	$address = $_POST['address'];
	$city = $_POST['city'];
	$state = $_POST['state'];
    $zipcode = $_POST['zipcode'];
	$license = $_POST['license'];
	$carmake = $_POST['carmake'];
	$carmodel = $_POST['carmodel'];
	$engine = $_POST['engine'];
	$class = $_POST['class'];
	$doc = $_POST['doc'];
	$docnum = $_POST['docnum'];
	$primecon = $_POST['primecon'];
	$primeconrel = $_POST['primeconrel'];
	$primeconnum = $_POST['primeconnum'];
	$seccon = $_POST['seccon'];
	$secconrel = $_POST['secconrel'];
	$secconnum = $_POST['secconnum'];

	// SIGNUP SETTINGS
	$qSetup = mysql_query("SELECT * FROM signupsetup");
	$SetupRow = mysql_fetch_array($qSetup);
	$ValidEmailDomains = $SetupRow['validemail'];
	$profile = $SetupRow['profile'];
	$defaultgroup = $SetupRow['defaultgroup'];
	$defaultlevel = $SetupRow['defaultlevel'];
	$AutoApprove = $SetupRow['autoapprove'];
	$AutoSend = $SetupRow['autosend'];
	$AutoSendAdmin = $SetupRow['autosendadmin'];
	
	// EMAILER SETTINGS
	$qEmailer = mysql_query("SELECT * FROM emailer WHERE profile='$profile'");
	$EmailerRow = mysql_fetch_array($qEmailer);
	$EmailerName = $EmailerRow["name"];
	$EmailerFrom = $EmailerRow["email"];
	$EmailerSubject = $EmailerRow["subject"];
	$EmailerMessage = $EmailerRow["emailmessage"];

	// SIGNUP FORM PROCESSING
	$EmailQuery = mysql_query("SELECT * FROM signup WHERE email='$email'");
	$email = strtolower($email);
	$EmailExist = mysql_num_rows($EmailQuery);	// Returns 0 if not yet existing
	$username = strtolower($username);
	$UsernameQuery = mysql_query ("SELECT * FROM signup WHERE uname='$username'");
	$UsernameExist = mysql_num_rows($UsernameQuery);
	
	if (trim($ValidEmailDomains)=="")
	{
		$EmailArray = "";
	}
	else
	{
		$EmailArray = split (" ", $ValidEmailDomains);
	}
	
	// Generate confirmation key for settings which require one
	$confirmkey =  md5(uniqid(rand())); 

	// CHECK FOR RESERVED USERNAMES
	if (trim($username)=='sa' || trim($username)=='admin' || trim($username)=='test')
	{
		$UsernameExist = 1;
	}
	
	// CHECK FOR REQUIRED FIELDS
	if (empty($username))
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Username field cannot be left blank!</b></font></p>";
		exit;
	}
	if (empty($password))
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Password field cannot be left blank!</b></font></p>";
		exit;
	}
	if (empty($fname))
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>First Name field cannot be left blank!</b></font></p>";
		exit;
	}
	if (empty($lname))
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Last Name field cannot be left blank!</b></font></p>";
		exit;
	}
	if (empty($email))
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Email field cannot be left blank!</b></font></p>";
		exit;
	}
	
	// Validate Email Address String
  	$good = ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+'.
               '@'.
               '[-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.'.
               '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$',
               $email);	
	if (!$good)
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Email field has invalid characters!</b></font></p>";
		exit;
	}
	
	// Validate Email Address String - FOR VALID EMAIL DOMAINS
	$found=false;
	if ($EmailArray!="")
	{
		for ($ct=0;$ct<=sizeof($EmailArray)-1;$ct++)
		{
			if (eregi($EmailArray[$ct], $email))
			{
				$ct=sizeof($EmailArray);
				$found=true;
			}
			else
			{
				$found=false;
			}
		}
	}
	else
	{
		$found = true;
	}
	if (!$found)
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Email address does not belong to the list of allowable email domains!</b></font></p>";
		exit;
	}

	// Make sure username does not yet exist in the db
	if ($UsernameExist>0)
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Username already exists in the database!</b></font></p>";
		exit;
	}
	
	// Make sure email address does not yet exist in the db
	if ($EmailExist>0)
	{
		print "<p><font size=\"3\" face=\"Verdana, Arial\" color=\"#FF0000\"><b>Email address already exists in the database!</b></font></p>";
		exit;
	}
	
	// *********************************************************
	// CHANGE THIS IF YOU WANT TO ADD FIELDS TO YOUR SIGNUP FORM
	// *********************************************************
	// Add new member to table signup
	$addmember = mysql_query("INSERT INTO signup VALUES ('','$username','$email', '$fname','$lname', '$mname', '$dob', '$address', '$city', '$state', '$zipcode', '$license', '$carmake', '$carmodel', '$engine', '$class', '$doc', '$docnum', '$'primecon', '$primeconrel', '$primeconnum', '$seccon', '$secconrel', '$secconnum',NOW(),'$confirmkey')");
	
	// If SUCCESSFUL, add to tables too
	if ($addmember)
	{
		// Is the member auto-approved or not?
		if ($AutoApprove==1)
		{
			$MemberStatus = "active";
		}
		else
		{
			$MemberStatus = "inactive";
		}

		$AddToAuth = new auth();
		$add = $AddToAuth->add_user($username,$password,$defaultgroup,$defaultlevel,$MemberStatus,'', 0);
	}
	
	// Do we automatically send email notification to member or not?
	if ($AutoSend == 1)
	{
		// if successful in adding, send confirmation email
		if ($add==1)
		{	
			// Replace all occurrences of the keys
			// AVAILABLE KEYS: [[UNAME]], [[LNAME]], [[FNAME]], [[PASSWD]], [[EMAIL]], [[CONFIRM]]			
			$EmailerMessage = str_replace("[[UNAME]]", $username, $EmailerMessage);
			$EmailerMessage = str_replace("[[PASSWD]]", $password, $EmailerMessage);
			$EmailerMessage = str_replace("[[FNAME]]", $fname, $EmailerMessage);
			$EmailerMessage = str_replace("[[LNAME]]", $lname, $EmailerMessage);
			$EmailerMessage = str_replace("[[EMAIL]]", $email, $EmailerMessage);
			$EmailerMessage = str_replace("[[CONFIRM]]", $confirm . '?confirmkey=' . $confirmkey, $EmailerMessage);
				
			$sent = @mail($email, $EmailerSubject, $EmailerMessage, "From:$EmailerName<$EmailerFrom>\nReply-to:$EmailerFrom"); 
			// $sent = @mail($email, $EmailerSubject, $EmailerMessage, "From:$EmailerName<$EmailerFrom>\nReply-to:$EmailerFrom\nContent-Type: text/html; charset=iso-8859-15"); 
		}
	}
	// echo $EmailerMessage;	// DEBUGGER

	// Do we automatically send notification message to the admin's email address (see signupconfig.php)?
	if ($AutoSendAdmin == 1)
	{
		if ($add==1)
		{
			$AdminSubject = "New Membership Application!";
			$AdminMessage = "This is to inform you that " . $username . " has applied for membership to our site.";			
			$sent = @mail($adminemail, $AdminSubject, $AdminMessage, "From:$EmailerName<$EmailerFrom>\nReply-to:$EmailerFrom"); 
		}
	}
?>

<p><font size="3" face="Verdana, Arial, Helvetica, sans-serif" color="#FF0000"><b>Thank 
  you for signing up!</b></font></p>

<?
	if ($AutoSend == 1) 
	{
		print "<p><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
		print "A confirmation email was sent to the email address you specified. <br>";
		print "Please confirm your membership as soon as you receive the email.";
  		print "</font></p>";
	}
	else
	{
		print "<p><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
		print "Please click <a href=\"$RelLogin\">here</a> to go back to the login area";
  		print "</font></p>";
	}
?>

</body>
</html>