PHP Classes
elePHPant
Icontem

Celko Visitation Model: Manipulate hierarchic records in a MySQL database

Recommend this page to a friend!
  Info   View files View files (22)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2006-05-17 (10 years ago) RSS 2.0 feedStarStarStarStar 71%Total: 1,888 All time: 2,025 This week: 1,016Up
Version License Categories
visitation 1.0GNU General Publi...Algorithms, Databases
Description Author

This class can be use to manipulate hierarchic trees of records stored in a MySQL database using Joe Celko visitation model.

It can perform the following tasks in a very effecient way mostly using one SELECT query statement:

- Find out leaf nodes in the current tree (nodes have no children)
- Find out nodes of a sub-tree for given node
- Find out the context path of given node
- Find out the level or depth of a given node
- Find out how many descendants a given node has

Picture of Khaled Al-Shamaa
  Performance   Level  
Innovation award
Innovation award
Nominee: 10x

Winner: 4x

  Files folder image Files  
File Role Description
Files folder imagedocs (1 file, 1 directory)
Plain text file visitation.class.php Class Class file
Accessible without login Plain text file example.php Example Example script
Accessible without login Plain text file example.sql Example Example database

 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,888
This week:0
All time:2,025
This week:1,016Up
 User Ratings  
 
 All time
Utility:93%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:75%StarStarStarStar
Examples:81%StarStarStarStarStar
Tests:-
Videos:-
Overall:71%StarStarStarStar
Rank:259