具体效果可见本站的分页效果, CSS样式可根据个人设计感进行更变。
这里我会举例演示如何使用该类, 如下:
IndexController.php, 在 Action 中写入如下代码:
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,写入如下代码:
public function getBlogInfo($perPageNum = NULL, $limit = NULL) { return $this->fetchAll('1 = 1', 'blog_id desc', $perPageNum, $limit) ->toArray(); } public function getTotalRows($where = '1=1') { return $this->fetchAll($where)->count(); }
index.phtml, 写入如下代码:
<div class="page"> <!--?php echo $this--->pagebar; ?> </div>
到这里,就可以看见效果了, 如想追求更好的页面效果, 请根据个人喜好修改分页类,这里就不作详细示例
class Zend_Pagination { private $_navigationItemCount = 6; //导航栏显示导航总页数 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</a> "; } if($this->_currentPage != 1) { //上一页导航 $navigation .= '<a href="'.$this->createHref($this->_currentPage-1); $navigation .= " \"="">$this->_previousPageString</a> "; }else{ $navigation .= $this->_previousPageString . ' '; } while ($pageStart <= $pageEnd) //构造数字导航区 { if ($pageStart == $this->_currentPage) { $navigation .= "<b>$pageStart</b>" . $this->_splitString; } else { $navigation .= '<a href="'.$this->createHref($pageStart) ." \"="">$pageStart</a>" . $this->_splitString; } $pageStart++; } if($this->_currentPage != $this->_pageCount) { //下一页导航 $navigation .= ' <a href="' . $this->createHref($this->_currentPage+1) . " \"="">$this->_nextPageString</a> "; }else{ $navigation .= $this->_nextPageString; } if ($pageCote < $pageCoteCount-1) { //未页导航 $navigation .= '<a href="' . $this->createHref($this->_pageCount) . " \"="">$this->_lastPageString</a> "; } $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 . '</option>'; } $navigation .= '</select>'; $navigation .= " 页</div>"; 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;