Hello to all:
I am getting the following error message when trying to insert data from
an html form into a MYSQL database that I recently created. Can someone
take a look at the errors and corresponding code and suggest some
alternatives?
Thank you very much in advance for your assistance.
Regards,
Chris McCourt
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++
Error Message:
Notice: Undefined index: Store_ID in c:\program files\apache
group\apache\htdocs\insertdata.php on line 9
Notice: Undefined index: Postal_Code in c:\program files\apache
group\apache\htdocs\insertdata.php on line 14
Notice: Undefined index: Cert_Org in c:\program files\apache
group\apache\htdocs\insertdata.php on line 17
Notice: Undefined index: Cert_Level_ID in c:\program files\apache
group\apache\htdocs\insertdata.php on line 18
Notice: Undefined index: Cert_Date in c:\program files\apache
group\apache\htdocs\insertdata.php on line 19
Notice: Undefined index: Emerg_Contact_Name in c:\program files\apache
group\apache\htdocs\insertdata.php on line 20
Notice: Undefined index: Emerg_Contact_Phone in c:\program files\apache
group\apache\htdocs\insertdata.php on line 21
Error: Unable to execute insertion query.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
Original PHP Code:
<HTML>
<HEAD>
<TITLE> Inserting Data Into a Database</TITLE>
<BODY>
<?php
/* This page receives and handles the data generated
by the form "Insert_Table_Form.html"*/
$Store = ($_POST['Store_ID']);
$Users = ($_POST['User_Name']);
$Pass = ($_POST['Password']);
$Addr = ($_POST['Address']);
$State = ($_POST['State']);
$Post = ($_POST['Postal_Code']);
$Phone = ($_POST['Phone']);
$Email = ($_POST['EMail']);
$Certor = ($_POST['Cert_Org']);
$Certl = ($_POST['Cert_Level_ID']);
$Certd = ($_POST['Cert_Date']);
$Emergn = ($_POST['Emerg_Contact_Name']);
$Emergp = ($_POST['Emerg_Contact_Phone']);
//Set the variables for the database access:
$Host = "localhost";
$User = "root";
$Password = "";
$Link = mysql_connect($Host, $User, $Password)
or die("Could not connect: " . mysql_error());
mysql_select_db('dive_store') or die("could not select database");
$sql = mysql_query("INSERT INTO test_scores VALUES (NULL,
'$Store', '$Users', '$Pass', '$Addr', '$State', '$Post',
'$Phone', '$Email', '$Certor', '$Certd', '$Certl',
'$Emergn', '$Emergp')")
or die('Error: Unable to execute insertion query.');
$Result = mysql_query($sql)or die(mysql_error());
if ($Result){
echo("Table Created successfully");
}else{
echo("error when creating table");
}
mysql_close($Link);
?>
</BODY>
</HEAD>
</HTML>
