Pagination ========== The process of pagination takes place when we need to present big groups of arbitrary data gradually. Phalcon\\Paginator offers a fast and convenient way to split these sets of data browsable pages. Data Adapters ------------- This component makes use of adapters to encapsulate different sources of data: +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Adapter | Description | +==============+===============================================================================================================================================================================+ | NativeArray | Use a PHP array as source data | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Model | Use a Phalcon\\Mvc\\Model\\Resultset object as source data. Since PDO doesn't support scrollable cursors this adapter shouldn't be used to paginate a large number of records | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | QueryBuilder | Use a Phalcon\\Mvc\\Model\\Query\\Builder object as source data | +--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Examples -------- In the example below, the paginator will use as its source data the result of a query from a model, and limit the displayed data to 10 records per page: .. code-block:: php request->getQuery('page', 'int'); // GET // $this->request->getPost('page', 'int'); // POST $currentPage = (int) $_GET["page"]; // The data set to paginate $robots = Robots::find(); // Create a Model paginator, show 10 rows by page starting from $currentPage $paginator = new PaginatorModel( array( "data" => $robots, "limit" => 10, "page" => $currentPage ) ); // Get the paginated results $page = $paginator->getPaginate(); Variable $currentPage controls the page to be displayed. The $paginator->getPaginate() returns a $page object that contains the paginated data. It can be used for generating the pagination: .. code-block:: html+php
Id | Name | Type |
---|---|---|
id; ?> | name; ?> | type; ?> |