News Feed
Sections




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

Ralph Schindler's Blog:
Composite Rowsets For Many-To-Many Relationships Via Zend_Db_Table
November 16, 2010 @ 11:08:24

Ralph Schindler has posted a handy tutorial (along with some helpful code) to his blog today about handling many-to-many composite rowset relationships with the Zend_Db component of the Zend Framework.

One of the hardest problems to solve when developing an ORM of any complexity is in deciding how to handle the retrieval of rows that satisfy a many-to-many relationship, also known as a M:N relationship. [...] To model M:N relationships, database developers must get creative. By employing the use of a "3rd party", and by utilizing foreign keys that model a 1:N relationship, database developers can model a M:N relationship.

He looks at the Zend_Db_Table_Row class of the framework and how it works with these junction tables and how it has an issue where it returns the junction table columns too. A fix was released (in 1.10.2) for the framework to work correctly. Unfortunately, this also left those using the method out in the cold. So, Ralph has created his own workaround called a composite rowset. He includes an example snippet to give you an idea of how it works, but you can download the code from his github repository for a closer look.

0 comments voice your opinion now!
composite rowset zendframework zenddbtable manytomany database


blog comments powered by Disqus

Similar Posts

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

Daniel Krook's Blog: CakePHP DB2 driver alpha released

Zend Developer Zone: PHP: Performance, Scalability, and Web Services Podcast

Matt Butche's Blog: MongoDB: 5 Things Every PHP Developer Should Know About MongoDB

Michelangelo van Dam's Blog: Unit testing after Zend Framework 1.8 webinar


Community Events

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


voicesoftheelephpant opinion library series laravel community api podcast release framework interview extension threedevsandamaybe language symfony introduction laravel5 version unittest security

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