就不反复造轮子了,不想用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 .= " <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" οnkeydοwn="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" οnclick="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;
}
}
有了工具类之后就好办了,直接在项目里面调用就好了。
因为展示的是数据库的数据,直接在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:;" οnclick="delete_product(1)">删除</a></td>
</foreach>
</tr>
<tr>
<td colspan="20" style="text-align: center;">
{$pagelist}
</td>
</tr>
效果:
初学,若有不对的地方还望指教,赐教。谢谢。