Celko Visitation Model: Manipulate hierarchic records in a MySQL database

Recommend this page to a friend!
  Info   View files (22)   Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
71%Total: 1,916 All time: 2,038 This week: 298
Version License Categories
visitation 1.0.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  
Name: Khaled Al-Shamaa <contact>
Classes: 22 packages by
Country: Syria Syria
Age: 45
All time rank: 491 in Syria Syria
Week rank: 261 1 in Syria Syria
Innovation award
Innovation award
Nominee: 10x

Winner: 4x

File Role Description
docs (1 file, 1 directory)
visitation.class.php Class Class file
example.php Example Example script
example.sql Example Example database

  Files  /  docs  
File Role Description
media (18 files)
   index.html Doc. Documentation

  Files  /  docs  /  media  
File Role Description
   background.png Photo Image
   Diagram1.GIF Photo Image
   empty.png Photo Image
   gnu.png Photo Image
   hierarchical-data-1.png Icon Image
   hierarchical-data-2.png Icon Image
   hierarchical-data-3.png Icon Image
   hierarchical-data-4.png Icon Image
   hierarchical-data-5.png Icon Image
   mhillyer.jpg Icon Image
   mysql.gif Photo Image
   mysql_100x52-64.gif Icon Image
   nosoftwarepatents.gif Photo Image
   php.png Photo Image
   style.css Doc. CSS
   w3c_linkcheck.png Photo Image
   w3c_validcssb.png Photo Image
   xhtml10.png Photo Image

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:2,038
This week:298
 User Ratings  
 All time

For more information send a message to info at phpclasses dot org.