Jump to content

mysqli errors all over the input fields?

crf1121359

By crf1121359
in PHP Coding Help

 Share

Recommended Posts

crf1121359 Member

crf1121359

Posted
Posted

Hi,

 

I am trying to figure out how to use mysqli function and converting mysql to mysqli in my php files.

 

My sign up form works in mysql but it throws so many errors in the input fields for some reason!

 

the errors are like this:

 

<br /><b>Notice</b>:  Undefined variable: username in <b>/home/netolanc/public_html/answers/join_form.php</b> on line <b>121</b><br />

 

<br /><b>Notice</b>:  Undefined variable: state in <b>/home/netolanc/public_html/answers/join_form.php</b> on line <b>137</b><br />

 

and so on.....

 

i don't understand what this means and why its happening!

 

here is my code for the sign up page:

 

<?php 
error_reporting(E_ALL);
ini_set('display_errors', '1');
?>
<?php
$errorMsg = "";
// First we check to see if the form has been submitted 
if (isset($_POST['username'])){
	//Connect to the database through our include 
	include_once "config/connect.php";
	// Filter the posted variables
	$username = ereg_replace("[^A-Za-z0-9]", "", $_POST['username']); // filter everything but numbers and letters
	$country = ereg_replace("[^A-Z a-z0-9]", "", $_POST['country']); // filter everything but spaces, numbers, and letters
	$state = ereg_replace("[^A-Z a-z0-9]", "", $_POST['state']); // filter everything but spaces, numbers, and letters
	$city = ereg_replace("[^A-Z a-z0-9]", "", $_POST['city']); // filter everything but spaces, numbers, and letters
	$email = stripslashes($_POST['email']);
	$email = strip_tags($email);
	$email = mysqli_real_escape_string($email);
	$password = ereg_replace("[^A-Za-z0-9]", "", $_POST['password']); // filter everything but numbers and letters
	// Check to see if the user filled all fields with
	// the "Required"(*) symbol next to them in the join form
	// and print out to them what they have forgotten to put in
	if((!$username) || (!$country) || (!$state) || (!$city) || (!$email) || (!$password)){
		
		$errorMsg = "You did not submit the following required information!<br /><br />";
		if(!$username){
			$errorMsg .= "--- User Name";
		} else if(!$country){
			$errorMsg .= "--- Country"; 
		} else if(!$state){ 
		    $errorMsg .= "--- State"; 
	   } else if(!$city){ 
	       $errorMsg .= "--- City";
	   } else if(!$email){ 
	       $errorMsg .= "--- Email Address"; 
	   } else if(!$password){ 
	       $errorMsg .= "--- Password"; 
	   }
	} else {
	// Database duplicate Fields Check
	$sql_username_check = "SELECT id FROM members WHERE username='$username' LIMIT 1";
	$query = mysqli_query($db_conx, $sql_username_check);
	$sql_email_check = "SELECT id FROM members WHERE email='$email' LIMIT 1";
	$query = mysqli_query($db_conx, $sql_email_check);
	$username_check = mysqli_num_rows($db_conx, $sql_username_check);
	$email_check = mysqli_num_rows($db_conx, $sql_email_check); 
	if ($username_check > 0){ 
		$errorMsg = "<u>ERROR:</u><br />Your User Name is already in use inside our system. Please try another.";
	} else if ($email_check > 0){ 
		$errorMsg = "<u>ERROR:</u><br />Your Email address is already in use inside our system. Please try another.";
	} else {
		// Add MD5 Hash to the password variable
       $hashedPass = md5($password); 
		// Add user info into the database table, claim your fields then values 
		$sql = "INSERT INTO members (username, country, state, city, email, password, signupdate) 
		VALUES ('$username','$country','$state','$city','$email','$hashedPass', now())" or die (mysqli_error());
		$query = mysqli_query($db_conx, $sql);
		// Get the inserted ID here to use in the activation email
		$id = mysqli_insert_id();
		// Create directory(folder) to hold each user files(pics, MP3s, etc.) 
		mkdir("memberFiles/$id", 0755); 
		// Start assembly of Email Member the activation link
		$to = "$email";
		// Change this to your site admin email
		$from = "[email protected]";
		$subject = "Complete your registration";
		//Begin HTML Email Message where you need to change the activation URL inside
		$message = '<html>
		<body bgcolor="#FFFFFF">
		Hi ' . $username . ',
		<br /><br />
		You must complete this step to activate your account with us.
		<br /><br />
		Please click here to activate now >>
		<a href="http://www.somewebsite.com/activation.php?id=' . $id . '">
		ACTIVATE NOW</a>
		<br /><br />
		Your Login Data is as follows: 
		<br /><br />
		E-mail Address: ' . $email . ' <br />
		Password: ' . $password . ' 
		<br /><br /> 
		Thanks! 
		</body>
		</html>';
		// end of message
		$headers = "From: $from\r\n";
		$headers .= "Content-type: text/html\r\n";
		$to = "$to";
		// Finally send the activation email to the member
		mail($to, $subject, $message, $headers);
		// Then print a message to the browser for the joiner 
		print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />
		We just sent an Activation link to: $email<br /><br />
		<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />
		Link inside the message. After email activation you can log in.";
		exit(); // Exit so the form and page does not display, just this success message
	} // Close else after database duplicate field value checks
  } // Close else after missing vars check
} //Close if $_POST
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Member Registration</title>
</head>
<body>
<table width="600" align="center" cellpadding="4">
  <tr>
    <td width="7%">REGISTER AS A MEMBER HERE </td>
  </tr>
