【硬上PHP】数据列表,分页显示

来源：互联网发布：mysql 锁表后能读吗编辑：程序博客网时间：2024/05/24 23:14

就不反复造轮子了，不想用thinkphp分页工具类？

那就网上找一份呗。

为了更好地让大家了解，我就写多些注释呗，其实自己也是菜鸡一只。嘿嘿，菜鸡互啄不喜勿喷。

<?php//命名空间(以下命名空间最后会转换为目录的部分，进而获得本身类文件)namespace Common\Tools;class Page{    private $total;     //数据表中总记录数    private $listRows;  //每页显示行数    private $limit;     //拼写mysql语句limit    private $uri;       //域名地址    private $pageNum;   //页数    private $config = array('header' => "个记录", "prev" => "上一页", "next" => "下一页", "first" => "首 页", "last" => "尾 页");    private $listNum = 8;   //底部列表索引按钮的个数    private $offset = 0;    //偏移量    /*     * $total      * $listRows     * 这就一构造函数（不懂自行百度）     */    public function __construct($total, $listRows = 10, $pa = "")    {        $this->total = $total;        $this->listRows = $listRows;        $this->uri = $this->getUri($pa);        $this->page = !empty($_GET["page"]) ? $_GET["page"] : 1;        $this->pageNum = ceil($this->total / $this->listRows);        $this->limit = $this->setLimit();    }//    返回sql，limit语句。    private function setLimit()    {        $this->offset = ($this->page - 1) * $this->listRows;        return "Limit " . ($this->page - 1) * $this->listRows . ", {$this->listRows}";//下一页的偏移量数据数量    }    private function getUri($pa)    {        $url = $_SERVER["REQUEST_URI"] . (strpos($_SERVER["REQUEST_URI"], '?') ? '' : "?") . $pa;        $parse = parse_url($url);        if (isset($parse["query"])) {            parse_str($parse['query'], $params);            unset($params["page"]);            $url = $parse['path'] . '?' . http_build_query($params);        }        return $url;    }    function __get($args)    {        if ($args == "limit")            return $this->limit;        else if ($args == 'offset')            return $this->offset;        else            return null;    }    private function start()    {        if ($this->total == 0)            return 0;        else            return ($this->page - 1) * $this->listRows + 1;    }    private function end()    {        return min($this->page * $this->listRows, $this->total);    }//    首页    private function first()    {        $html = "";        if ($this->page == 1)            $html .= '';        else            $html .= "&nbsp;&nbsp;<a href='{$this->uri}&page=1'>{$this->config["first"]}</a>&nbsp;&nbsp;";        return $html;    }//    上一页    private function prev()    {        $html = "";        if ($this->page == 1)            $html .= '';        else            $html .= "&nbsp;&nbsp;<a href='{$this->uri}&page=" . ($this->page - 1) . "'>{$this->config["prev"]}</a>&nbsp;&nbsp;";        return $html;    }//    当前页    private function pageList()    {        $linkPage = "";        $inum = floor($this->listNum / 2);        for ($i = $inum; $i >= 1; $i--) {            $page = $this->page - $i;            if ($page < 1)                continue;            $linkPage .= "&nbsp;<a href='{$this->uri}&page={$page}'>{$page}</a>&nbsp;";        }        $linkPage .= "&nbsp;{$this->page}&nbsp;";        for ($i = 1; $i <= $inum; $i++) {            $page = $this->page + $i;            if ($page <= $this->pageNum)                $linkPage .= "&nbsp;<a href='{$this->uri}&page={$page}'>{$page}</a>&nbsp;";            else                break;        }        return $linkPage;    }//    下一页    private function next()    {        $html = "";        if ($this->page == $this->pageNum)            $html .= '';        else            $html .= "&nbsp;&nbsp;<a href='{$this->uri}&page=" . ($this->page + 1) . "'>{$this->config["next"]}</a>&nbsp;&nbsp;";        return $html;    }//    尾页    private function last()    {        $html = "";        if ($this->page == $this->pageNum)            $html .= '';        else            $html .= "&nbsp;&nbsp;<a href='{$this->uri}&page=" . ($this->pageNum) . "'>{$this->config["last"]}</a>&nbsp;&nbsp;";        return $html;    }//    表单跳转    private function goPage()    {        return '&nbsp;&nbsp;<input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>' . $this->pageNum . ')?' . $this->pageNum . ':this.value;location=\'' . $this->uri . '&page=\'+page+\'\'}" value="' . $this->page . '" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>' . $this->pageNum . ')?' . $this->pageNum . ':this.previousSibling.value;location=\'' . $this->uri . '&page=\'+page+\'\'">&nbsp;&nbsp;';    }    function fpage($display = array(0, 1, 2, 3, 4, 5, 6, 7, 8))    {        $html[0] = "&nbsp;&nbsp;共有<b>{$this->total}</b>{$this->config["header"]}&nbsp;&nbsp;";        $html[1] = "&nbsp;&nbsp;每页显示<b>" . ($this->end() - $this->start() + 1) . "</b>条，本页<b>{$this->start()}-{$this->end()}</b>条&nbsp;&nbsp;";        $html[2] = "&nbsp;&nbsp;<b>{$this->page}/{$this->pageNum}</b>页&nbsp;&nbsp;";        $html[3] = $this->first();        $html[4] = $this->prev();        $html[5] = $this->pageList();        $html[6] = $this->next();        $html[7] = $this->last();        $html[8] = $this->goPage();        $fpage = '';        foreach ($display as $index) {            $fpage .= $html[$index];        }        return $fpage;    }}

