Example demonstrating simple and universal PHP paging class

Detailed example address: http://www.alleyloft.com/contents/share?id=3

/***********************************************
 * @classname : page
 * @Parameters: $myde_total - total number of records
 * $myde_size - number of records displayed on one page
 * $myde_page - current page
 * $myde_url - get current url
 * @Function: paging implementation
 * @ Author: Song Haige
*/
class page {
 private $myde_total; //Total number of records
 private $myde_size; //Number of records displayed on one page
 private $myde_page; / /Current page
 private $myde_page_count; //Total number of pages
 private $myde_i; //Number of starting pages
 private $myde_en; //Number of ending pages
 private $myde_url; //Get current url
 /*
 * $ show_pages
 * The format of page display, the number of pages showing links is 2*$show_pages+1.
     * 如$show_pages=2那么页面上显示就是[首页] [上页] 1 2 3 4 5 [下页] [尾页]
     */
    private $show_pages;

    public function __construct($myde_total=1,$myde_size=1,$myde_page=1,$myde_url,$show_pages=2){
        $this->myde_total = $this->numeric($myde_total);
        $this->myde_size = $this->numeric($myde_size);
        $this->myde_page = $this->numeric($myde_page);
        $this->myde_page_count = ceil($this->myde_total/$this->myde_size);
        $this->myde_url = $myde_url;
        if($this->myde_total<0) $this->myde_total=0;
        if($this->myde_page<1)  $this->myde_page=1;
        if($this->myde_page_count<1) $this->myde_page_count=1;
        if($this->myde_page>$this->myde_page_count) $this->myde_page=$this->myde_page_count;
        $this->limit = ($this->myde_page-1)*$this->myde_size;
        $this->myde_i=$this->myde_page-$show_pages;
        $this->myde_en=$this->myde_page+$show_pages;
        if($this->myde_i<1){
          $this->myde_en=$this->myde_en+(1-$this->myde_i);
          $this->myde_i=1;
        }
        if($this->myde_en>$this->myde_page_count){
          $this->myde_i = $this->myde_i-($this->myde_en-$this->myde_page_count);
          $this->myde_en=$this->myde_page_count;
        }
        if($this->myde_i<1)$this->myde_i=1;
    }
    //检测是否为数字
    private function numeric($num){
      if(strlen($num)){
         if(!preg_match("/^[0-9]+$/",$num)){
             $num=1;
           }else{
             $num = substr($num,0,11);
         }
      }else{
               $num=1;
      }
      return $num;
    }
    //地址替换
    private function page_replace($page){
        return str_replace("{page}",$page,$this->myde_url);
    }
    //首页
    private function myde_home(){
        if($this->myde_page!=1){
            return "page_replace(1)."" title="首页">首页";
        }else{
            return "首页";
        }
    }
    //上一页
    private function myde_prev(){
       if($this->myde_page!=1){
           return "page_replace($this->myde_page-1)."" title="上一页">上一页";
       }else{
              return "上一页";
       }
    }
    //下一页
    private function myde_next(){
        if($this->myde_page!=$this->myde_page_count){
            return "page_replace($this->myde_page+1)."" title="下一页">下一页";
        }else{
            return"下一页";
        }
    }
    //尾页
    private function myde_last(){
        if($this->myde_page!=$this->myde_page_count){
            return "page_replace($this->myde_page_count)."" title="尾页">尾页";
        }else{
            return "尾页";
        }
    }
    //输出
    public function myde_write($id='page'){
       $str ="";
       $str.=$this->myde_home();
       $str.=$this->myde_prev();
       if($this->myde_i>1){
            $str.="...";
       }
       for($i=$this->myde_i;$i<=$this->myde_en;$i++){
            if($i==$this->myde_page){
                $str.="page_replace($i)."" title="第".$i."页" class="cur">$i";
            }else{
          $str.="page_replace($i)."" title="第".$i."页">$i";
            }
       }
 if( $this->myde_en<$this->myde_page_count ){
 $str.="...";
 }
 $str. =$this->myde_next();
 $str.=$this->myde_last();
 $str.="total".$this- >myde_page_count.
 "page".$this->myde_total."data";
 $str.=" return $str;
 }
}
?>

require_once('./page.class.php'); //Paging class
$showrow = 3;//Number of rows displayed on one page
$curpage = empty($_GET[' page'])?1:$_GET['page'];//The current page should also handle non-numeric situations
$url = "?page={page}";//Paging address, if there are search conditions ="?page={page}&q=".$_GET['q']
//The code for linking to mysql is omitted, add it yourself during testing
$sql = "SELECT * FROM table";
$query = mysql_query( $sql);
$total = mysql_num_rows($query);//Total number of records
if(!empty($_GET['page']) && $total !=0 && $curpage > ceil($total/ $showrow))
$curpage = ceil($total_rows/$showrow);//The current page number is greater than the last page number, take the last page
//Get the data
$get_data = "select * from table limit ".($ curpage-1)*$showrow.",$showrow;";
...
?>




Example demonstrates simple and universal PHP paging class




 < div class="main">

Copy code