I found an example it seems to work but I think it does not filter the
result at sql query level.
controller:
public function indexAction() { // action body
$dbResult = $this->user->getAllUsers ();
$pageNumber = 10;
$itemNumber = 10;
$paginator = Zend_Paginator::factory ( $dbResult );
$paginator->setItemCountPerPage ( $pageNumber );
$paginator->getItemsByPage ( $itemNumber );
$paginator->setCurrentPageNumber ( $this->_getParam ( 'page' ) );
Zend_Paginator::setDefaultScrollingStyle ( 'Sliding' );
$view = new Zend_View ( );
$paginator->setView ( $view );
$this->view->users = $paginator;
$this->view->paginator = $paginator;
}
model:
public function getAllUsers(){
$select = $this->select()
->setIntegrityCheck(false)
->from(array('u'=>'user'),array('*'))
->joinLeft(array('ud'=>'user_detail'), 'u.id_user =
ud.id_user')
->order(array('ud.name','ud.surname'));
$result = $this->fetchAll($select);
return $result;
}
On Tue, Jul 6, 2010 at 5:06 PM, Serkan Temizel <[email protected]>wrote:
> Hi,
>
> Do one of you have an example code for model - controller paginator.
> Exapmles on web are mostly in a controller but I want to manage DB works in
> my model.
>
> thanks
>
