shop/Admin/Controller/GoodsController.class.php(后端商品控制器):
<?php
//后台商品控制器
namespace Admin\Controller;
use Think\Controller;
//Controller父类:ThinkPHP/Library/Think/Controller.class.php
class GoodsController extends Controller{
function showlist(){
$goods = D('Goods');
//实现数据分页效果
//① 获得总条数、每页显示条数设置
$cnt = $goods -> count(); //获得总条数 sum() max() avg() min()
//SELECT COUNT(*) AS tp_count FROM `sw_goods` LIMIT 1
$per = 7; //每页显示记录数
//② 实例化分页类对象
$page_obj = new \Tools\Page($cnt,$per);
//③ 制作一条sql语句,获得每页显示的数据
//$page_obj->limit: 分页工具类会根据当前页码把"limit 偏移量,长度"" 给拼装好
//并赋值给limit成员属性
$sql = "select * from sw_goods order by goods_id desc ".$page_obj->limit;
$info = $goods -> query($sql);
//④ 制作页码列表
$pagelist = $page_obj -> fpage(array(3,4,5,6,7,8));
$this -> assign('pagelist',$pagelist);
$this -> assign('info',$info);
$this -> display();
}
}
shop/Tools/Page.class.php(自定义的分页工具类):
<?php
//命名空间名称与具体目录没有直接关系
//tp框架中的命名空间与具体目录有直接关系
//原因:tp框架中的类在被使用的时候需要通过autoload自动加载机制引入
// 在autoload内部会把命名空间(例如Tools)转化为“目录”的一部分,进而获得对应的类文件
namespace Tools;
class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config = array('header' => "个记录", "prev" => "上一页", "next" => "下一页", "first" => "首 页", "last" => "尾 页");
private $listNum = 8; //8个页码条
/*
* $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() {
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
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;
}
}