", " ");
$this = strtr($this, "<", " ");
$this = strtr($this, "|", " ");
$$key = $this;
}
////////////////////////////////
// This will catch if someone is trying to submit a blank
// or incomplete form.
////////////////////////////////
if ($name && $email && $message ) {
$is_private = is_private==""?"off":"on";
/* if ($is_private == "")
{
$is_private = "off";
}else{
$is_private = "on";
}
*/
////////////////////////////////
// This is the meat of the query that updates the guests table
////////////////////////////////
$query = "INSERT INTO guests ";
$query .= "(guest_id, guest_name, ";
$query .= "guest_email, guest_time, guest_message, is_private) ";
$query .= "values(0000,'$name','$email',NULL,'$message','$is_private')";
mysql_pconnect("[REDACTED]","[REDACTED]","[REDACTED]")
or die("Unable to connect to SQL server");
mysql_select_db("[REDACTED]") or die("Unable to select database");
mysql_query($query) or die("Insert Failed!");
} else {
////////////////////////////////
// If they didn't include all the required fields set a variable
// and keep going.
////////////////////////////////
$notall = 1;
}
}
?>
Two Yellow Zebras Guestbook
