PHP Classes

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    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 71%Total: 1,925 All time: 2,048 This week: 136Up
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: Egypt Egypt
Age: 48
All time rank: 481 in Egypt Egypt
Week rank: 45 Up1 in Egypt Egypt Equal
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

  Files folder image Files  /  docs  
File Role Description
Files folder imagemedia (18 files)
  Accessible without login HTML file index.html Doc. Documentation

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

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