php

php分页类 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php    
  
class Pages {  
  
    //分页  
    //Tcount 总数  
    //Tpage  每页显示数量  
    //p 当$p=3时，打开http://trunk.com/houtai/life/shop则跳转到第3页  
    static function multi($Tcount, $Tpage, $p, $url='', $url1='') {  
          
        $mu = "";  
        //总页数  
        $z = ceil($Tcount / $Tpage);  
        $l = 10;    //长度  
        $v = $l/2;  
          
        $diy = ($p>1 && $p<$z)?($p-1):0;  
        $mu.="<a href='".$url."1".$url1."' class='curved'>首页</a>";  
        $mu .= "\r\n";  
        if($p-1>=1){  
          //$mu .= "<a href=\"".$url.$url1."\" title=\"上一页\" class=\"pre\">上一页</a>\r\n";  
         }  
        if($p>$v) $mu .= "\r\n";  
        //开始  
        $ca = (($p - $v)<0) ? 0 : ($p - $v);  
        //结束  
        $cb = (($p + $v)>$z) ? $z : ($p + $v);  
          
        if($cb-$ca<($l+1)){  
            $x = ($l+1)-($cb-$ca);  
            if($ca==0 && $cb<$z){  
                if(($z-$cb)<$x){  
                    $cb = $cb + ($z-$cb);  
                }else{  
                    $cb = $cb + $x;  
                }  
            }elseif($cb==$z && $ca>0){  
                if(($ca-$x)<0){  
                    $ca = 0;  
                }else{  
                    $ca = $ca - $x;  
                }  
            }  
        }  
        for($i=$ca;$i<$cb;$i++){  
            //$pi = ($p==($i+1))?"class=\"current\"": "";  
            if($p==($i+1)){  
                $mu .= "<a class=\"active curved\">".intval($i+1)."</a>\r\n";  
            }else{  
                if($i==0){  
                    $mu .= "<a href=\"".$url.$url1."\" title=\"第".intval($i+1)."页\" class=\"curved\">[".intval($i+1)."]</a>\r\n";  
                }else{  
                    $mu .= "<a href=\"".$url.($i+1).$url1."\" title=\"第".intval($i+1)."页\" class=\"curved\">[".intval($i+1)."]</a>\r\n";      
                }  
            }  
        }  
          
        if(($p+$v)<$z) $mu .= "\r\n";  
        $end = ($p<$z)?$p+1:$z;  
        if($p+1<=$z){  
            //$mu .= "<a href=\"".$url.($p+1).$url1."\" title=\"下一页\" class=\"pre\">下一页</a>\r\n";  
            $mu .= "\r\n";  
        }  
        $mu.="<a href='".$url.$z.$url1."' class=\"curved\">末页</a>";  
        //$mu .= "\r\n";  
        $mu.="   共{$Tcount}条记录/{$z}页";  
        //$mu .= "\r\n";  
        //$mu.="每页显示{$Tpage}条";  
        return $mu;  
    }     
  
}  
  
//example:   
$sql = "select * from life_shop where id = {$id} order by order_id desc ";  
$query = $this->db->query($sql);  
$total = $query->num_rows();  
$page_no = $page_no<1 ? 1 : $page_no;  
$query = $this->db->query($sql." limit ".($page_no-1)*$this->pagesize.",".$this->pagesize);  
$data['lists'] = $query->result_array();  
          
$this->load->library('pages'); //加载上面的pages类  
$data['pagestr'] = $this->pages->multi($total,$this->pagesize,$page_no,'/houtai/life/shop/','');  //页面上输出的pagestr字符串即为分页代码        
$this->load->view('houtai/life/shop',$data);