非常好用的Zend Framework分页类

前端之家收集整理的这篇文章主要介绍了非常好用的Zend Framework分页类前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

在这里和大家分享一个非常好用的 Zend Framework 分页

具体效果可见本站的分页效果, CSS样式可根据个人设计感进行更变。

这里我会举例演示如何使用该类, 如下:

IndexController.PHP, 在 Action 中写入如下代码:
<div class="codetitle"><a style="CURSOR: pointer" data="85595" class="copybut" id="copybut85595" onclick="doCopy('code85595')"> 代码如下:

<div class="codebody" id="code85595">
protected $_curPage = 1; //默认第一页
const PERPAGENUM = 4; //每页显示条目数

public function indexAction()
{
// $this->_blogModel 已实例化 blog Model
// $rows -> 获得到所展示数据的总条目数
$rows = $this->_blogModel->getTotalRows();

if($pageNum = $this->getRequest()->getParam('page')) {
//如果有值传入,覆盖初始的第一页
$this->_curPage = $pageNum;
}

//把数据表中的数据传到前端
$this->view->blogInfo = $this->_blogModel->getBlogInfo(
self::PERPAGENUM,($this->_curPage-1)*self::PERPAGENUM
);
//实例化分页类,并传到前端
$this->view->pagebar = $this->displayPageBar($rows);
}

private function displayPageBar($totalRows)
{
$Pager = new Zend_Pagination($totalRows,self::PERPAGENUM);
return $Pager->getNavigation();
}

models/Blog.PHP,写入如下代码:

代码如下:
fetchAll('1 = 1','blog_id desc',$perPageNum,$limit) ->toArray(); }

public function getTotalRows($where = '1=1')
{
return $this->fetchAll($where)->count();
}

index.phtml,写入如下代码:

代码如下:
pagebar; ?>

到这里,就可以看见效果了, 如想追求更好的页面效果, 请根据个人喜好修改分页类,这里就不作详细示例

代码如下:
显示导航总页数 private $_pageSize = null; //每页项目数 private $_align = "right"; //导航栏显示位置 private $_itemCount = null; //总项目数 private $_pageCount = null; //总页数 private $_currentPage = null; //当前页 private $_front = null; //前端控制器 private $_PageParaName = "page"; //页面参数名称

private $_firstPageString = "|<<"; //导航栏中第一页显示的字符
private $_nextPageString = ">>"; //导航栏中前一页显示的字符
private $_prevIoUsPageString = "<<"; //导航栏中后一页显示的字符
private $_lastPageString = ">>|"; //导航栏中最后一页显示的字符
private $_splitString = " | "; //页数字间的间隔符

public function __construct($itemCount,$pageSize)
{
if (!is_numeric($itemCount) || (!is_numeric($pageSize))) {
throw new Exception("Pagination Error:not Number");
}
$this->_itemCount = $itemCount;
$this->_pageSize = $pageSize;
$this->_front = Zend_Controller_Front::getInstance();

$this->_pageCount = ceil($itemCount/$pageSize); //总页数
$page = $this->_front->getRequest()->getParam($this->_PageParaName);

if (empty($page) || (!is_numeric($page))) {
//为空或不是数字,设置当前页为1
$this->_currentPage = 1;
} else {
if ($page < 1) {
$page = 1;
}
if ($page > $this->_pageCount) {
$page = $this->_pageCount;
}
$this->_currentPage = $page;
}
}

public function getCurrentPage()
{
return $this->_currentPage;
}

