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    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 63%Total: 3,044 All time: 1,202 This week: 488Up
Version License Categories
html_dbtree 1.0.0GNU General Publi...HTML, Algorithms, Databases


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.

Picture of Jonathan Gotti
Name: Jonathan Gotti is available for providing paid consulting. Contact Jonathan Gotti .
Classes: 13 packages by
Country: France France
Age: 47
All time rank: 724 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 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,202
This week:488Up
User Ratings User Comments (1)
 All time
14 years ago (kishore kumar)