CREATE TABLE `comments` ( `id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 50 ) NOT NULL , `comment` VARCHAR( 255 ) NOT NULL , `time` INT( 9 ) NOT NULL )
process.php
<?php $dbhost = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "newdb"; $name=$_POST['name']; $comment=$_POST['comment']; $conn=mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error); $select_db=mysql_select_db($dbname) or die("cannot find database!"); $sql= "INSERT INTO comments (`name`,`comment`,`time`) values ('$name','$comment',".time().")"; mysql_query($sql) or die("insert failed."); echo true;
?>
index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">