How to paginate search results?

Question

I want to paginate search results using Zend_Paginator. So I pass my data to a paginator instance:

$paginator = new Zend_Paginator ( 
           new Zend_Paginator_Adapter_DbSelect ( $data ) 
);

Data is returned this way

public function getData($idArray){
        $db = Zend_Db_Table::getDefaultAdapter();
        $selectProgramme = new Zend_Db_Select($db);

        $selectProgramme->from('programme')
                            ->order('id DESC')
                            ->where('id IN(?)', $idArray);

        return $selectProgramme;        
}

$idArray is provided by my search implementations. This all works great and I get the correct data and pagination links displayed.

However I can't paginate the result because the pagination links are not valid. So normal pagination would have following link:

mysite.de/home/index/page/1

in search I now have

mysite.de/home/search/page/1

This does not work. Any suggestions how to implement search pagination?

EDIT: I have a HomeController with two actions, index and search action. IndexAction displays all data and I can paginate it.

public function indexAction(){
    //...
    $paginator = new Zend_Paginator(
                 new Zend_Paginator_Adapter_DbSelect($data)
    );
    $paginator->setItemCountPerPage(16)
              ->setPageRange(20)
              ->setCurrentPageNumber($this->_getParam('page', 1));

    $this->view->data = $paginator;
}

The searchActions handles the search process:

public function searchAction(){
    $response = $solr->search($this->getRequest()->getParam('search', null));
    //...if items found get the data exactly the same way as in the 
    // index action, using Zend_Paginator_Adapter_DbSelect
    $paginator = new Zend_Paginator(
                 new Zend_Paginator_Adapter_DbSelect($data)
    );
    $paginator->setItemCountPerPage(16)
              ->setPageRange(20)
              ->setCurrentPageNumber($this->_getParam('page', 1));

    $this->view->data = $paginator;
}

So like you see in the search action there is a problem with the search process when I paginate. I need to decide somehow if to search or to paginate. Any suggestions on that?

Answer 1

Since search required the search parameter pagination will fail because when paginating the the search parameter is null.

$sreq = $this->getRequest()->getParam('search', null);

So we need to pass this parameter whenever we paginate our search. I solve this using Zend_Session:

//get search param
$sreq = $this->getRequest()->getParam('search', null);
//store search param in session for pagination
$search = new Zend_Session_Namespace('PSearch');

if($sreq != null){
    $search->psearch = $sreq;
}else{
   $sreq = $search->psearch;
}

I have this at the top of my searchAction and everything works.