0
<?
$DBhost = "localhost";//location of mySQL on server/site
$DBuser = "michael";//User name for logging onto mySQL
$DBpass = "";//Password for logging onto mySQL
$DBName = "user_login_info";//Name of the databse for logging into
$table = "login_info";//Name of the Table to be used steps to create are included
$name = "$_POST[name]";//Name that the person gave on the form
$email = "$_POST[email]";//Email that person gave on the form
$con_email = "$_POST[confirm_email]";//confirm their email is correct
$sex = "$_POST[sex]";//sex of the person
$month = "$_POST[month]";//month person was born
$day = "$_POST[day]";//day person was born
$year = "$_POST[year]";//year person was born

  
  if ($email != $con_email)
	{
	 echo "sorry the emails you provided do not match!<br />";
	 echo "Please use the back button to correct this error and resubmit<br />";
	}
  else
	{ 
	 mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");  //connecting to the database using the variable set
	 @mysql_select_db("$DBName") or die("Unable to select database $DBName");		 //at connection to the databse select DBNAME (phpforms) or tell that it couldnt connect
	 $sqlquery = "INSERT INTO $table VALUES('$id','$name','$email','$email','$con_email','$sex','$month','$day','$year')"; //Telling the mySQL to insert the values from the form into the databse coresponding with the form
   
	 $results = mysql_query($sqlquery);  //Query the results
   
	 mysql_close();  
   
	  echo "   
	   <html>
	   <head>
		<title> Registerd Data </title>
	   </head>
	   <body>
		<center>
		  <table border='0' width='500'>
		   <tr>";
   
	  echo "	 <td>
			 <font face='verdana' size='+0'> 
			 <center>
			  <p>You Just Entered This Information Into the Database</p>
			 </center>";
			  //display the information that user submitted in the previous form
	  echo "	   <blockquote>
			  <center>
			   <p>
			   Name : $name 
			   </p> 
			   <p>
			   E-Mail : $email 
			   </p> 
			   <p>
			   Sex : $sex
			   </p>
			   <p>
			   Birthdate: $month / $day / $year
			   </p>
			  </center>
			  </blockquote>
			</td>
		   </tr>
		  </table> 
		 </center>
		 </body>
		 </html>";
	}
?>

for some reason i cant get this to submit any data into to my database, ive been trying to create a sort of registration form, so i modified the tutorial that i had been working on, but now it wont send the data to my database, but it will display the information that i have entered at the bottom of the screen (the info is displayed in the 'echo' areas.

heres the code for the form if you need to see that too

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Handling forms with PHP</title>
</head>
<body>
<center> 
<form method="post" action="confirm_reg.php"> 
 <table border="1"> 
  <tr>
   <td colspan="2">
	 Please Register to continue!
   </td>
  </tr> 
  <tr>
   <td>
   </td>
  </tr> 
  <tr>
   <td align="left">
	<p><b>  Your Name:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="name" id="name"></p>
	<p><b> E-Mail Address:</b>&nbsp;&nbsp;&nbsp;<input type="text" name="email" id="email"></p>
	<p><b> E-Mail Again:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="confirm_email" id="confirm_email"></p>
	<p><b> Sex:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	  <select name="sex" id="sex">
	   <option value="unknown">
		Unknown
	   </option> 
	   <option value="male">
		Male
	   </option> 
	   <option value="female">
		Female
	   </option> 
	  </select></p>
	<p><b> Birthdate:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<input type="text" size="2" maxlength="2" name="month" id="month">/
	<input type="text" size="2" maxlength="2" name="day" id="day">/
	<input type="text" size="4" maxlength="4" name="year" id="year"></p>
   </td> 
  </tr>
  <tr>
   <td colspan="2">
	<input type="submit" value="Tell us!">
   </td>
  </tr>
 </table>
</form>
</center>
</body>
</html>
3
Contributors
4
Replies
6
Views
13 Years
Discussion Span
Last Post by samaru
0

$results = mysql_query($sqlquer y); //Query the results

if(!$results){
echo(mysql_error());
}

thank you thank you thank you.

here are the results.

Column count doesn't match value count at row 1

(heres a screenshot of what the database looks like)

thank you thank you thank you.

here are the results.

Column count doesn't match value count at row 1

(heres a screenshot of what the database looks like)

srry for the double post, but i figured it out, i had accidently included $email twice, once removing the second $email it all worked out. thanks arizona web for the help, i wouldnt have thought to double check that if i hadnt seen the error that i got.

Attachments database_picture.JPG 71.4 KB
0

NP bud. While I am developing I always echo errors after every SQL statement in PHP and keep debug on in other languages. Makes it easier to know off the bat where the problems are.

0

srry for the double post, but i figured it out, i had accidently included $email twice, once removing the second $email it all worked out. thanks arizona web for the help, i wouldnt have thought to double check that if i hadnt seen the error that i got.

Glad you were able to figure it out, but please use the "edit" button to modify your post. It doesn't take very long. It's the second time, that I know of, that you double post. I don't want to be a bit**, but obey the rules.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.