<?php
include("inc.php");//连接数据库
if(isset($_GET['$page'])){
$page=intval($_GET['$page']);
}else{
$page=1;
}
$pagesize=2;//设置每页显示几条记录
$sql="select count(*) as acount from guestbook";
$result=mysql_query($sql);
$row=mysql_fetch_row($result);
$acount=$row[0];//获取记录总数
if($acount){
if($acount<$pagesize){
$pagecount=1;
}
if($acount%$pagesize){
$pagecount=(int)($acount/$pagesize)+1;
}else{
$pagecount=$acount/$pagesize;
}
}else{
$pagecount=0;
}//获取总页数
if($page>$pagecount|$page==0){
echo "没有当前页";
exit();
}//异常页处理
$pageout='';
if($page==1){
$pageout.='首页|上页|';
}else{
$pageout.='<a href="page.php">首页</a>|<a href="page.php?page='.($page-1).'">上页</a>|';
}
if($page==$pagecount||$pagecount==0){
$pageout.='下页|尾页';
}else{
$pageout.='<a href="page.php?page='.($page+1).'">下页</a>|<a href="page.php?page='.$pagecount.'">尾页</a>';
}//翻页处理
if($acount){
$sql="select id,name,comment from guestbook order by id desc limit ".($page-1)*$pagesize.",".$pagesize."";
$result=mysql_query($sql);
echo "<table width=\"670\" border=\"0\">";
while($row=mysql_fetch_row($result)){
$name=$row[1];
$comment=$row[2];
echo "<tr><td width=\"80\">$name:</td><td>$comment</td></tr>";
}
echo "</table>";
echo '共'.$acount.'条记录'." ".$page."/".$pagecount." ".$pageout;
}else{
echo "无任何数据";
}
?>没办法分页,哪里出错?
include("inc.php");//连接数据库
if(isset($_GET['$page'])){
$page=intval($_GET['$page']);
}else{
$page=1;
}
$pagesize=2;//设置每页显示几条记录
$sql="select count(*) as acount from guestbook";
$result=mysql_query($sql);
$row=mysql_fetch_row($result);
$acount=$row[0];//获取记录总数
if($acount){
if($acount<$pagesize){
$pagecount=1;
}
if($acount%$pagesize){
$pagecount=(int)($acount/$pagesize)+1;
}else{
$pagecount=$acount/$pagesize;
}
}else{
$pagecount=0;
}//获取总页数
if($page>$pagecount|$page==0){
echo "没有当前页";
exit();
}//异常页处理
$pageout='';
if($page==1){
$pageout.='首页|上页|';
}else{
$pageout.='<a href="page.php">首页</a>|<a href="page.php?page='.($page-1).'">上页</a>|';
}
if($page==$pagecount||$pagecount==0){
$pageout.='下页|尾页';
}else{
$pageout.='<a href="page.php?page='.($page+1).'">下页</a>|<a href="page.php?page='.$pagecount.'">尾页</a>';
}//翻页处理
if($acount){
$sql="select id,name,comment from guestbook order by id desc limit ".($page-1)*$pagesize.",".$pagesize."";
$result=mysql_query($sql);
echo "<table width=\"670\" border=\"0\">";
while($row=mysql_fetch_row($result)){
$name=$row[1];
$comment=$row[2];
echo "<tr><td width=\"80\">$name:</td><td>$comment</td></tr>";
}
echo "</table>";
echo '共'.$acount.'条记录'." ".$page."/".$pagecount." ".$pageout;
}else{
echo "无任何数据";
}
?>没办法分页,哪里出错?
$page=intval($_GET['$page']);
==>
if(isset($_GET['page'])){
$page=intval($_GET['page']);
$sql="select id,name,comment from guestbook order by id desc limit ".($page-1)*$pagesize.",".$pagesize."";
==>
$sql="select id,name,comment from guestbook order by id desc limit ".($_GET['page']-1)*$pagesize.",".$pagesize."";
if($acount<$pagesize){
$pagecount=1;
}
if($acount%$pagesize){
$pagecount=(int)($acount/$pagesize)+1;
}else{
$pagecount=$acount/$pagesize;
}
}else{
$pagecount=0;
}//获取总页数获取总页数没必要跟上面这么麻烦
$pagecount=ceil($acount/$pagesize);