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>
 

Reply via email to