该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
代码如下:
$conn= mysql_connect("localhost","root", "duolaguang");
mysql_select_db('guestbook',$conn);
$sql='select * from reply';
$result= mysql_query($sql);
$total = mysql_num_rows($result);
$pagesize=1;
echo '共有'.$total."条
";
if(!isset($page)){
$page=1;
}else{
$page=intval($_POST[page]);
}
$prepage= ($page-1);//上一页
$nextpage= ($page+1);
$pagesize=2;
$pagenum = (int)ceil($total/$pagesize);
echo '共有'.$pagenum ."
";
$offset=$pagesize*($page-1);
$sql2=" select * from reply limit $offset, $pagesize ";
$re = mysql_query($sql2);
while($row= mysql_fetch_row($re)) {
print $row[2] . "==" . $row[2] . "
";
}
if($page==1) {
echo " 首页 ";
echo "==";
";}
elseif($page==$pagenum){
尾页";
}else{
}
?>