For additional installation help refer to the PHP and mySQL manuals at www.php.net and www.mysql.com
*/
// ********************
// * Show the entries *
// ********************
class guestbook {
function show_entries() {
include \"settings.inc\"; // Open DB
$dblink = mysql_pconnect($dbserver,$dbuser,$dbpass);
mysql_select_db($db,$dblink);
$result = mysql_query(\"SELECT * FROM guestbook ORDER BY id desc\");
$amount = mysql_numrows($result);
if ($amount == 0) { // No entries found: show error message
?>
Error: No entries were found.
Entries found:
error[check] = \"true\";
$this->error[name] = \"true\";
}
if ($email == \"\") {
$this->error[check] = \"true\";
$this->error[email] = \"true\";
} else if (!eregi(\"^[_\\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\\.)+[a-z]{2,3}$\",$email)) {
$this->error[check] = \"true\";
$this->error[email] = \"true\";
}
if ($message == \"\") {
$this->error[check] = \"true\";
$this->error[message] = \"true\";
}
return $this->error;
}
// *******************
// * Store the entry *
// *******************
function store_entries($name, $email, $message) {
$date = getdate();
$year = $date[year];
$month = $date[mon];
$day = $date[mday];
$posted = $year.\"-\".$month.\"-\".$day;
include \"settings.inc\"; // Open DB
$dblink = mysql_pconnect($dbserver,$dbuser,$dbpass);
mysql_select_db($db,$dblink);
$result = mysql_query(\"INSERT INTO guestbook (name, email, message, posted) VALUES (\'$name\', \'$email\', \'$message\', \'$posted\')\");
mysql_close($dblink); // Close DB
}
// *****************
// * Show the form *
// *****************
function show_form($error, $name, $email, $message) {
?>
show_entries();
$guestbook->show_form(\"\", \"\", \"\", \"\");
} else { // Form was filled: check entry
$guestbook = new guestbook;
$guestbook->check_entries($name, $email, $message);
if ($guestbook->error[check] == \"true\") { // Entry is incomplete: show error message
?>
An error occured while posting your entry. Please check the marked fields.
show_form($guestbook->error, $name, $email, $message);
} else { // Entry is complete: store in DB, show entries
$guestbook->store_entries($name, $email, $message);
?>
Your entry was posted successfully.
show_entries();
$guestbook->show_form(\"\", \"\", \"\", \"\");
}
}
?>