Login   Register  
PHP Classes
elePHPant
Icontem

Class: Celko Visitation Model

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Khaled Al-Shamaa  >  Celko Visitation Model  >  Download .tar.gz .zip  >  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
Related classes: , , , ,
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 1751 users
All time rank: 1865
Week users: 0 users
Week rank: 2526
Picture of Khaled Al-Shamaa
Author: Khaled Al-Shamaa <e-mail contact>
Packages: 21 Browse this author's classes Browse this author's classes
Country: Syria Syria - PHP jobs in Syria
Age: 36
All time rank: 741 in Syria Syria
Week rank: 751 in Syria Syria
Innovation award
Innovation award
Nominee: 10x

Winner: 4x


  Detailed description  
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

 

  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

  Rate classes User ratings   Applications   Files Files  

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (91.7%)
Good (83.3%)
Sufficient (66.7%)
Sufficient (75.0%)
-
-
Sufficient (68.3%)
269
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
Plain text file example.php Example Example script
Plain text file example.sql Example Example database

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

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

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.