insert into statment insters a blank row
Posted: Thu Jan 31, 2008 10:43 am
I have insert statement that inserts a blank row. I have the primary key that is autoincremented . so after i hit submit i check the table and it has a new row with the next number but all the other fields are blank. I don't get any errors form the .mysql_error(). I am just starting with php so i am sure this code has other issues.
here is my code
<?php
$db_host = "localhost";
$db_user = "test";
$db_pwd = "test";
$db_name = "TreoStatus";
mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name);
?>
<html>
<head>
<title>Treo Status</title>
</head>
<body>
<?php
if (!isset($_POST['submit'])) {
?>
<form action="" method="post">
PhoneNumer: <input type="text" name="PhoneNumber"><br>
Problem: <input type="text" name="Problem"><br>
Status: <input type="text" name="Status"><br>
DateSentOut: <input type="text" name="DateSentOut"><br>
DateReturned: <input type="text" name="DateReturned"><br>
EsnHex: <input type="text" name="EsnHex"><br>
EsnDec: <input type="text" name="EsnDec"><br>
Notes: <input type="text" name="Notes"><br>
<input type="submit" name="submit" value="Submit!">
<?php
} else {
mysql_query("INSERT INTO `RepairStatus` (RepairID, PhoneNumber, Problem, Status, DateSentOut, DateReturned, EsnHex, EsnDec, Notes) VALUES ('', '$PhoneNumber', '$Problem', '$Status', '$DateSentOut', '$DateReturned','$EsnHex', '$EsnDec', '$Notes')") or die ('cannot complete query ' . mysql_error());
echo "Success! ";
}
?>
here is my code
<?php
$db_host = "localhost";
$db_user = "test";
$db_pwd = "test";
$db_name = "TreoStatus";
mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name);
?>
<html>
<head>
<title>Treo Status</title>
</head>
<body>
<?php
if (!isset($_POST['submit'])) {
?>
<form action="" method="post">
PhoneNumer: <input type="text" name="PhoneNumber"><br>
Problem: <input type="text" name="Problem"><br>
Status: <input type="text" name="Status"><br>
DateSentOut: <input type="text" name="DateSentOut"><br>
DateReturned: <input type="text" name="DateReturned"><br>
EsnHex: <input type="text" name="EsnHex"><br>
EsnDec: <input type="text" name="EsnDec"><br>
Notes: <input type="text" name="Notes"><br>
<input type="submit" name="submit" value="Submit!">
<?php
} else {
mysql_query("INSERT INTO `RepairStatus` (RepairID, PhoneNumber, Problem, Status, DateSentOut, DateReturned, EsnHex, EsnDec, Notes) VALUES ('', '$PhoneNumber', '$Problem', '$Status', '$DateSentOut', '$DateReturned','$EsnHex', '$EsnDec', '$Notes')") or die ('cannot complete query ' . mysql_error());
echo "Success! ";
}
?>