1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

<?php require("admin/configure.php"); ?>
<?php 
session_start();
?>
<?
//$guestbookid                = $_POST["guestbookid"];
$guestbookname            = $_SESSION['guestbookname'];
$guestbookemail            = $_SESSION["guestbookemail"];
$guestbookdesc            = $_SESSION["guestbookdesc"];

$sql = "select max(guestbookid) as maxid ";
$sql .= "from guestbook";
$result=mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$guestbookid = $row{maxid}+1;

$guestbookdate = date("F j, Y, g:i a");

$sql = "insert into guestbook (guestbookid, guestbookname, guestbookemail, guestbookdate, guestbookdesc, guestbookstatus) values ('$guestbookid', '$guestbookname', '$guestbookemail', '$guestbookdate', '$guestbookdesc', 'Enable')";
//echo $sql;
mysql_query($sql);
mysql_close($dbh);

header("Location: guestbook.php");
?>