RE: [PHP-DB] Undefined Index error when trying to insert data fro m a form into a db

Chris, It appears that the indices called out in the lines of error code are not being transferred from the Insert_Table_Form.html page and that is causing the query to ultimately fail. Almost self-explanatory due to PHP's good error reporting. First make certain that the names of the form controls on the INsert_Table_Form.html page match up exactly with the names in your code on lines 9 through 21. Secondly, make sure each of the controls has a value when you attempt to post the data from Insert_Table_Form.html. Some form controls will not appear in the $_POST['indices'] array if they do not contain a value and when you try to reference those empty controls, they cause problems because they were never posted. Hope this helps. Rich > -----Original Message----- > From: Christopher McCourt [mailto:cmccourt@tampabay.rr.com] > Sent: Thursday, June 26, 2003 12:54 PM > To: PHP Lists > Subject: [PHP-DB] Undefined Index error when trying to insert > data from > a form into a db > > > 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> > >