<html xmlns="[url]http://www.w3.org/1999/xhtml[/url]">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title>留言本</title>
</head>
<body>
<form action="updata.php" method="post" name="name1">
姓名:<input type="text" name="user_name"><br>
留言:<textarea name="post_contents" rows="10" cols="50"></textarea>
<input type="submit">
</form>
</body>
</html>
$username=$_POST['user_name'];
$content=$_POST['post_contents'];
$conn=mysql_connect("localhost:3306","root","abc"
mysql_query("set names gbk"); //解决中文乱码问题
mysql_select_db("guest_book");
$exec="insert into contents (username,content) values ('".$_POST['user_name']."','".$_POST['post_contents']."')";
$result=mysql_query($exec);
?>
$conn=mysql_connect("localhost:3306","root","abc"); //打开mysql服务器连接
mysql_select_db("guest_book");//链接数据库
mysql_query("set names gbk");//解决中文乱码问题
$exec="select * from contents"; //执行sql语句
$result=mysql_query($exec);//返回结果
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->username."</td></tr>";
echo "<tr><td>留言:".$rs->content."</td></tr></table><br/>";
}
?>