php分页类

//PagingClass  类名

header("Content-Type: text/html;charset=utf-8");
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of PagingClass
 *
 * @author zhaoliang-fin
 */
class PagingClass {
   
    var $page;//当前页码；
    var $firstcount; //（数据库）查询的起始项；
    var $total; //数据总数
    var $displaypg;//每页显示数据条数
    var $get_txt; //页码标示字段
    var $url;//页面地址
    var $lastpg;////最后页，也是总页数
    
    function PagingClass($total,$displaypg=30,$get_txt='page',$url=''){
        $lastpg=ceil($total/$displaypg);
        $this->lastpg=$lastpg;
        $this->page=($_GET[$get_txt]=='')?1:min($_GET[$get_txt],$lastpg);
       // echo $this->page;
        $this->total=$total;
        $this->displaypg=$displaypg;
        $this->get_txt=$get_txt;
        $this->url=($url=='')?$_SERVER["REQUEST_URI"]:$url;
        $this->firstcount=($this->page-1)*$displaypg;
     }
 
    //url网址处理函数:URL后加页码查询信息待赋值
    function get_new_url(){
        $url=$this->url;
        $parse_url=parse_url($url);
        $url_query=$parse_url["query"]; //单独取出URL的查询字串
        if($url_query){
            //因为URL中可能包含了页码信息，我们要把它去掉，以便加入新的页码信息。
           // $url_query=ereg_replace("(^|&)".$this->get_txt.."=[0-9]+","",$url_query);

            //将处理后的URL的查询字串替换原来的URL的查询字串：
            $new_url=str_replace($parse_url["query"],$url_query,$url);

            //在URL后加page查询信息，但待赋值
            if($url_query)$new_url.="&".$this->get_txt; else $new_url.=$this->get_txt;
         }else {
            $new_url=$url."?".$this->get_txt;
         }
        return  $new_url;
     }
    
    ////输出分页导航条代码：
    function show_link(){
        $pagenav="显示第 <B>".($this->total?($this->firstcount+1):0)."</B>-<B>".min($this->firstcount+$this->displaypg,$this->total)."</B> 条记录，共 $this->total 条记录&nbsp;&nbsp;&nbsp;";

        //如果多于一页：
        if($this->lastpg >1){
            $prepg=$this->page-1; //上一页
            $nextpg=($this->page==$this->lastpg ? 0 : $this->page+1); //下一页
            $url=$this->get_new_url();
            $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=$this->lastpg'>末页</a> ";
            //下拉跳转列表，循环列出所有页码：
            $pagenav.="　到第 <select name='topage' size='1' onchange='javascript:window.location=\"$url=\"+this.value'>\n";
            for($i=1;$i<=$this->lastpg;$i++){
                if($i==$this->page) $pagenav.="<option value='$i' selected>$i</option>\n";
                else $pagenav.="<option value='$i'>$i</option>\n";
             }
            $pagenav.="</select> 页，共 $this->lastpg 页";
         }

        return $pagenav;
     }
}

 

//index.php

 

include_once 'conn/sqlconnect.php';
include_once 'PagingClass.php';
$sqlstr="select day,channel_name,channel_id,channel_type,platform,city,newuser from rpt_mobileguard_city_daily";                
$result=mysql_query($sqlstr);
$total=mysql_num_rows($result);
$page=new PagingClass($total,10);
$sqlstr.=" limit $page->firstcount,$page->displaypg";

$result=mysql_query($sqlstr);
while($row=mysql_fetch_assoc($result)){
$str[]=$row;//"……";//此处处理输出数据
}
$str[page]=$page->show_link();
print_r($str);
//
//$str.="<table border='0' align='center'><tr><td >".$page->show_link()."</td></tr></table>";
//echo $page->show_link();