<!-- Guestbook.php
	 CET4583 - Lesley Peterson
	 Modified from the script at Hardcoder.com
	 Last Modified: 01-25-2009
-->

<?php
$dbHost = "localhost";
$dbUser = "lesleyp_ucf";
$dbPass = "eris23";
$dbDatabase = "lesleyp_guestbook";

// Connect to DB

$li = mysql_connect($dbHost, $dbUser, $dbPass) or die("Could not connect");
mysql_select_db($dbDatabase, $li) or die ("could not select DB");

$ipaddress = $_SERVER["REMOTE_ADDR"];
$date = Date("Y-m-d h:i:s");


$sql = 	"call spInsertGuestBookEntry('$name', '$comment', '$email', '$ipaddress')";

$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 "ERROR";
}

mysql_close();
?>
