通用php分页类

<?phpif(!function_exists(pageft)){
function pageft($totle,$displaypg=20,$url=''){global $page,$firstcount,$pagenav,$_SERVER;$GLOBALS["displaypg"]=$displaypg;if(!$page) $page=1;
if(!$url){ $url=$_SERVER["REQUEST_URI"];}$parse_url=parse_url($url);
$url_query=$parse_url["query"];
if($url_query){
$url_query=ereg_replace("(^|&)page=$page","",$url_query);
$url=str_replace($parse_url["query"],$url_query,$url);
if($url_query) $url.="&page"; else $url.="page";
}else {
$url.="?page";
}$lastpg=ceil($totle/$displaypg);
$page=min($lastpg,$page);
$prepg=$page-1; //上一页
$nextpg=($page==$lastpg ? 0 : $page+1); //下一页
$firstcount=($page-1)*$displaypg;
$pagenav="显示第 <B>".($totle?($firstcount+1):0)."</B>-<B>".min($firstcount+$displaypg,$totle)."</B> 条记录，共 $totle 条记录<BR>";//如果只有一页则跳出函数：
if($lastpg<=1) return false;$pagenav.=" <a href='$url=1'>首页</a> ";
if($prepg) $pagenav.=" <a href='$url=$prepg'>前页</a> "; else $pagenav.=" 前页 ";
if($nextpg) $pagenav.=" <a href='$url=$nextpg'>后页</a> "; else $pagenav.=" 后页 ";
$pagenav.=" <a href='$url=$lastpg'>尾页</a> ";//下拉跳转列表，循环列出所有页码：
$pagenav.="　到第 <select name='topage' size='1' onchange='window.location=\"$url=\"+this.value'>\n";
for($i=1;$i<=$lastpg;$i++){
if($i==$page) $pagenav.="<option value='$i' selected>$i</option>\n";
else $pagenav.="<option value='$i'>$i</option>\n";
}
$pagenav.="</select> 页，共 $lastpg 页";
}
}
?>使用<?php $sql=mysql_query ($search_sql);
$total=mysql_num_rows($sql);
if ( $total<=0 )
  {
   exit ('<P><font color=red>没有查询到任何记录</font>');
  }
?> 表头<?php $sql=mysql_query ($search_sql);
$total=mysql_num_rows($sql);
pageft($total,15);
$sql=mysql_query( $search_sql ." limit $firstcount,$displaypg ");
$result=mysql_fetch_array($sql);
do
{
?>内容
<?php
}
  while ($result=mysql_fetch_array($sql));
?>
</table>
楼主百度一下 CDB php分页类感觉还不错
才做好不久的php小组作业，里面有分页，不嫌麻烦看的话可以看看哈，hehe,由于内容太长，剪了一些哈
<?php

  session_start();
  if($_SESSION['a_name']==null)
  {
   ?>
<script language="javascript">
  alert("请确认你是否有权限");
  location.href="../../websites/a_or_ulogin.php";
</script>
   <?php
  }
  else
  {
  require("../../conn/conn.php");
  $db=mysql_connect($dbhost,$dbuser,$dbpassword);
  mysql_select_db($dbdatabase,$db);
  $query_blogs="select * from blogs";
  mysql_query("set names gb2312");
  $result1=mysql_query($query_blogs,$db);
  $row_count=mysql_num_rows($result1);
  $pagesize=8;
  $pagecount=0;
  $pagenow=1;
  $pagenow=$_REQUEST["i"];
  if($row_count/$pagesize==0)
   {
$pagecount=intval($row_count/$pagesize);
   }
   else
   {
$pagecount=intval($row_count/$pagesize)+1;
   }
   if($pagenow>$pagecount)
   {
$pagenow=$pagecount;
   }
   if($pagenow<=0)
   {
$pagenow=1;
   }
   $query_blog="select * from blogs limit ".$pagesize*($pagenow-1).",8";
   $result=mysql_query($query_blog,$db);

?>
<html>
  <head>
    <title>管理员管理页面</title>
<link href="../../css/admin.css" type="text/css" rel="stylesheet">
  </head>
  <body>
     <div id="container">
  <div id="rightfooter">
  <table width="597" height="48" border="1" class="datalist">
<caption>
本站日记列表
</caption>
<tr>
                <td width="76" height="36">编号</td>
<td width="80" height="36">标题</td>
<td width="86" height="36">是否公开</td>
<td width="98" height="36">发表时间</td>
<td width="108" height="36">日记类型</td>
<td width="109" height="36">推荐状态</td>
</tr>
<?php
     while($arr = mysql_fetch_array($result))
      {
?> <tr>
                <td width="76" height="36"><?php echo $arr['id']?></td>
                <td width="80"><?php echo $arr['b_title']?></td>
                <td width="86"><?php if($arr['ispub']==0) echo "不公开"; else echo "公开";?></td>
                <td width="98"><?php echo $arr['b_time']?></td>
                <td width="108">
<?php
if($arr['cat_id']==1)
   echo "休闲娱乐";
else
   echo "心历路程";
?></td>
                <td width="109">
<?php if($arr['isup']==1) echo "是"; else echo "否";?>
</td>
              </tr>

  <?php }?>
  <tr>
    <th colspan="6"><form name="form2" method="post" action="listblog.php">
  开始时间
                    <label>
                    <input name="start_date" type="text" id="start_date" size="20" onClick="javascript:ShowCalendar(this.id)">
                  </label>
结束时间
<label>
<input name="end_date" type="text" id="end_date" size="20" onClick="javascript:ShowCalendar(this.id)">
</label>
<label>
<input name="query" type="submit" id="query" value="提交">
</label>
</form>
  <form name="form1" method="post" action="listblog.php">
                    <label>请输入页面
                    <input name="i" type="text" id="i" size="2" maxlength="1">
                    </label>
                    <label>
                    <input type="submit" name="Submit" value="GO">
                    </label>
                  </form>
<?php
for($i=1;$i<=$pagecount;$i++)
{
   echo "<a href='listblog.php?i=".$i."'>第".$i."页<a>  ";
}
?> </th>
  </tr>
             </table>
  </div>
   </div>
   <div id="copyright">版权所有 <font size="+2">©</font>计算机1班php实践黄俊小组</div>
   <div id="footer"></div>
     </div>
  </body>
</html>
<?php }?>

调试易

通用php分页类

解决方案 »