<?
$conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误");
mysql_select_db("test", $conn);
mysql_query("set names 'GBK'");
?>
留言页面
<?
include("mysql_con.php");
if($_POST['submit'])
{
$sql="INSERT INTO message VALUES ('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
mysql_query($sql);
echo "留言成功";
}
?>
<form action="mess.php" method="post" >
用户:<input type="text" size="10" name="user" /><br>
标题:<input type="text" name="title" /><br/>
内容:<textarea name="content" cols="60" rows="9"></textarea><br/>
<input type="submit" name="submit" value="发布留言"/>
</form>
查看留言页面
<?
include ("mysql_con.php");
$sql="select * from message order by id desc";
$result= mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo $row[id]." ".$row['user']." ".$row['title']." ".$row['content']." "."$row[lastdate]";
echo "<br />";
}
?>