读书人

容易分页类

发布时间: 2012-12-25 16:18:28 作者: rapoo

简单分页类
分页 转自网络 已测试验证;后续会继续整理出 有样式的分页类;
文件test.php

include("pagging.php");$link = mysql_connect("localhost","user","pwd")or die(mysql_error());mysql_select_db("dbname")or die(mysql_error());$sql = "select * from tbname";$res = pagging::prepare($sql,5);while($row = mysql_fetch_array($res)){print_r($row);echo '<br>';}echo pagging::bar();


文件pagging.php
<?phpclass pagging {  public static $count = 0;  public static $size = 0;  public static $page = 0;  static function prepare($sql, $pagesize=10) {    $page = isset($_GET['page']) ? $_GET['page'] : 1;    $pageon = ($page - 1) * $pagesize;    $sql = preg_replace('/select\s/i', '$0SQL_CALC_FOUND_ROWS ', $sql) . " limit $pageon, $pagesize";    $rs = mysql_query($sql);    $p = mysql_query('SELECT FOUND_ROWS()');    list(self::$count) = mysql_fetch_row($p);    self::$size = $pagesize;    self::$page = $page;    return $rs;  }      static function bar($tpl='') {    if(!$tpl) $tpl = '<a href=?reset>首页</a> <a href=?prve>上一页</a> <a href=?next>下一页</a> <a href=?end>尾页</a>';    $count = ceil(self::$count / self::$size);    $page = self::$page;    unset($_GET['page']);    $d = array(      'reset' => 1,      'prve' => $page > 1 ? $page - 1 : 1,      'next' => $page < $count ? $page + 1 : $count,      'end' => $count,    );    foreach($d as $k=>$v) {      $_GET['page'] = $v;      $tpl = str_replace($k, http_build_query($_GET), $tpl);    }    echo $tpl;  }}?>


通常你都有类似这样的语句 $sql ="....."; $rs = mysql_query($sql); 或 $rs = mysql_query("select ...."); 你只需改作 include 'paging.php'; $rs = paging::prepare($sql, 每页行数); 在需要出现分页条的地方写入 paging::bar(); 就可以了,非常简单!

读书人网 >编程

热点推荐