<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="my_db"; // Database name
$tbl_name="guestbook"; // Table name
// Connect to server and select database.
$con = mysqli_connect("$host", "$username", "$password")or die("cannot connect server ");
mysqli_select_db($con, "$db_name")or die("cannot select DB");
$datetime=date("y-m-d h:i:s"); //date time
$name=$_REQUEST["name"];
$email=$_REQUEST["email"];
$comment=$_REQUEST["comment"];
$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment',
'$datetime')";
$result=mysqli_query($con, $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 "ERROR";}
mysqli_close($con);
?>