can not write to my sql DB
Posted: Wed Apr 29, 2009 2:20 pm
i taking data from a from i created and when i click on the submit button
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
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>