</table>
<table width="600" align="center" cellpadding="5">
  <form action="join_form.php" method="post" enctype="multipart/form-data">
    <tr>
      <td colspan="2"><font color="#FF0000"><?php echo "$errorMsg";?></font></td>
    </tr>
    <tr>
      <td width="163"><div align="right">User Name:</div></td>
      <td width="409"><input name="username" type="text" value="<?php echo "$username";?>" /></td>
    </tr>
    <tr>
      <td><div align="right">Country:</div></td>
      <td><select name="country">
      <option value="<?php echo "$country";?>"><?php echo "$country";?></option>
      <option value="Australia">Australia</option>
      <option value="Canada">Canada</option>
      <option value="Mexico">Mexico</option>
      <option value="United Kingdom">United Kingdom</option>
      <option value="United States">United States</option>
      <option value="Zimbabwe">Zimbabwe</option>
      </select></td>
    </tr>
    <tr>
      <td><div align="right">State: </div></td>
      <td><input name="state" type="text" value="<?php echo "$state";?>" /></td>
    </tr>
    <tr>
      <td><div align="right">City: </div></td>
      <td>
        <input name="city" type="text" value="<?php echo "$city";?>" />
      </td>
    </tr>
    <tr>
      <td><div align="right">Email: </div></td>
      <td><input name="email" type="text" value="<?php echo "$email";?>" /></td>
    </tr>
    <tr>
      <td><div align="right"> Password: </div></td>
      <td><input name="password" type="password" value="<?php echo "$password";?>" /> 
      <font size="-2" color="#006600">(letters or numbers only, no spaces no symbols)</font></td>
    </tr>
    <tr>
      <td><div align="right"> Captcha: </div></td>
      <td>Add Captcha Here for security</td>
    </tr>    
    <tr>
      <td><div align="right"></div></td>
      <td><input type="submit" name="Submit" value="Submit Form" /></td>
    </tr>
  </form>
</table>
</body>
</html>

any help would be much appreciated.

 

Thanks

 

Link to comment
https://forums.phpfreaks.com/topic/275501-mysqli-errors-all-over-the-input-fields/
Share on other sites
drewdan Newbie

drewdan

Posted
Posted

You set the errors to E_ALL, which displays everything, even errors that do not actually mean much. Because your variable was undefined, the error was pointing this out. For example, if you have a form on a page and you have some php script on the same page that will receive the data and process it with a line of code like:

 

$variable = $_GET['form_item'];
 

If the $_GET is not collecting any data because the form has not been submitted, you will get a nice error. I often use this:

 

$action= isset($_REQUEST['action']) ? $_REQUEST['action'] : null;
 

That stops the error for me.

 

Hope that helps!


 

crf1121359 Member

crf1121359

Posted
  • Author
Posted (edited)

i think i already said  i've fixed it before you posted your comment mate. i use E_ALL because i want to run a script which is absolutely error free and its clean. cant risk using a script with so many hidden errors running in the background!

 

the issue was none of the ones you mentioned! as i posted above before your post,  i fixed it by this like: <?php if (!empty($username)) {echo $username;}?>

 

thanks anyway

Edited by crf1121359
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.