<< home
";
// select database
mysql_select_db(DB_NAME);
// process form to add new data if it's submitted
if (isset($_POST["name"]) && isset($_POST["month"]) && isset($_POST["day"]) && isset($_POST["year"])){
$err = "";
if(empty($_POST["name"]) || empty($_POST["month"]) || empty($_POST["day"]) || empty($_POST["year"])){
$err .= "Incomplete form\n";
} else {
// check if values are valid
$month = intval($_POST["month"]);
if ($month > 12 || $month < 1) $err .= "Error! Incorrect month value.
";
$day = intval($_POST["day"]);
if ($day > 31 || $day < 1) $err .= "Error! Incorrect day value.
";
$year = intval($_POST["year"]);
if ($year < 1900 || $year >= gmdate("Y")) $err .= "Error! Year out of range.
";
}
if ($err!=""){
echo "" . $err . "";
} else {
$name = str_replace("'","''",$_POST["name"]);
$query = "INSERT INTO birthday (`thename`,`themonth`,`theday`,`theyear`) VALUES ('{$name}',{$month},{$day},{$year});";
$result = mysql_query($query) or die ("Query failed: " . mysql_error());
if(mysql_affected_rows()==1)
echo "Entry added successfully";
else
echo "Database not modified";
}
echo "
";
}
// query data from table 'birthday'
$query = "SELECT * FROM birthday;";
$result = mysql_query($query) or die ("Query failed: " . mysql_error());
// display data in table format
echo "\n";
echo "\t\n\t\t| Name | \n\t\tBirthday | \n\t
\n";
while($row = mysql_fetch_assoc($result)){
echo "\t\n";
foreach($row as $item=>$value){
echo "\t\t| $value | \n";
}
echo "\t
\n";
}
echo "
\n";
mysql_free_result($result);
?>