Very easy to use Zend Framework paging class_PHP tutorial-PHP Tutorial-php.cn

Here I would like to share with you a very useful Zend Framework paging class

The specific effect can be seen in the paging effect of this site. The CSS style can be changed according to personal design sense.

Here I will give an example to demonstrate how to use this class, as follows:

IndexController.php, write the following code in Action:

Copy code The code is as follows:

protected $_curPage = 1; //Default first page
const PERPAGENUM = 4; //Number of items displayed on each page

public function indexAction()
{
// $this->_blogModel has instantiated blog Model
// $rows -> Get the total number of entries of the displayed data
$rows = $this->_blogModel->getTotalRows();

If($pageNum = $this->getRequest()->getParam('page')) {
//If there is a value passed in, overwrite the initial first page
$this->_curPage = $pageNum;
}

//Transmit the data in the data table to the front end
$this->view->blogInfo = $this->_blogModel->getBlogInfo(
self::PERPAGENUM, ($this->_curPage-1)*self::PERPAGENUM
);
//Instantiate the paging class and pass it to the front end
$this->view->pagebar = $this->displayPageBar($rows);
}

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

models/Blog.php, write the following code:

Copy code The code is as follows:

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, write the following code:

Copy code The code is as follows:

pagebar; ?>

At this point, you can see the effect. If you want to pursue better page effects, please modify the paging class according to your personal preferences. I will not give a detailed example here

Copy code The code is as follows:

class Zend_Pagination
{
Private $_navigationItemCount = 6; //The navigation bar displays the total number of navigation pages
private $_pageSize = null; //Number of items per page
private $_align = "right"; //Navigation bar display position
private $_itemCount = null; //Total number of items
private $_pageCount = null; //Total number of pages
Private $_currentPage = null; //Current page
private $_front = null; //Front-end controller
private $_PageParaName = "page"; //Page parameter name

Private $_firstPageString = "|<<"; //Characters
displayed on the first page in the navigation bar private $_nextPageString = ">>"; //Characters displayed on the previous page in the navigation bar
Private $_previousPageString = "<<"; //Characters
displayed on the next page in the navigation bar Private $_lastPageString = ">>|"; //Characters
displayed on the last page in the navigation bar private $_splitString = " | "; //The spacer between page numbers

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-& gt; _pageCount = Ceil ($ itemcount/$ pagesize); // Total page
$page = $this->_front->getRequest()->getParam($this->_PageParaName);

If (empty($page) || (!is_numeric($page))) {
//If it is empty or not a number, set the current page to 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 = '

';
                                                        //What column is the current page in?
$pageCote = ceil($this->_currentPage / ($this->_navigationItemCount - 1)) - 1;
                 //Total paging column
$pageCoteCount = ceil($this->_pageCount / ($this->_navigationItemCount - 1));
               //Start page in the pagination column
$pageStart = $pageCote * ($this->_navigationItemCount -1) + 1;
              but but the $pageEnd = $pageStart + $this->_navigationItemCount - 1;                                                         If($this->_pageCount < $pageEnd) {
$pageEnd = $this->_pageCount;
        }
                                                                     $navigation .= "Total: {$this->_itemCount} items Total {$this->_pageCount} pages n ";
                                                                     if($pageCote > 0) {                                                                                                                                                                                                                                       $navigation .= '$this->_firstPageString ";
        }
If($this->_currentPage != 1) { //Previous page navigation
                $navigation .= '$this->_previousPageString ";
          }else{
                 $navigation .= $this->_previousPageString . ' ';
        }
                                                              while ($pageStart <= $pageEnd)                                                                                                                                                                                                                                                            {
If ($pageStart == $this->_currentPage) {
                     $navigation .= "$pageStart" . $this->_splitString;
               } else {
                     $navigation .= ' . $this->createHref($this->_currentPage+1)
                           . " \"="">$this->_nextPageString ";
        }else{
            $navigation .= $this->_nextPageString;
        }

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

        $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)) { //Specify target page
              $targetUrl .= "/$this->_PageParaName/$targetPage";
         } else {
                $targetUrl .= "/$this->_PageParaName/";
       }
          return $targetUrl;
}
}

Here is a brief review of limit offset in Mysql

Assume that the database table blog has 13 pieces of data.

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

//Statements 1 and 2 both return rows 10, 11, 12, and 13 of the table blog
//The 9 in statement 1 means starting from the tenth row of the table, returning 4 rows
//The 4 in statement 2 means returning 4 rows, and offset 9 means starting from the tenth row of the table

The following statement shows the paging effect:

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