News Feed
Sections




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

Zend Developer Zone:
NestedSetDbTable class
March 01, 2010 @ 09:14:20

On the Zend Developer Zone today there's a new tutorial looking at a database class/component that implements the Nested Set idea for the Zend Framework - NestedSetDbTable.

There are several ways of realizing demand of storing hierarchical data in database, and most popular methods today are Adjacency List and Nested Set models. [...] With Nested Set model [the] whole tree can be retrieved with a single query, but there are lot of things that need to be done when you need to make some changes in hierarchy. From the title of this article, it's obvious which model is my favorite.

The class helps you to manage nested sets of data pulled from a database and extends the Zend_Db_Table component to pull in all of its additional functionality. You define the "left" and "right" columns in the table and can use constants like NEXT_SIBLING and LAST_CHILD to perform inserts and updates without having to worry about a record's place in the set. Code snippets are included to show you how it all works together.

0 comments voice your opinion now!
nestedsetdbtable zendframework class nestedset


blog comments powered by Disqus

Similar Posts

Zend Developer Zone: NestedSetDbTable class

Raphael Stolt's Blog: Using the Zend Framework plugins for server-sided Ajax request identification

Rob Allen's Blog: Simplified Chinese Version of my Zend Auth Tutorial

Daniel Cousineau's Blog: Quickie: Module-specific Error Controllers in Zend Framework (1.5)

Voices of the ElePHPant: Interview with Matthew Weier O'Phinney


Community Events

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


api community series interview conference framework voicesoftheelephpant release podcast library version extension performance application example php7 symfony2 opinion laravel introduction

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