Paging in mvc

quannm0410l · #1 (**permalink**) 04-06-2007, 07:47 AM

anyone tells me how to create paging in zend fr

? thank you

quannm0410l · #2 (**permalink**) 04-07-2007, 02:12 AM

Zend_View_Pagination helpppppppp

SpotSec · #3 (**permalink**) 04-07-2007, 03:35 PM

There's a Zend_View_Pagination? Thought that never made it through?
Anyways all I know for now is for pagination you either have to implement it yourself or use some third party pagination methods.

Martin Hujer · #4 (**permalink**) 04-07-2007, 05:56 PM

Check this
It's in czech, but try it...

foobared · #5 (**permalink**) 07-31-2007, 04:25 PM

Pagination is basically getting the limit and offet sent to the SQL statement like:
"SELECT * FROM myTable LIMIT $numRowsToGet, $getRowsFromOffset"
I created a PAGINATOR view helper class to handle pagination. It received $params and $total from the controller.
Here is the code. Any suggestions / comments would be great.

PHP Code:


			


/**

*    PAGINATION HELPER

    

    $params = array(

        'limit' = int,

        'offset' = int

    )

    $total = int -> total numbers of results

*

/**/

class XV_View_Helper_Paginator{

    

    public $view;



    public function setView(Zend_View_Interface $view)

    {

        $this->view = $view;

    }

    public function paginator(){

        $total =  $this->view->contactsPage['count']; 

        $params = $this->view->params;

        // set offsets

        $firstOffset = 0;

        $prevOffset = $params['offset'] - $params['limit'];

        $nextOffset = $params['offset'] + $params['limit'];

        $lastOffset = (round( $total / $params['limit']) * $params['limit']) - $params['limit'];

        // build pagination links

        $firstHTML = ($params['offset'] == $firstOffset ) ? '&laquo; First' : '<a href="../../../XV/View/Helper/'. $this->buildUrl(0, $params['limit']) . '">&laquo; First</a>'; 

        $prevHTML = ($prevOffset < 0 ) ? ' &lt; Prev' : '<a href="../../../XV/View/Helper/'. $this->buildUrl($prevOffset, $params['limit']) . '">&lt; Prev</a>';

        $nextHTML = ($nextOffset > $total) ? 'Next &gt;' : '<a href="../../../XV/View/Helper/'. $this->buildUrl($nextOffset, $params['limit']) . '">Next &gt; </a>';

        $lastHTML = ($nextOffset > $total) ? 'Last &raquo;' : '<a href="../../../XV/View/Helper/'. $this->buildUrl($lastOffset, $params['limit']) . '">Last &raquo;</a>';

        // set page and record vars

        $currentPage = ($params['offset'] / $params['limit']) + 1 ;

        $totalPages = round($lastOffset / $params['limit']) + 1;

        //$recordFrom

        $recordTo = ($nextOffset > $total) ? $total : $nextOffset;

        // build pagination table

        $pagiTableHTML = '<table width="" class="pagi">

                    <tr>

                        <td class="link">'.$firstHTML.'</td>

                        <td class="link">'.$prevHTML.'</td>

                        <td class="pageText">Page '. $currentPage .' of '. $totalPages .'</td>

                        <td class="link">'.$nextHTML.'</td>

                        <td class="link">'.$lastHTML.'</td>

                        <td class="recordText">Displaying '.($params['offset']+1).' - '.$recordTo.' of '.$total.' Records</td>

                    </tr>

                    </table>';

        return $pagiTableHTML;

    }

    public function buildUrl($offset, $limit){

        return $this->view->modulePath ."/contact?offset=$offset&limit=$limit";

    }

}

Leif.Högberg · #6 (**permalink**) 08-16-2007, 08:55 AM

The db stuff is handled outside of the paginator.
This could easily be modified in to a helper.

PHP Code:


			
<?php

