PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
     
  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 (13 years ago) RSS 2.0 feedStarStarStar 47%Total: 3,474 This week: 1All time: 953 This week: 559Up
Version License Categories
celkonestedset 1.0GNU General Publi...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.
Name: Filippo Toso <contact>
Classes: 20 packages by
Country: Italy Italy
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

Downloadcelkonestedset-2004-02-05.zip 4KB
Downloadcelkonestedset-2004-02-05.tar.gz 3KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,474
This week:1
All time:953
This week:559Up
 User Ratings  
 
 All time
Utility:69%StarStarStarStar
Consistency:75%StarStarStarStar
Documentation:-
Examples:52%StarStarStar
Tests:-
Videos:-
Overall:47%StarStarStar
Rank:2434
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
Help! My Hierarchy is Slow - Faster Hierarchies with Nested Sets
A great many applications, including many that I’ve worked on, have a hierarchy of things: of parts, of people, of organizations, etc...
Nested Sets
Once again faced with a situation where this simple algorithm is vital and again confronted with the fact that on the Internet nothing is working under PHP...
Nested Sets
Once again faced with a situation when the algorithm is simply vital and again confronted with the fact that the proposed network is nothing working under PHP..

Latest pages that reference packages Latest pages that reference packages