具體效果可見本站的分頁效果, CSS樣式可根據個人設計感進行更變。
這里我會舉例演示如何使用該類, 如下:

IndexController.php, 在 Action 中寫入如下代碼: " /> 亚洲综合精品一区二区三区中文,大胸美女被强吻胸动态图片,一级特黄录像播放

一区二区久久-一区二区三区www-一区二区三区久久-一区二区三区久久精品-麻豆国产一区二区在线观看-麻豆国产视频

非常好用的Zend Framework分頁類

在這里和大家分享一個非常好用的 Zend Framework 分頁類
 
具體效果可見本站的分頁效果, 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;

php技術非常好用的Zend Framework分頁類,轉載需保留來源!

鄭重聲明:本文版權歸原作者所有,轉載文章僅為傳播更多信息之目的,如作者信息標記有誤,請第一時間聯系我們修改或刪除,多謝。

主站蜘蛛池模板: 狠狠做狠狠做综合日日 | 国产小视频在线观看免费 | 成人久久伊人精品伊人 | 激情综合网五月天 | 国产三级网站在线观看 | 国产亚洲精品国产福利在线观看 | 青青草国产精品久久久久 | 国产91精品一区二区麻豆网站 | 91精品宅男在线观看 | 91高清视频在线观看 | 激情五月宗合网 | 久久精热 | 一级毛片无遮挡免费全部 | 免费a资源 | 久久精品国产线看观看亚洲 | 午夜综合网| 九九99九九精彩 | 视频一区视频二区在线观看 | 欧美成人免费一级人片 | 亚洲图片另类图片 | 亚洲激情综合网 | 色五夜婷婷 | 99ri国产在线| 四虎影视永久在线精品免费 | 99久久国产综合精品国 | 加勒比一区二区三区 | 欧美一区二区三区视视频 | 色多多www视频在线观看免费 | 国产一区二区在线免费观看 | 涩涩色中文综合亚洲 | 日韩中文字幕精品一区在线 | 精品视频免费观看 | 亚洲另类图| 精品四虎免费观看国产高清 | 亚洲色女| 九一视频在线观看 | 国产盗摄精品一区二区三区 | 成人小视频网 | 色综合久久伊人 | 天堂资源在线官网资源 | 欧美美女视频网站 |