Zend Framework 2.0.5 - Pagination with Stored Procedure

For programming and general questions on Zend Framework
Post Reply
aashah
Posts: 8
Joined: Thu Dec 20, 2012 2:26 pm

Zend Framework 2.0.5 - Pagination with Stored Procedure

Post by aashah » Fri Jan 04, 2013 8:41 am

Hi All,

I am working on Zend Framework 2.0.5 with MS-SQL as database and stored procedure. Here, I am getting list of albums with zend pagination through MS-SQL & Stored Procedure. In controller and model class code as follows,

Album Controller file :

Code: Select all

    	$select = $this->getAlbumTable()->getAlbumSelect(LOGGEDIN_USER_ID); 
    	$matches = $this->getEvent()->getRouteMatch();
    	$page      = $matches->getParam('page', 1);
    
    	$paginator = new \Zend\Paginator\Paginator(new \Zend\Paginator\Adapter\DbSelect($select, $this->getAlbumTable()->getAdapter()));    	
        $paginator->setItemCountPerPage(3);                 
        $paginator->setCurrentPageNumber($this->getEvent()->getRouteMatch()->getParam('page'));     
        
        return array( 
        'albums' => $paginator, 
        );
Album Model file :

Code: Select all

    public function getAlbumSelect($user_id = 0) 
    {                                                                
        $results = $this->adapter->query("select * from album", Adapter::QUERY_MODE_PREPARE);
        return $results;
     } 
But above code is not working and giving me error as,

"Catchable fatal error: Argument 1 passed to Zend\Paginator\Adapter\DbSelect::__construct() must be an instance of Zend\Db\Sql\Select, instance of Zend\Db\Adapter\Driver\Sqlsrv\Statement given, called in D:\wamp\www\zf2_tutorial\module\Album\src\Album\Controller\AlbumController.php on line 54 and defined in D:\wamp\www\zf2_tutorial\vendor\zendframework\zendframework\library\Zend\Paginator\Adapter\DbSelect.php on line 59"


# Can anyone please guide me where I am making mistake or how we can implement Zend Paggination with MS-SQL Stored Procedure on Zend Framework 2.0.5.


Thanks in advanced.


Regards,
Ankit Shah.

Post Reply