I have a script, it gets no errors, yet when I enter in the information and press enter it loops back and doesn't say the data has been entered nor does it show up in the database. Here is the script, and here is a live version. http://www.kaboomlabs.com/PDI/ Now as far as I can tell this works, I know I'm missing something, if someone could tell me what I am missing it would be greatly appreciated. <?require_once('connectvars.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>PDI Non-Conforming Materials Report</title> <link rel="stylesheet" type="text/css" href="pdi.css" /> </head> <body> <div id="logo"> <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" /> </div> <div id="title"> <h2>Non-Conforming Materials Report (NCMR)</h2> </div> <?php // Grab the score data from the POST if (isset($_POST['submit'])) $Added_By = $_POST['Added_By']; $Added_By_Date = $_POST['Added_By_Date']; $Nexx_Part = $_POST['Nexx_Part']; $Nexx_Part_Description = $_POST['Nexx_Part_Description']; $NCMR_Qty = $_POST['NCMR_Qty']; $Nexx_Inventory_Chk = $_POST['Nexx_Inventory_Chk']; $Supplier_Name = $_POST['Supplier_Name']; $Supplier_Number = $_POST['Supplier_Number']; $Manufacturer_Part_Number = $_POST['Manufacturer_Part_Number']; $Manufacturer_Serial_Number = $_POST['Manufacturer_Serial_Number']; $NCMR_ID = $_POST['NCMR_ID']; $Nonconformity = $_POST['Nonconformity']; $Disposition = $_POST['Disposition']; $Comments = $_POST['Comments']; $CommentsAdditional_Details = $_POST['CommentsAdditional_Details']; $PO = $_POST['PO']; $PO_Date = $_POST['PO_Date']; $Date_Received = $_POST['Date_Received']; if (!empty($Added_By) && !empty($Added_By_Date) && !empty($Nexx_Part) && !empty($Nexx_Part_Description) && !empty($NCMR_Qty) && !empty($Nexx_Inventory_Chk) && !empty($Supplier_Name) && !empty($Supplier_Number) && !empty($Manufacturer_Part_Number) && !empty($Manufacturer_Serial_Number) && !empty($NCMR_ID) && !empty($Nonconformity) && !empty($Disposition) && !empty($Comments) && !empty($CommentsAdditional_Details) && !empty($PO) && !empty($PO_Date) && !empty($Date_Received)) { //Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // The username is unique, so insert the data into the database $query = "INSERT INTO ncmrtest (0, Added_By, Added_By_Date, Nexx_Part, Nexx_Part_Description, NCMR_Qty, Nexx_Inventory_Chk, Supplier_Name, Supplier_Number, Manufacturer_Part_Number, Manufacturer_Serial_Number, NCMR_ID, Nonconformity, Disposition, Comments, CommentsAdditional_Details, PO, PO_Date, Date_Received) VALUES ('$id', '$Added_By', '$Added_By_Date', '$Nexx_Part', '$Nexx_Rev', '$Nexx_Part_Description', '$NCMR_Qty', '$JO', '$SN', '$INV', '$Nexx_Inventory_On_Hand', '$Nexx_Inventory_Chk', '$Supplier_Name', '$Supplier_Number', '$Manufacturer_Part_Number', '$Manufacturer_Serial_Number', '$NCMR_ID', '$Nonconformity', '$Disposition', '$Comments', '$CommentsAdditional_Details', '$PO', '$PO_Date', '$Date_Received')"; mysqli_query($dbc, $query); //Confirm success with the user echo '<p>Thank You for entering in the NCMR Data, the correct person will be notified of its entry, and the data will be reviewed by the appropriate people.</p>'; echo '<p><strong>NCMR ID:</strong> ' . $NCMR_ID . '<br />'; echo '<p><strong>Part:</strong> ' . $Nexx_Part_Description . '<br />'; echo '<p><strong>Added On Date:</strong> ' . $Added_By_Date . '<br />'; //Clear the data from the form $Added_By = ""; $Added_By_Date = ""; $Nexx_Part = ""; $Nexx_Part_Description = ""; $NCMR_Qty = ""; $Nexx_Inventory_Chk = ""; $Supplier_Name = ""; $Supplier_Number = ""; $Manufacturer_Part_Number = ""; $Manufacturer_Serial_Number = ""; $NCMR_ID = ""; $Nonconformity = ""; $Disposition = ""; $Comments = ""; $CommentsAdditional_Details = ""; $PO = ""; $PO_Date = ""; $Date_Received = ""; mysqli_close($dbc); } ?> <form id="all" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <fieldset> <div id ="added"> <label>Added By:</label> <input type="text" name="Added_By" value="<? if (!empty($Added_By)) echo $Added_By; ?>" /> <label>on:</label> <input type="text" name="Added_By_Date" value="<? if (!empty($Added_By_Date)) echo $Added_By_Date; ?>" /> </div> <div id="box"> <div id ="part"> <label>Nexx Part:</label> <input type="text" name="Nexx_Part" value="<? if (!empty($Nexx_Part)) echo $Nexx_Part; ?>" /><br /> <label>Nexx Rev:</label> <input type="text" name="Nexx_Rev" value="<? if (!empty($Nexx_Rev)) echo $Nexx_Rev; ?>" /><br /> <label>Nexx Part Description:</label> <textarea name="Nexx_Part_Description" rows="4" cols="16" value="<? if (!empty($Nexx_Part_Description)) echo $Nexx_Part_Description; ?>"></textarea><br /> <label>NCMR Qty:</label> <input type="text" name="NCMR_Qty" value="<? if (!empty($NCMR_Qty)) echo $NCMR_Qty; ?>" /> <div id ="jo"> <br /> <label>JO:</label><br /> <input type="text" name="JO" size="3" value="<? if (!empty($JO)) echo $JO; ?>" /> </div> <div id ="sn"> <br /> <label>SN:</label><br /> <input type="text" name="SN" size="3" value="<? if (!empty($SN)) echo $SN; ?>" /> </div> <div id ="inv"> <br /> <label>INV:</label> <br /> <input type="text" name="INV" size="3" value="<? if (!empty($INV)) echo $INV; ?>" /> </div> </div> <div id ="manu"> <label>Nexx Inventory On Hand:</label> <input type="text" name="Nexx_Inventory_On_Hand" value="<? if (!empty($Nexx_Inventory_On_Hand)) echo $Nexx_Inventory_On_Hand; ?>" /><br /> <label>Nexx Inventory Chk:</label> <input type="text" name="Nexx_Inventory_Chk" value="<? if (!empty($Nexx_Inventory_Chk)) echo $Nexx_Inventory_Chk; ?>" /><br /> <label>Supplier Name:</label> <textarea name="Supplier_Name" rows="4" cols="16" value="<? if (!empty($Supplier_Name)) echo $Supplier_Name; ?>"></textarea><br /> <label>Supplier Number:</label> <input type="text" name="Supplier_Number" value="<? if (!empty($Supplier_Number)) echo $Supplier_Number; ?>" /><br /> <label>Manufacturer Part Number:</label> <input type="text" name="Manufacturer_Part_Number" value="<? if (!empty($Manufacturer_Part_Number)) echo $Manufacturer_Part_Number; ?>" /><br /> <label>Manufacturer Serial Number: </label> <input type="text" name="Manufacturer_Serial_Number" value="<? if (!empty($Manufacturer_Serial_Number)) echo $Manufacturer_Serial_Number; ?>" /> <br /> <label>NCMR ID:</label> <input type="text" name="NCMR_ID" value="<? if (!empty($NCMR_ID)) echo $NCMR_ID; ?>" /> </div> </div> <div id="box2"> <label>Nonconformity: (Be Specific)</label><br /> <textarea name="Nonconformity" rows="3" cols="85" value="<? if (!empty($Nonconformity)) echo $Nonconformity; ?>"></textarea><br /> <label>Disposition: (Initiator)</label><br /> <textarea name="Disposition" rows="3" cols="85" value="<? if (!empty($Disposition)) echo $Disposition; ?>"></textarea><br /> <label>Comments:</label><br /> <textarea name="Comments" rows="3" cols="85" value="<? if (!empty($Comments)) echo $Comments; ?>"></textarea><br /> <label>Comments and Additional Details:</label><br /> <textarea name="CommentsAdditional_Details " rows="3" cols="85" <? if (!empty($CommentsAdditional_Details)) echo $CommentsAdditional_Details; ?>></textarea><br /> <div id ="po"> <br /> <label>PO:</label><br /> <input type="text" name="PO" size="7" value="<? if (!empty($PO)) echo $PO; ?>" /> </div> <div id ="pod"> <br /> <label>PO Date:</label><br /> <input type="text" name="PO_Date" size="7" value="<? if (!empty($PO_Date)) echo $PO_Date; ?>" /> </div> <div id ="dr"> <br /> <label>Date Recieved:</label><br /> <input type="text" name="Date_Recieved" size="7" value="<? if (!empty($Date_Recieved)) echo $Date_Recieved; ?>" /> </div> </div> <div id="button"> <input type="submit" value="Submit NCMR" name="submit" /> </div> </Fieldset> </form> </body> </html> Code (markup):
Try putting brackets round your first if statement.At line: if (isset($_POST['submit'])) Code (markup): Make it: if (isset($_POST['submit'])){ Code (markup): and change line: mysqli_close($dbc);} Code (markup): to: mysqli_close($dbc);}} Code (markup): That may fix it.