PHP Classes
elePHPant
Icontem

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 (10 years ago) RSS 2.0 feedStarStarStarStar 69%Total: 3,006 All time: 1,177 This week: 1,006Up
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 <contact>
Classes: 13 packages by
Country: France France
Innovation award
Innovation award
Nominee: 4x

Screenshots  
  • 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

Downloadhtml_dbtree-2006-03-08.zip 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  
 0%
Total:3,006
This week:0
All time:1,177
This week:1,006Up
User Ratings User Comments (1)
 All time
Utility:90%StarStarStarStarStar
Consistency:85%StarStarStarStarStar
Documentation:80%StarStarStarStarStar
Examples:80%StarStarStarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:366
 
Excellent
7 years ago (kishore kumar)
80%StarStarStarStarStar