<form id="form1" name="form1" method="post" action="addguestbook.php">
<td>
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><input name="NAME" type="text" id="NAME" size="40" /></td>
</tr>
<tr>
<td>URL</td>
<td>:</td>
<td><input name="URL" type="text" id="URL" size="40" /></td>
</tr>
<tr>
<td valign="top">Comment</td>
<td valign="top">:</td>
<td><textarea name="MESSAGE" cols="40" rows="3" id="MESSAGE"></textarea></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Submit" /> <input type="reset" name="Submit2" value="Reset" /></td>
</tr>
</table>
</td>
</form>

<?php
error_reporting(E_ALL); // Enable error reporting
ini_set("display_errors", 1); // Show errors info

$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");

$ipString=$_SERVER["HTTP_X_FORWARDED_FOR"];

$NAME = $_POST["NAME"];
$URL = $_POST["URL"];
$MSG = $_POST["MESSAGE"];

$sql="INSERT INTO $tbl_name(ID, NAME, URL, MESSAGE, DATE, IP_ADDRESS)VALUES(0, "$NAME", "$URL", "$MSG", Now(), "$ipString");";
$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();
?>

<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong>View Guestbook | <a href="guestbook.html">Sign Guestbook</a> </strong></td>
</tr>
</table>
<br>

<?php

$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY ID DESC";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){
?>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>ID</td>
<td>:</td>
<td><? echo $rows["ID"]; ?></td>
</tr>
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><? echo $rows["NAME"]; ?></td>
</tr>
<tr>
<td>URL</td>
<td>:</td>
<td><? echo $rows["URL"]; ?></td>
</tr>
<tr>
<td valign="top">Comment</td>
<td valign="top">:</td>
<td><? echo $rows["MESSAGE"]; ?></td>
</tr>
<tr>
<td valign="top">Date/Time </td>
<td valign="top">:</td>
<td><? echo $rows["DATE"]; ?></td>
</tr>
</table></td>
</tr>
</table>
<br>
<?
}
mysql_close(); //close database
?>