<?
$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> <input type="text" name="name" id="name"></p>
<p><b> E-Mail Address:</b> <input type="text" name="email" id="email"></p>
<p><b> E-Mail Again:</b> <input type="text" name="confirm_email" id="confirm_email"></p>
<p><b> Sex:</b>
<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>
<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>
