Good morning,
I have a form that I am INSERTing into the MySQL database. I have the names and vaules set. The columns header is the same but when I "submit" the form it adds a blank record to the database. If I add another one, another blank record is added.
<?php
$errors=array();
if(isset($_REQUEST['submit'])){ // If the form was submitted
validate_input(); // Check for empty fields
if(count($errors) != 0){ // If there are errors,
// redisplay the form
display_form();
}
else{ preview_form(); }
}
else{display_form();} // Display the form for the first time
if(isset($_REQUEST['final'])){
submit_final();
}
if($_REQUEST['go_back']){
validate_input();
}
function validate_input(){
global $errors;
if ($_POST["first_name"] == "") {
$errors['first_name']="<font color='red'>
Please enter your First Name.</font>";
}
if ($_POST["last_name"] == "") {
$errors['last_name']="<font color='red'>
Please enter your Last Name.</font>";
}
if ($_POST["street"] == "") {
$errors['street']="<font color='red'>
Please enter your Street Address.</font>";
}
if ($_POST["city"] == "") {
$errors['city']="<font color='red'>
Please enter your City.</font>";
}
if ($_POST["state"] == "") {
$errors['state']="<font color='red'>
Please select your State.</font>";
}
if ($_POST["zip_code"] == "") {
$errors['zip_code']="<font color='red'>
Please enter your Zip Code.</font>";
}
if ($_POST["vehicle_year"] == "") {
$errors['vehicle_year']="<font color='red'>
Please enter the Year of the Vehicle.</font>";
}
if ($_POST["vehicle_make"] == "") {
$errors['vehicle_make']="<font color='red'>
Please enter the Make of the Vehicle.</font>";
}
if ($_POST["vehicle_model"] == "") {
$errors['vehicle_model']="<font color='red'>
Please enter the Model of the Vehicle.</font>";
}
if ($_POST["vin"] == "") {
$errors['vin']="<font color='red'>
Please enter the Vehicle Identification Number.</font>";
}
}
function display_form () {
global $errors;
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
First Name: <br />
<input type="text" name="first_name" value="<?php echo $_POST[first_name]; ?>"><br />
<?php echo $errors['first_name']; ?><br />
Last Name: <br />
<input type="text" name="last_name" value="<?php echo $_POST[last_name]; ?>"><br />
<?php echo $errors['last_name']; ?><br />
Address: <br />
<input type="text" name="street" value="<?php echo $_POST[street]; ?>"><br />
<?php echo $errors['street']; ?><br />
City: <br />
<input type="text" name="city" value="<?php echo $_POST[city]; ?>"><br />
<?php echo $errors['city']; ?><br />
State: <br />
<input type="text" name="state" value="<?php echo $_POST[state]; ?>"><br />
<?php echo $errors['state']; ?><br />
Zip Code: <br />
<input type="text" name="zip_code" value="<?php echo $_POST[zip_code]; ?>"><br />
<?php echo $errors['zip_code']; ?><br />
Vehicle Year: <br />
<input type="text" name="vehicle_year" value="<?php echo $_POST[vehicle_year]; ?>"><br />
<?php echo $errors['vehicle_year']; ?><br />
Vehicle Make: <br />
<input type="text" name="vehicle_make" value="<?php echo $_POST[vehicle_make]; ?>"><br />
<?php echo $errors['vehicle_make']; ?><br />
Vehicle Model: <br />
<input type="text" name="vehicle_model" value="<?php echo $_POST[vehicle_model]; ?>"><br />
<?php echo $errors['vehicle_model']; ?><br />
Vehicle Identification Number: <br />
<input type="text" name="vin" value="<?php echo $_POST[vin]; ?>"><br />
<?php echo $errors['vin']; ?><br />
<input type="reset">
<input type="submit" name="submit">
</form>
<?php
}
function preview_form() {
$first_name=$_POST[first_name];
$last_name=$_POST[last_name];
echo "First Name: $first_name </br>";
echo "Last Name: $last_name";
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input name="go_back" type="submit" value="Go Back">
<input name="final" type="submit" value="Submit">
</form>
<?php
}
function submit_final() {
require ('get_connected.php');
mysql_query ("INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, vehicle_model, vin) " .
"VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', '$vehicle_year', '$vehicle_make', '$vehicle_model', '$vin')") or die('Error In Query: '.mysql_error());
echo "Thank You. Your request has been submitted.";
}
?>
I can't locate the error or find out why it's adding a blank record. I was also wondering how I would have a timestamp entered? Do I just make a column in MySQL and add then make the type "timestamp"?
Thanks in advance.
