Help! This form is not doing anything. When you click submit it clears all the fields and does not submit the data. http://www.vincentmerlino.com/add_relative.php
<?PHP
// File; add_relative.php
require('common.inc');
//Open a connection to the MySQL family database.
$db = @mysql_connect("localhost", "webman", "ssilly")
or fatal_mysql_msg("Cannot connect to MySQL server.");
@mysql_select_db("family")
or fatal_mysql_msg("Cannot open family database.");
function is_valid_dob($dob)
{
// validate YYYY-MM-DD format
if (strlen($dob) != 10 ||
substr($dob, 4, 1) != '-' ||
substr($dob, 7, 1) != '-')
return 0;
//validate day
$day = substr($dob, 8, 2);
if ($day < 1 || $day >31)
return 0;
//validate month
$month = substr($dob, 5, 2);
if ($month < 1 || $month > 12)
return 0;
//validate year
$year = substr($dob, 0, 4);
if ($year < 1900)
return 0;
$date_array = getdate(mktime());
if ($year > $date_array[year])
return 0;
return 1;
}
if ($REQUEST_METHOD == 'POST')
{
$form_error = 0;
$error_msg == "";
//Verify required information
if (strlen($first_name) < 3)
{
$form_error = 1;
$error_msg .= "First name must be >= 3 characters.<BR>\n";
}
if (strlen($last_name) < 3)
{
$form_error = 1;
$error_msg .= "Last name must be >= 3 characters.<BR>\n";
}
if (strlen($dob) > 0 && !is_valid_dob($dob))
{
$form_error = 1;
$error_msg .= "The dob is not valid.<BR>\n";
}
if (strlen($street) < 3)
{
$form_error = 1;
$error_msg .= "Street must be >= 3 characters.<BR>\n";
}
if (strlen($city) < 3)
{
$form_error = 1;
$error_msg .= "City must be >= 3 characters.<BR>\n";
}
if (strlen($zip) != 5)
{
$form_error = 1;
$error_msg .= "Zip code must be in five digit format.<BR>\n";
}
if (!$form_error)
{
$sql = "INSERT INTO relatives ";
$sql .= "(first_name, last_name, xmas, dob, ";
$sql .= "street, city, state, zip) VALUES ";
$sql .= "('$first_name', '$last_name', $xmas, '$dob', ";
$sql .= "'$street', '$city', '$state', '$zip')";
@($sql)
or fatal_mysql_msg("Query Failed.");
echo "<HTML><BODY>The form completed sucessfully.<BR>";
echo "<Please return to <A HREF='test.php'> here</A>.";
mysql_close($db);
exit;
}
}
?>
<HTML>
<HEAD>
<TITLE>Add/Modify Relative</TITLE>
</HEAD>
<BODY>
<H1>Please fill out form</H1>
<?PHP
if ($form_error)
{
echo "The following errors exist in the form:<BR>\n";
echo "<B>".$error_msg."</B><BR>\n";
}
?>
<FORM METHOD='POST' ACTION='add_relative.php'>
<TABLE>
<TR>
<TD>First Name:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='first_name'
VALUE='<?PHP echo $first_name; ?>'>
</TD>
</TR>
<TR>
<TD>Last Name:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='last_name'
VALUE='<?PHP echo $last_name; ?>'>
</TD>
</TR>
<TR>
<TD>XMAS:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='xmas'
VALUE='<?PHP echo $xmas; ?>'>
</TD>
</TR>
<TR>
<TD>Date of Birth:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='dob'
VALUE='<?PHP echo $dob; ?>'>
</TD>
</TR>
<TR>
<TD>Street:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='street'
VALUE='<?PHP echo $street; ?>'>
</TD>
</TR>
<TR>
<TD>City:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='city'
VALUE='<?PHP echo $city; ?>'>
</TD>
</TR>
<TR>
<TD>State:</TD>
<TD>
<SELECT SIZE='1' NAME='state'
VALUE='<?PHP echo $state; ?>'>
<?PHP
//Creates a list of states from the states table.
$sql = "SELECT code FROM states";
$states = @($sql)
or fatal_mysql_msg("Cannot perform query.");
while ($state = mysql_fetch_array($states))
echo "<OPTION>".$state['code']."</OPTION>";
echo "\n";
?>
</SELECT>
</TD>
</TR>
<TR>
<TD>zip:</TD>
<TD>
<INPUT TYPE='TEXTBOX' SIZE='20' NAME='zip'
VALUE='<?PHP echo $zip; ?>'>
</TD>
</TR>
</TABLE>
<BR>
<INPUT TYPE='SUBMIT' VALUE='Submit Relative'>
</FORM>
</BODY>
</HTML>
<?PHP
mysql_close($db);
?>
