Celko Visitation Model
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
Innovation award Nominee: 10x Winner: 4x | |||||||||||||||||||
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
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 .zip .tar.gz | > |  Support forum (1) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups |  User ratings |
Applications |  Files |
|||||
| Groups | ||
 |
Algorithms | Numerical and statistical algorithms | View top rated classes |
|
Databases | Database management, accessing and searching | View top rated classes |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Files |
||
| 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 | / | 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 |
| Download all files: visitation.tar.gz visitation.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013