php留言板制作教程_PHP教程

CREATE TABLE `message` (

`id` tinyint(1) NOT NULL auto_increment,

`user` varchar(25) NOT NULL,

`title` varchar(50) NOT NULL,

`content` tinytext NOT NULL,

`lastdate` date NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

$conn = mysql_connect("localhost", "root", "") or die("数据库链接错误");

mysql_select_db("test", $conn);

mysql_query("set names ‘GBK'"); //使用GBK中文编码;

?>

include("conn.php");

if($_POST['submit']){

$sql="insert into message (id,user,title,content,lastdate) values (",'$_POST[user]‘,'$_POST[biaoti]‘,'$_POST[content]‘,now())";

mysql_query($sql);

echo "成功发表！";

}

?>

include ("conn.php");

?>

$sql="select * from message ";

$query=mysql_query($sql);

while($row=mysql_fetch_array($query)){ ?>