/*

        Author: Leif Högberg @ Gomitech



    paging algorithm is based upon code from the punBB project at www.punbb.org

    

    Usage:

    $P = new Gomi_Paginator();



    $P->setLinkUrl('foo.php?%PAGE%');

    $P->setLinkHTML('<a href="%URL%">%PAGE%</a>');

    $P->setCurrentHTML('<b>%PAGE%</b>');

    

    echo $P->generateLinkString(6); // Will output "1 2 3 ... 6"

*/

class Gomi_Paginator

{



    protected $linkUrl = '%PAGE%';

    protected $linkHTML = '<a href="%URL%">%PAGE%</a>';

    protected $currentHTML = '<b>%PAGE%</b>';

    protected $linkAllPages = false;

    protected $pageSeparator = '&nbsp;';

        

    public function getLinkUrl()

    {

        return $this->linkUrl;

    }    

    public function setLinkUrl($url)

    {

        $this->linkUrl = $url;

    }



    public function getLinkHTML()

    {

        return $this->linkHTML;

    }

    public function setLinkHTML($linkHTML)

    {

        $this->linkHTML = $linkHTML;

    }

    

    public function getCurrentHTML()

    {

        return $this->currentHTML;

    }

    public function setCurrentHTML($html)

    {

        $this->currentHTML = $html;

    }

    

    public function getLinkAllPages()

    {

        return $this->linkAllPages;

    }

    public function setLinkAllPages($bool)

    {

        $this->linkAllPages = $bool;

    }

    

    public function getPageSeparator()

    {

        return $this->pageSeparator;

    }

    public function setPageSeparator($str)

    {

        $this->pageSeparator = $str;

    }

    

    private function generateCurrentStringForPage($page)

    {

        return str_replace('%PAGE%', $page, $this->getCurrentHTML());

    }

    private function generateLinkStringForPage($page)

    {

        return str_replace(array('%URL%', '%PAGE%'), array($this->getLinkUrl(), $page), $this->getLinkHTML());

    }

    

    private function generate($totalPages, $currentPage = 1)

    {

        $pages = array();



            //just one page

        if ($totalPages <= 1)

        {

            if ($this->getLinkAllPages())

            {

                $pages[] = $this->generateLinkStringForPage(1);

            }

            else

            {

                $pages[] = $this->generateCurrentStringForPage(1);

            }

        }

            //more than one page

        else

        {

            if ($currentPage > 3)

            {

                $pages[] = $this->generateLinkStringForPage(1);



                if ($currentPage != 4)

                    $pages[] = '&hellip;';

            }



            for ($index = $currentPage - 2, $stop = $currentPage + 3; $index < $stop; ++$index)

            {

                if ($index < 1 || $index > $totalPages)

                    continue;

                else if ($index != $currentPage || $this->getLinkAllPages())

                    $pages[] = $this->generateLinkStringForPage($index);

                else

                    $pages[] = $this->generateCurrentStringForPage($index);

            }



            if ($currentPage <= ($totalPages - 3))

            {

                if ($currentPage != ($totalPages - 3))

                    $pages[] = '&hellip;';



                $pages[] = $this->generateLinkStringForPage($totalPages);

            }

        }

        

        return $pages;

    }

    

    public function generateLinkString($totalPages, $currentPage = 1)

    {

        $pages = $this->generate($totalPages, $currentPage);

        return implode($this->getPageSeparator(), $pages);

    }



}

carloseduardo · #7 (**permalink**) 08-28-2007, 06:53 PM

Hello everybody, I found this simple yet powerful pagination class that works over arrays collections, so it can be used for paginating database resultsets, XML documents or everything else convertible to arrays in PHP language.
It's provided as a zip package consisting on the class source code and a quick start manual.
Hope you like it.

Elemental · #8 (**permalink**) 09-02-2007, 07:45 PM

this post at Digital Fashion is designed for ZF (uses Zend_Db etc.)

However, I ended up using AJAX for this. The controller runs the query and returns all results to the browser, then I made a javascript pagination object. This is handy as I don't have to worry about limits and offsets for my queries and all the sorting is done on the client side. jQuery makes this a breeze.

beeXtreem · #9 (**permalink**) 07-21-2008, 03:15 PM

Elemental, would you mind sharing your ajax pagination function. If not, can you please post a copy here.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode