返回Mysql技术网文  Mysql教程 Mysql函数 Mysql命令 Mysql入门酷勤首页 | 技术中心


您现在的位置:首页 -> 学技术 -> 技术网文 -> Mysql ->MySQL分页模型(Pagination.php)

MySQL分页模型(Pagination.php)

  来源:互联网 酷勤网整理


*/

class Pagination {
        var $pageSize;        //页大小
        var $pageNo;                //当前页码
        var $rowCount;        //记录总数
        var $pageCount;        //总页数
        var $records;                //当前页记录
        var $currentPageSize;        //当前页记录总数
        var $currentPageStartNo;     //当前页开始记录号

        //判断是否有下一页
        function hasNextPage() {
                return $this->pageNo < $this->pageCount;
        }
        //取得下一页页码
        function getNextPageNo() {
                return $this->pageNo + 1;
        }

        //判断是否有上一页
        function hasPriorPage() {
                return $this->pageNo > 1;
        }
        //取得上一页页码
        function getPriorPageNo() {
                return $this->pageNo - 1;
        }

        //判断是否第一页
        function isFirstPage(){
                return $this->pageNo == 1 || $this->pageCount==0;
        }

        //判断是否最后一页
        function isLastPage(){
                return $this->pageNo == $this->pageCount || $this->pageCount==0;
        }

        //装载某一页数据,成功则返回true,失败则返回false
        //        dataMaker是一个函数名,用于将一条记录转换为一个对象
        //        有一个参数为当前记录所有字段的值(一个以数字或字段名为索引的数组)
        function load($con, $sql, $dataMaker, $pageSize, $pageNo){
                //页大小和当前页码必须>=1
                if( $pageSize<1 || $pageNo<1 ) return false;

                //查询
                if( $rst = @mysql_query($sql, $con) ){
                        $this->pageSize = $pageSize;
                        $this->pageNo = $pageNo;

                        $this->rowCount = @mysql_num_rows($rst);
                        $this->pageCount = (int)(($this->rowCount + $this->pageSize - 1) / $this->pageSize);
                        $this->records = array();

                        //将光标移动到指定页的第一条记录前
                        $this->currentPageStartNo = ($this->pageNo - 1) * $this->pageSize + 1;
                        $firstRowNo = $this->currentPageStartNo;
                        while( --$firstRowNo>0 && @mysql_fetch_array($rst) );

                        //取出指定页的数据
                        $read = 0;
                        $this->currentPageSize = 0;
                        while( $read<$this->pageSize && $row=@mysql_fetch_array($rst) ){
                                $this->records[$this->currentPageSize++] = $dataMaker($row);
                                $read++;
                        }
                }
                else{
                        return false;
                }

                return true;
        }
};
?>

上一篇:MySQL中文模糊检索问题的解决方法        下一篇:使用Delphi6的DBExpress组件连接远程的Mysql数据库

本站所有资源均来源于网络,仅供学习和研究使用。如有侵犯版权之处,请联系站长,本站将在24小时内删除。