简易分页类

<?php
class 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();

就可以了，非常简单！

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

PHP code

   
   

    
    include
    
     
    
    '
    
    paging.php
    
    '
    
    ;

    
    $rs
    
     
    
    =
    
     mysql_paging_query(
    
    $sql
    
    ,
    
     
    
    20
    
    );
    
    //
    
    替代 mysql_query
    
    

    
    mysql_paging_bar();
    
    //
    
    显示分页条
    
    

   
   

paging.php

PHP code

   
   

    
    class
    
     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
    
    );
}