PHP Classes

HTML dbtree: Manipulate hierarchical data stores in database

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2006-03-08 (13 years ago) RSS 2.0 feedStarStarStarStar 67%Total: 3,030 All time: 1,191 This week: 556Up
Version License Categories
html_dbtree 1.0.0GNU General Publi...HTML, Algorithms, Databases
Description Author

This class implements an efficient method to manipulate hierarchical data stored in SQL databases tables by using preordered tree records.

It is a more efficient method to add, remove and retrieve data that form trees of records, than using the traditional recursive way to manage trees using only a field parent that is really mich more resource consuming as it may require the execution of many database queries. This class uses

This class lets you retrieve a complete tree structure from your database table with a single query. Only tree changes require more than one query.

This class can also use the tree record retrieval functions to generate HTML select input fields that present an hierarchy of options.

Currently, it requires the use mysqldb or sqlitedb class also available in this site, bit it could be easily adapted to use other database access classes.

Name: Jonathan Gotti is available for providing paid consulting. Contact Jonathan Gotti .
Classes: 13 packages by
Country: France France
Age: 42
All time rank: 714 in France France
Week rank: 305 Down12 in France France Down
Innovation award
Innovation award
Nominee: 4x

  • jscookmenusupport.png
  Files folder image Files  
File Role Description
Plain text file class-htmldbtree.php Class file to include in your script
HTML file htmldbtree_doc-2005-04-24.html Doc. doc
Plain text file sample.php Example example file
Plain text file sample.sql Example SQL create table sample 29KB
Downloadhtml_dbtree-2006-03-08.tar.gz 30KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
class mysql Download .zip .tar.gz use to manage database connection Required
class sqlite Download .zip .tar.gz use instead of class mysql to work on a sqlite database Conditional
 Version Control Unique User Downloads Download Rankings  
This week:0
All time:1,191
This week:556Up
User Ratings User Comments (1)
 All time
9 years ago (kishore kumar)