public function getNavigation()
{
$navigation = '<div style="text-align:'.$this->_align.';" class="pagecss">';

//当前页处于第几栏分页
$pageCote = ceil($this->_currentPage / ($this->_navigationItemCount - 1)) - 1;
//总分页
$pageCoteCount = ceil($this->_pageCount / ($this->_navigationItemCount - 1));
//分页栏中起始页
$pageStart = $pageCote * ($this->_navigationItemCount -1) + 1;
//分页栏中终止页
$pageEnd = $pageStart + $this->_navigationItemCount - 1;

if($this->_pageCount < $pageEnd) {
$pageEnd = $this->_pageCount;
}

$navigation .= "总共: {$this->_itemCount} 条 共 {$this->_pageCount} 页\n ";

if($pageCote > 0) { //首页导航
$navigation .= '<a href="'.$this->createHref(1)
." \"="">$this->_firstPageString ";
}
if($this->_currentPage != 1) { //上一页导航
$navigation .= '<a href="'.$this->createHref($this->_currentPage-1);
$navigation .= " \"="">$this->_previousPageString ";
}else{
$navigation .= $this->_prevIoUsPageString . '';
}

while ($pageStart <= $pageEnd) //构造数字导航区
{
if ($pageStart == $this->_currentPage) {
$navigation .= "$pageStart" . $this->_splitString;
} else {
$navigation .= '<a href="'.$this->createHref($pageStart)
." \"="">$pageStart"
. $this->_splitString;
}
$pageStart++;
}

if($this->_currentPage != $this->_pageCount) { //下一页导航
$navigation .= ' <a href="'
. $this->createHref($this->_currentPage+1)
. " \"="">$this->_nextPageString ";
}else{
$navigation .= $this->_nextPageString;
}

if ($pageCote < $pageCoteCount-1) { //未页导航
$navigation .= '<a href="'
. $this->createHref($this->_pageCount)
. " \"="">$this->_lastPageString ";
}

$navigation .= '到 <select onchange="window.location=\' '
. $this->createHref()
. '\'+this.options[this.selectedIndex].value;">';

for ($i=1;$i<=$this->_pageCount;$i++){
if ($this->getCurrentPage()==$i){
$selected = "selected";
} else {
$selected = "";
}
$navigation .= '<option value=" . $i . " '="" .="" $selected="">'
. $i
. '';
}
$navigation .= '';
$navigation .= " 页

";
return $navigation;
}

public function getNavigationItemCount()
{
return $this->_navigationItemCount;
}

public function setNavigationItemCoun($navigationCount)
{
if(is_numeric($navigationCount)) {
$this->_navigationItemCount = $navigationCount;
}
}

public function setFirstPageString($firstPageString)
{
$this->_firstPageString = $firstPageString;
}

public function setPrevIoUsPageString($prevIoUsPageString)
{
$this->_prevIoUsPageString = $prevIoUsPageString;
}

public function setNextPageString($nextPageString)
{
$this->_nextPageString = $nextPageString;
}

public function setLastPageString($lastPageString)
{
$this->_lastPageString = $lastPageString;
}

public function setAlign($align)
{
$align = strtolower($align);
if ($align == "center") {
$this->_align = "center";
} elseif ($align == "right") {
$this->_align = "right";
} else {
$this->_align = "left";
}
}

public function setPageParamName($pageParamName)
{
$this->_PageParaName = $pageParamName;
}

public function getPageParamName()
{
return $this->_PageParaName;
}

private function createHref($targetPage = null)
{
$params = $this->_front->getRequest()->getParams();
$module = $params["module"];
$controller = $params["controller"];
$action = $params["action"];

$targetUrl = $this->_front->getBaseUrl()
. "/$module/$controller/$action";

foreach ($params as $key => $value)
{
if($key != "controller" && $key != "module"
&& $key != "action" && $key != $this->_PageParaName) {
$targetUrl .= "/$key/$value";
}
}
if (isset($targetPage)) { //指定目标页
$targetUrl .= "/$this->_PageParaName/$targetPage";
} else {
$targetUrl .= "/$this->_PageParaName/";
}
return $targetUrl;
}
}

这里再简单回顾下 MysqL 中的 limit offset

假设数据库表 blog 存在 13 条数据。

语句1:select * from blog limit 9,4 语句2:select * from blog limit 4 offset 9

//语句1和2均返回表 blog 的第 10、11、12、13 行 //语句1中的 9 表示从表的第十行开始, 返回 4 行 //语句2中的 4 表示返回 4 行,offset 9 表示从表的第十行开始

如下语句显示分页效果:

语句3:select * from blog limit ($this->_curPage - 1)* self::PERPAGENUM,self::PERPAGENUM; 语句4:select * from blog limit self::PERPAGENUM offset ($this->_curPage - 1) * self::PERPAGENUM;

猜你在找的PHP相关文章