PHP Classes

HTML dbtree: Manipulate hierarchical data stores in database

Recommend this page to a friend!
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 63%Total: 3,044 All time: 1,202 This week: 42Up
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.

Picture of Jonathan Gotti
Name: Jonathan Gotti is available for providing paid consulting. Contact Jonathan Gotti .
Classes: 13 packages by
Country: France France
Age: 48
All time rank: 724 in France France
Week rank: 63 Up5 in France France Down
Innovation award
Innovation award
Nominee: 4x

Screenshots (1)  
  • jscookmenusupport.png
  Files folder image Files (5)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadhtml_dbtree-2006-03-08.zip 30KB
Downloadhtml_dbtree-2006-03-08.tar.gz
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  
 0%
Total:3,044
This week:0
All time:1,202
This week:42Up
User Ratings User Comments (1)
 All time
Utility:82%StarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:75%StarStarStarStar
Examples:71%StarStarStarStar
Tests:-
Videos:-
Overall:63%StarStarStarStar
Rank:843
 
Excellent
15 years ago (kishore kumar)
80%StarStarStarStarStar