<html>
<head>
<title>Please Leave a Comment</title>
</head>
<body>
<body bgcolor="blue">
</body>
</html>
<?PHP
require "db_guestbook.php";
$link = mysql_connect( $db_host, $db_username, $db_password ); // connection to database
if ( !$link )
exit ( "Database error: " . mysql_error() );
mysql_select_db ( $db_name, $link ); // selects database name
$me = $_SERVER['PHP_SELF'];
if ( isset ( $_POST['comments'] ) ) // check for current comments
{
$name = $_POST ['name'];
$email = $_POST ['email'];
$comment = $_POST ['comments'];
$date = date('Y-m-d h:i:s'); //php method
$result = mysql_query( "INSERT INTO guestbook (name, email, comment, date) VALUES('$name', '$email', '$comment','$date' )", $link ); // insert post into db
if( !$result )
exit ( "Query failed: " . mysql_error() );
header("Location: $_SERVER[PHP_SELF]?$_SERVER[QUERY_STRING]");//this where you redirct to the same page
}
else
{
print ( "<b><center>Current Comments: </b><br>\n</center>" ) ;
mysql_select_db ( $db_name, $link ); // selects database name
$querydate = mysql_query ("SELECT DATE_FORMAT(date,'%W, %M %d, %Y at %l:%i %p') AS date FROM guestbook",$link); //retrieve date
$result = mysql_query ("SELECT name,email,comment,date FROM guestbook", $link ); //Retrieve Info
if ( $result )
{
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) // variable to hold name and comments
{
print ( "<i><b>Name</i></b>: " . $row["name"] . "<br> <i><b>Email</i></b>: " . $row["email"] . "<br> <i><b>Comment</i></b>: " . $row["comment"] . "<br>\n " . " <i><b>Posted</i></b>: " . $row["date"] ."<br><br><hr />" );// $row prints name and comments // $row1 print datetime
}
}
else
exit ( "Query failed: " . mysql_error() );
print( "<center><br><b>Add a comment: </b><br>\n</center>" );
// user interaction form
print( "<form action=\"$me\" method=\"post\">\n</center>" );
print( "<center><b>Your name:</center><b>");
print( "<center><input type=\"text\" name=\"name\" size=\"20\"/><br>\n</center>" );
print( "<center><b>Your email:</center><b>" );
print( "<center><input type=\"text\" name=\"email\" size=\"100\" /><br>\n</center>");
print( "<center>Your comments:" );
print( "<center><input type=\"text\" name=\"comments\" size=\"100\" /><br>\n</center>");
print( "<center><input type=\"submit\" value=\"Submit\"/>\n</center><br>" );
print( "<center><input type=\"reset\" value=\"Reset\" /></center>");
print( "</form>\n" );
}
//mysql_close( $link ); // close db connection
?>
