Using Zend_Paginator without Select Adapter

Question

I want to use Zend_Paginator but Zend_Paginator requires Zend_Db_Select as input parameter.

My SQL query is some how a little complicated making it so difficult to implement with Zend_Db_Select.

Can i use Zend_Paginator with plain SQL query?

Answer 1

Yes you can, From the ZF docs:

The primary design goals of Zend_Paginator are as follows:

• Paginate arbitrary data, not just relational databases
• Loosely couple Zend_Paginator to other Zend Framework components so that users who wish to use it independently of Zend_View, Zend_Db, etc. can do so

This page gives examples of the kind of the different adaptors available to Zend_Paginator.

For example, to create a paginator using an array (which could be a database result set) you can use the Array adapter:

$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($array));