PHP分页技术

1.分页对象

<?php
    //保存分页信息的类
    class PaggingMode{
        //分页规格
        public $pageSize=6;
        //结果集
        public $res_array;
        //总记录
        public $rowCount;
        //当前页
        public $pageNow;
        //总页数
        public $pageCount;
        //分页导航
        public $navigate;
    }
?>

2.分页查询

<?php
    require_once 'PaggingModel.php';
    //MySql助手类(含分页)
    class SqlHelper{
    
        //属性
        public $conn;
        public $dbname="database";
        public $username="root";
        public $password="root";
        public $host="localhost";

        //构造函数
        public function __construct(){
            $this->conn=mysql_connect($this->host,$this->username,$this->password,$this->dbname);
            if(!$this->conn){
                die(mysql_error());
            }
            //选择数据库
            mysql_select_db($this->dbname,$this->conn);
            //设置编码
            mysql_query("set names utf8");
        }
        
        //执行dql语句
        public function execute_dql($sql){
            $res=mysql_query($sql,$this->conn);
            return $res;
        }
        
        //执行dml语句
        public function execute_dml($sql){
            $b=mysql_query($sql,$this->conn);
            if(!$b){
                //执行失败
                return 0;
            }
            else{
                if(mysql_affected_rows($this->conn)>0){
                    //执行成功
                    return 1;
                }
                else{
                    //没有受影响的行
                    return 2;
                }
            }
        }
        
        //分页查询
        public function execute_dql_pagging($sql1,$sql2,$paggingModel){
            //获取分页所需要的数据集
            $res=mysql_query($sql1,$this->conn) or die(mysql_errno());
            $arr=array();
            //将结果集存储起来
            while($row=mysql_fetch_assoc($res)){
                $arr[]=$row;
            }
            //释放结果集
            mysql_free_result($res);
            
            //获取记录总数
            $res=mysql_query($sql2,$this->conn) or die(mysql_errno());
            if($row=mysql_fetch_row($res)){
                $paggingModel->pageCount=ceil($row[0]/$paggingModel->pageSize);
                $paggingModel->rowCount=$row[0];
            }
            
            mysql_free_result($res);
            
            //存储结果集
            $paggingModel->res_array=$arr;
        }
        
        //关闭连接
        public function close_connect(){
            if(!empty($this->conn)){
                mysql_close($this->conn);
            }
        }
    }
?>

3.分页逻辑

<?php
    
    require_once 'SqlHelper.php';
    require_once 'PaggingModel.php';
    //分页逻辑
    class PaggingBuiness{
        function getPagging($paggingModel){
            $sqlHelper=new SqlHelper();
            $sql1="select * from table limit ".($paggingModel->pageNow-1)*$paggingModel->pageSize.",".$paggingModel->pageSize;
            $sql2="select count(*) from table";
            $sqlHelper->execute_dql_pagging($sql1, $sql2, $paggingModel);
            
            $sqlHelper->close_connect();
        }
    }
?>

4.测试分页

<?php
    //测试分页
    require_once 'PaggingBuiness.php';
    require_once 'PaggingModel.php';
    
    $paggingModel=new PaggingMode();
    $paggingModel->pageNow=1;
    $paggingModel->pageSize=6;
    
    //改变当前页
    if(!empty($_GET['pageNow'])){
        $paggingModel->pageNow=$_GET['pageNow'];
    }
    
    $paggingBuiness=new PaggingBuiness();
    $paggingBuiness->getPagging($paggingModel);
    
    //打印表格结构以及表头
    echo "html代码";
    
    for($i=0;$i<count($paggingModel->res_array);$i++){
        $row=$paggingModel->res_array[$i];
        echo "输出内容";
    }
    
    //显示上一页和下一页
    if($paggingModel->pageNow>1){
        $prePage=$paggingModel->pageNow-1;
        echo "a href='xx.php?pageNow=$prePage'>上一页</a>&nbsp;";
    }
    if($paggingModel->pageNow<$paggingModel->pageCount){
        $nextPage=$paggingModel->pageNow+1;
        echo "<a href='xx.php?pageNow=$nextPage'>下一页</a>&nbsp;";
    }
?>