 |  |  |  |  |  |  |  |
php wont submit data into the database
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
[php]<?
$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>";
}
?>[/php]
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
$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>";
}
?>[/php]
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
PHP Syntax (Toggle Plain Text)
Dont forget to spread the reputation to those that deserve!
$results = mysql_query($sqlquer y); //Query the results
if(!$results){
echo(mysql_error());
}
if(!$results){
echo(mysql_error());
}
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
•
•
•
•
Originally Posted by Arizona Web
$results = mysql_query($sqlquer y); //Query the results
if(!$results){
echo(mysql_error());
}
here are the results.
Column count doesn't match value count at row 1
(heres a screenshot of what the database looks like)
•
•
•
•
Originally Posted by Killer_Typo
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)
Last edited by samaru; Jun 15th, 2004 at 1:57 am.
Dont forget to spread the reputation to those that deserve!
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.
Need a website designer? arizona web design : phoenix web design : MCP Media intelligent web design and web development solutions. MCP Media is owned and operated by Chris Hooley - who happens to be a real nerd... on purpose :-)
•
•
•
•
Originally Posted by Killer_Typo
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.
Check out my blog at http://www.shinylight.com for more stuff about web dev.
|
Similar Threads
- Data not going into my database??! plz help (PHP)
- Importing data from one database to another (PHP)
- Problem inserting data into Access database via php (PHP)
- Cannot get php script to enter data (MySQL)
Other Threads in the PHP Forum
- Previous Thread: PHP Sessions on IIS
- Next Thread: phpbb2.X news?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array auto beginner binary broken cache cakephp checkbox class cms code codingproblem cron curl customizableitems database date display dynamic echo email error errorlog file files filter folder form format forms forum function functions gc_maxlifetime global google headmethod href htaccess html image include insert ip javascript joomla limit link login mail malfunctioning memmory memory menu method mlm multiple mysql nodes oop parameter parsing paypal pdf php phpmysql popup query radio random recursion recursiveloop remote script search select server sessions snippet source space sql static survey syntax system table trouble tutorial up-to-date update upload url validator variable video web youtube
