News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Anis Ahmad's Blog:
Join Problems with Zend_Paginator and Zend_Db_Select objects
August 28, 2008 @ 11:18:55

Anis Ahmad had a problem. The Zend_Paginator component of the Zend Framework, while powerful, wasn't quite working right. Bugs popped up when he used a join along with a Zend_Db_Select.

One of the 4 Adapters for Zend_Paginator is DbSelect which uses a Zend_Db_Select instance. Now, the problem occurred if I need to have some calculative data from other tables and use join with the Zend_Db_Select object for them.

He gives an example of a join that he performed with the component, the details of the "behind the scenes" code and why it happened that way. He also offers a solution (before the Zend_Pagination component was patched for it, of course) of changing the count() method it uses slightly to remove an unneeded part of the query.

0 comments voice your opinion now!
zendpaginator zenddbselect component zendframework


blog comments powered by Disqus

Similar Posts

Padraic Brady's Blog: Another OAuth Library Is Born (Zend_OAuth Proposal)

The Bakery: Five More Articles/Tutorials Posted

Rob Allen's Blog: An introduction to Zend\EventManager

Matthew Turland's Blog: The Configuration Pattern in Zend Framework

Gonzalo Ayuso: Combining Zend Framework2 and Symfony2 components with Composer to build PHP projects


Community Events











Don't see your event here?
Let us know!


podcast security introduction symfony2 framework hack install composer language package unittest series opinion release component facebook application hhvm database performance

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework