php 留言板分页显示,基于留言板的php中分页程序详解

$pagesize = 10;//每一页显示多少留言记录

if(isset($_GET['page'])&&$_GET['page']!='') $page=$_GET['page'];

else $page=0;

$sql = "SELECT a . * , b.name, b.email, b.qq, c.revert_time, c.revert

FROM post a

LEFT JOIN revert c ON ( a.id = c.post_id ) , guest b

WHERE a.guest_id = b.id

ORDER BY a.id DESC";

$numRecord = mysql_num_rows(mysql_query($sql));

$totalpage = ceil($numRecord/$pagesize);

$recordSql = $sql. " LIMIT ".$page*$pagesize.",".$pagesize;

$result = mysql_query($recordSql);

while($rs=mysql_fetch_object($result)){

?>

留言人：<?php echo $rs->name?> |Email：<?php echo $rs->email?>|QQ:<?php echo $rs->qq?>|留言时间：<?php echo date("Y-m-d H:i:s",$rs->post_time+8*3600)?>

if(isset($_SESSION['login'])&&$_SESSION['login']){

?>

回复 | 删除

}

?>

留言内容：<?php echo nl2br(htmlspecialchars($rs->post))?>

回复内容：<?php echo nl2br(htmlspecialchars($rs->revert))?>[<?php if($rs->revert_time!="") echo date("Y-m-d H:i:s",$rs->revert_time+8*3600)?> ]

}

?>

if($page>0) echo "上一页|" ; if($page下一页" ; ?>