有了工具类之后就好办了，直接在项目里面调用就好了。

因为展示的是数据库的数据，直接在model里面定义方法调用就好了。

在Controller里面调用

$goods = new GoodsModel();$nowinfo = $goods -> fetchData();

在GoodsModel里面定义fetchData();

//给后台获得商品列表信息，有"分页"要求function fetchData(){    //① 获得商品总条数    $total = $this -> count();    $per = 5;    //② 实例化分页类Page对象    $page = new Page($total,$per);    //③ 获得分页信息    $pageinfo = $this -> order('goods_id desc')->limit($page->offset,$per)->select();    //④ 获得页码列表信息    $pagelist = $page -> fpage(array(3,4,5,6,7,8));    return array(        'pageinfo'=>$pageinfo,        'pagelist'=>$pagelist    );}

回到Controller里的布局方法里面

$goods = new GoodsModel();$nowinfo = $goods -> fetchData();

$info = $nowinfo['pageinfo']; //当前页数据信息$pagelist = $nowinfo['pagelist'];//页码列表信息$this -> assign('info',$info);    //填充数据到布局里面name为info的表单里面。$this -> assign('pagelist',$pagelist);//填充数据到布局里面name为pagelist的表单里面。$this -> display(); //展示。

布局文件

<foreach name="info" item="v">    <tr id="product1">        <td>{$v.goods_id}</td>        <td><a href="#">{$v.goods_name}</a></td>        <td>{$v.goods_price}</td>        <td>{$v.add_time}</td>        <td>{$v.goods_weight}</td>        <td><img src='{$Think.config.SITE_URL}{$v.goods_big_logo|substr=###,2}' alt='暂无图片' width='100'                 height='100'/></td>        <td><img src='{$Think.config.SITE_URL}{$v.goods_small_logo|substr=###,2}' alt='暂无图片' width='60'                 height='60'/></td>        <td><a href="{:U('Background/Goods/update')}">修改</a></td>        <td><a href="javascript:;" onclick="delete_product(1)">删除</a></td></foreach></tr><tr>    <td colspan="20" style="text-align: center;">        {$pagelist}    </td></tr>

效果：

初学，若有不对的地方还望指教，赐教。谢谢。

阅读全文

0 0