it will write the data to the next page but it will not write it to the mysql
database. i do not know what i am doing wrong and everything i have
read says that it should work. any help or ideas would be great
Code: Select all
<?php
$host="localhost";
$user="root";
$password="";
$database="terminal_testing";
mysql_connect($host,$user,$password)or die("Can not connect DB");
mysql_select_db($database) or die( "Unable to select database");
mysql_query("INSERT INTO setup_page_1(testid, tdate, brand, model, app, ver, visa1, visa2, visa3, visa4, visa5, visa6, visa7, master1, discover1, amex1, amex2, txdl1, txdl2, txdl3)
values('$_POST[Testid]', '$_POST[Tdate]', '$_POST[Brand]', '$_POST[Model]', '$_POST[App]','$_POST[Ver]', '$_POST[checkbox1]', '$_POST[checkbox2]', '$_POST[checkbox3]', '$_POST[checkbox4]', '$_POST[checkbox5]', '$_POST[checkbox6]', '$_POST[checkbox7]', '$_POST[checkbox8]', '$_POST[checkbox9]', '$_POST[checkbox10]', '$_POST[checkbox11]', '$_POST[checkbox12]', '$_POST[checkbox13]', '$_POST[checkbox14]')");
echo "1 record added";
mysql_close();
?>
<form>
<p>Test ID: <?php echo $_POST["Testid"]; ?><br />
Test Date: <?php echo $_POST["TestDate"]; ?><br />
Brand: <?php echo $_POST["Brand"]; ?><br />
Model: <?php echo $_POST["Model"]; ?><br />
App: <?php echo $_POST["App"]; ?><br />
Ver: <?php echo $_POST["Ver"]; ?><br />
Visa 1: <?php echo $_POST["checkbox1"]; ?><br />
Visa 2: <?php echo $_POST["checkbox2"]; ?><br />
Visa 3: <?php echo $_POST["checkbox3"]; ?><br />
Visa 4: <?php echo $_POST["checkbox4"]; ?><br />
Visa 5: <?php echo $_POST["checkbox5"]; ?><br />
Visa 6: <?php echo $_POST["checkbox6"]; ?><br />
Visa 7: <?php echo $_POST["checkbox7"]; ?><br />
MC 1: <?php echo $_POST["checkbox8"]; ?><br />
DS 1: <?php echo $_POST["checkbox9"]; ?><br />
Amex 1: <?php echo $_POST["checkbox10"]; ?><br />
Amex 2: <?php echo $_POST["checkbox11"]; ?><br />
TXDL 1: <?php echo $_POST["checkbox12"]; ?><br />
TXDL 2: <?php echo $_POST["checkbox13"]; ?><br />
TXDL 3: <?php echo $_POST["checkbox14"]; ?></p>
</form>