Login   Register  
PHP Classes
elePHPant
Icontem

Joe Celko Nested Sets: Manage tree database structure with Celko approach

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2004-02-05 (10 years ago) RSS 2.0 feedStarStarStar 43%Total: 3,426 This week: 1All time: 935 This week: 1,398Down
Version License Categories  
celkonestedset 1.0GNU General Public Lice...Algorithms, Databases, Data types
Description Author  

This class is meant to manage tree database structure using Jeo Celko's nested sets approach.

You can add node with 7 queries, delete a node with subnodes with 4 queries and move node with 11 queries.

The number of queries per action does not depend on the number of sub-nodes, so it is a scalable solution.

Picture of Setec Astronomy
Name: Setec Astronomy <contact>
Classes: 20 packages by
Country: Italy Italy
Age: ???
All time rank: 141 in Italy Italy
Week rank: 42 Down3 in Italy Italy Down
Innovation award
Innovation award
Nominee: 5x

  Files folder image Files  
File Role Description
Accessible without login Plain text file ccelko.php Class CCelkoNastedSet class file
Accessible without login Plain text file sample.php Example Sample file for CCelkoNastedSet class

 Version Control Unique User Downloads Download Rankings  
 0%Total:3,426All time:935
 This week:1This week:1,398Down
 User Ratings  
 
 All time
Utility:64%StarStarStarStar
Consistency:67%StarStarStarStar
Documentation:-
Examples:42%StarStarStar
Tests:-
Videos:-
Overall:43%StarStarStar
Rank:2046