<?php
$host="localhost"; // Host name
$username="soswe3_all"; // Mysql username
$password="allvisitors"; // Mysql password
$db_name="soswe3_guestbook"; // Database name
$tbl_name="guestbook"; // Table name
// Connect to server and select database.
$dbh=mysql_connect ("localhost", "soswe3_all", "allvisitors") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("soswe3_guestbook");
$datetime=date("y-m-d h:i:s"); //date time
//check of name en comment leeg is, zoja... geef een foutmelding
if(!empty($name) && !empty(comment)){
$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')";
$result=mysql_query($sql);
//check if query successful
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='viewguestbook.php'>View guestbook</a>"; // link to view guestbook page
}
} else {
echo "Er is iets fout gegaan. Wellicht ben je vergeten je naam/commentaar in te voegen.<br/>";
echo "Klik <a href='viewguestbook.php'>hier</a> om terug te keren en het opnieuw te proberen.";
}
mysql_close();
?>