简易 PHP+MySQL 分页类

初学者一般都不太理解分页的原理，因此常常为分页发愁

paging.php<?phpclass Paging {  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();

就可以了，非常简单！

换一种调用写法，可能感觉要好些

paging.phpclass Paging {  private static $_Instance;  private function __clone(){}  public static function getInstance() {    if(empty(self::$_Instance)) self::$_Instance = new self();    return self::$_Instance;  }  protected $count = 0;  protected $size = 0;  protected $page = 0;  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($this->count) = mysql_fetch_row($p);    $this->size = $pagesize;    $this->page = $page;    return $rs;  }  function bar($tpl='') {    if(!$tpl) $tpl = '共{count}页 第{page}页 <a href=?{reset}>首页</a> <a href=?{prve}>上一页</a> <a href=?{next}>下一页</a> <a href=?{end}>尾页</a>';    $count = ceil($this->count / $this->size);    $page = $this->page;    $d = array(      '{reset}' => 1,      '{prve}' => $page > 1 ? $page - 1 : 1,      '{next}' => $page < $count ? $page + 1 : $count,      '{end}' => $count,      '{count}' => $count,      '{page}' => $page,    );    foreach($d as $k=>&$v) {      if(in_array($k, array('{reset}', '{prve}', '{next}', '{end}'))) {        $_GET['page'] = $v;        $v = http_build_query($_GET);      }    }    echo strtr($tpl, $d);  }}function mysql_paging_query($sql, $num=10) {  return Paging::getInstance()->prepare($sql, $num);}function mysql_paging_bar($tpl='') {  return Paging::getInstance()->bar($tpl);}

include 'paging.php';$rs = mysql_paging_query($sql, 20);//替代 mysql_querymysql_paging_bar();//显示分页条