分页

分页类：Page.class.php 现成的，

<?php//命名空间(以下命名空间最后会转换为目录的部分，进而获得本身类文件)namespace Common\Tools;class Page {    private $total; //数据表中总记录数    private $listRows; //每页显示行数    private $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();    }    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.="  <a href='{$this->uri}&page=1'>{$this->config["first"]}</a>  ";        return $html;    }    private function prev() {        $html = "";        if ($this->page == 1)            $html.='';        else            $html.="  <a href='{$this->uri}&page=" . ($this->page - 1) . "'>{$this->config["prev"]}</a>  ";        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.=" <a href='{$this->uri}&page={$page}'>{$page}</a> ";        }        $linkPage.=" {$this->page} ";        for ($i = 1; $i <= $inum; $i++) {            $page = $this->page + $i;            if ($page <= $this->pageNum)                $linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> ";            else                break;        }        return $linkPage;    }    private function next() {        $html = "";        if ($this->page == $this->pageNum)            $html.='';        else            $html.="  <a href='{$this->uri}&page=" . ($this->page + 1) . "'>{$this->config["next"]}</a>  ";        return $html;    }    private function last() {        $html = "";        if ($this->page == $this->pageNum)            $html.='';        else            $html.="  <a href='{$this->uri}&page=" . ($this->pageNum) . "'>{$this->config["last"]}</a>  ";        return $html;    }    private function goPage() {        return '  <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+\'\'">  ';    }    function fpage($display = array(0, 1, 2, 3, 4, 5, 6, 7, 8)) {        $html[0] = "  共有<b>{$this->total}</b>{$this->config["header"]}  ";        $html[1] = "  每页显示<b>" . ($this->end() - $this->start() + 1) . "</b>条，本页<b>{$this->start()}-{$this->end()}</b>条  ";        $html[2] = "  <b>{$this->page}/{$this->pageNum}</b>页  ";        $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;    }}

controller：

        // 分页显示        $info  = $goods->fetchData();

model：

    /**     * 分页显示数据     */    public function fetchData() {        $total    = $this->count();        $pagesize = C('page_size');        $page = new Page($total, $pagesize);        // 每页要显示的内容        $pageinfo = $this->where(array('is_del' => '不删除'))            ->order('goods_id DESC')            ->limit($page->offset, $pagesize)            ->select();        // 页码        $pagelist = $page->fpage();        return array(            'pageinfo' => $pageinfo,            'pagelist' => $pagelist,        );    }

页面：

<table class="table_a" border="1" width="100%">        <tbody>        <tr style="font-weight: bold;">            <td>序号|ID</td>            <td>商品名称</td>            <td>库存</td>            <td>价格</td>            <td>图片</td>            <td>缩略图</td>            <td>品牌</td>            <td>创建时间</td>            <td align="center">操作</td>        </tr>        <foreach name="info.pageinfo" key="k" item="v">            <tr id="product{$k+1}">                <td>{$k+1}-{$v.goods_id}</td>                <td><a href="#">{$v.goods_name}</a></td>                <td>{$v.goods_number}</td>                <td>{$v.goods_price}</td>                <td><img src="{:C('SITE_URL')}{$v.goods_big_logo|substr=###,2}" alt="暂无图片" height="60" width="60"></td>                <td><img src="{:C('SITE_URL')}{$v.goods_small_logo|substr=###,2}" alt="暂无图片" height="40" width="40">                </td>                <td>品牌</td>                <td>{$v.add_time|date="Y-m-d H:i:s", ###}</td>                <td><a href="{:U('upd', array('goods_id'=>$v['goods_id']))}">修改</a></td>                <td><a href="javascript:;" onclick="if (confirm('确定要删除？')) delete_goods({$v.goods_id})">删除</a></td>            </tr>        </foreach>        <tr>            <td colspan="20" style="text-align: center;">                {$info.pagelist}            </td>        </tr>        </tbody>    </table>