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

  Author Author  
Picture of Khaled Al-Shamaa
Name: Khaled Al-Shamaa <e-mail contact>
Packages: 22 Browse all classes by Khaled Al-Shamaa Browse all classes by
Country: Syria Syria - PHP jobs in Syria
Age: 38
All time rank: 611 in Syria Syria
Week rank: 38 Up1 in Syria Syria Equal
Innovation award
Innovation award
Nominee: 10x

Winner: 4x


  Detailed description   Download Download .zip .tar.gz  
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

  Classes of Khaled Al-Shamaa  >  Celko Visitation Model  >  Download Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Celko Visitation Model
Base name: visitation
Description: Manipulate hierarchic records in a MySQL database
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 1835 users
All time rank: 1976
Week users: 1 user
Week rank: 1808 Up
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Algorithms Numerical and statistical algorithms View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (91.7%) Good (83.3%) Sufficient (66.7%) Sufficient (75.0%) - - Sufficient (68.3%) 299
Month: Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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  /  Files folder image docs  
File Role Description
Files folder imagemedia (18 files)
  Accessible without login HTML file index.html Doc. Documentation

  Files  /  docs  /  Files folder image 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

Download Download all files: visitation.tar.gz visitation.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.