<html>
<head>
<title>简单留言板</title>
</head>
<style type="text/css">
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(bg.jpg);
}
#top {
font-size: 28px;
line-height: normal;
height: 100px;
padding-top: 15px;
background-image: url(logo.jpg);
color: #FFF;
}
#con {
background-color: #EEEEEE;
}
hr{height:1px;border:1px solid #BED8EA;border-left:none;border-right:none;}
</style>
<body>
<?php
include("conn.php");
$page_size=6;
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
}
?>
<div align="center" id="top"><br>明 少 留 言 板
</div>
<div align="left" id="con">
<hr>
<form action="a.php" method="post">
用户名<input type="text" name="user">留言内容<textarea name="content" rows="1" cols="17"></textarea><input type="submit" value="提交"><!--提交按钮-->
</form><hr>
<?php
//readfile('a.txt');//读取已保存留言并显示
$SQL="SELECT * FROM `message` order by id desc ";
$query=mysql_query($SQL);
$numRows = mysql_NumRows($query);
$pageid=$numRows % 6;
if($numRows){
$SQL="SELECT * FROM `message` order by id desc limit ". ($page-1)*$page_size .", $page_size";
$query=mysql_query($SQL);
while($row=mysql_fetch_array($query,MYSQL_ASSOC)){
echo $row["id"]."、".$row["content"]."<br />(".$row["user"]." ".$row["lastdate"].")<hr>";
}}
?>
<a href=?page=1>第一页</a><a href=?page=<?php $page=($page-1);if($page==0)$page=1; echo $page; ?> >上一页</a>
<a href=?page=<?php $page=$page+1; echo $page+1 ?> >下一页</a><?php echo intval( $_GET['page'] )."/$pageid"; ?>页
<a href=?page=<?php echo $pageid ?> >尾页</a>
<form action="a.php" method="post">
用户名<input type="text" name="user"><br />
留言内容<textarea name="content" rows="3" cols="20"></textarea><br />
<input type="submit" value="提交"><!--提交按钮-->
</form>
</div>
</body>
</html>