Login   Register  
PHP Classes
elePHPant
Icontem

Celko Visitation Model: Manipulate hierarchic records in a MySQL database

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 (22)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-05-17 (8 years ago) RSS 2.0 feedStarStarStarStar 68%Total: 1,848 All time: 1,987 This week: 1,523Up
Version License Categories  
visitation 1.0GNU General Public Lice...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
Name: Khaled Al-Shamaa <contact>
Classes: 22 packages by
Country: Syria Syria
Age: 39
All time rank: 591 in Syria Syria
Week rank: 50 Up1 in Syria Syria 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,848All time:1,987
 This week:0This week:1,523Up
 User Ratings  
 
 All time
Utility:91%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:66%StarStarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:68%StarStarStarStar
Rank:309