If you have already created pages and you want to apply pagination to them, it would not be a big deal.
Pagination is three step process.
1. you will need to create template file. In template file you can specify layout of your pagination. i.e. how your first, previous, next and last etc will be displayed.
2. instantiate your pagination class in the controller and pass data source- data source can be an array, values fetched form the database etc.
3. make some change in your template file, where you are showing your records.
Lets have a simple example.
First create a template file pagination.phtml in your “/application/view/script/” folder and place the following code
previous)): ?>
url(array('page' => $this->first)); ?>">Start |
Start |
previous)): ?>
url(array('page' => $this->previous)); ?>">< Previous |
< Previous |
pagesInRange as $page): ?>
current): ?>
url(array('page' => $page)); ?>">
next)): ?>
| url(array('page' => $this->next)); ?>">Next > |
| Next > |
next)): ?>
url(array('page' => $this->last)); ?>">End
End
Page current; ?> of last; ?>
The code above is self explanatory. We are creating links for the pagination.
Next add the following code in your controller.
$sql = 'SELECT * FROM table_name ';
$result = $db->fetchAll($sql);
$page=$this->_getParam('page',1);
$paginator = Zend_Paginator::factory($result);
$paginator->setItemCountPerPage(10));
$paginator->setCurrentPageNumber($page);
$this->view->paginator=$paginator;
In the code above we first fetch records from our database. Then instantiate our paginator by writing
$paginator = Zend_Paginator::factory($result);
And pass it results we have fatched.
We then set number of items per page and current page. On our first visit $page will have value 1.
At the end we assign this paginator to our view template.
And now in view template add the following code
foreach($this->paginator as $record)
{
echo $record['firstname'].'\n';
echo $record['lastname']. '\n'
...
...
}
paginationControl($this->paginator, 'Sliding', 'pagination.phtml'); ?
We are applying foreach loop to our paginator and echo our records. I assume that you have fistname, lastname columns in your table where you are fetching records form.Last line is compulsory. you need to call the paginator contorller and give it the $paginator, style of the pagination and the file name of the pagination template.
copy from here
will "viet hoa" late.
).