Class: Celko Visitation Model (tree)

Supplied by:

Name:	Khaled Al-Shamaa `<e-mail contact>`
Published packages:	21
Country:	Syria - PHP jobs in Syria
Home page:	`http://www.ar-php.com/`
Age:	32
All time rank:	147
Week rank:	44

Browse this author's classes

Groups:

	Algorithms	Numerical and statistical algorithms	View top rated classes
	Databases	Database management, accessing and searching	View top rated classes

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

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%)`	194
Month:	Not yet rated by the users

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
`visitation.class.php`	Class	Class file
`example.php`	Example	Example script
`example.sql`	Example	Example database
`docs`
`index.html`	Doc.	Documentation
`docs/media`
`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

NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

Class: Celko Visitation Model

Supplied by:

Groups:

Detailed description:

User ratings:

Applications that use this class:

Files: