Login   Register  
PHP Classes
elePHPant
Icontem

HTML dbtree: Manipulate hierarchical data stores in database

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (8 years ago) RSS 2.0 feedStarStarStarStar 66%Total: 2,967 This week: 1All time: 1,145 This week: 1,545Down
Version License Categories  
html_dbtree 1.0GNU General Public Lice...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: 38
All time rank: 694 in France France
Week rank: 317 Down18 in France France Down
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:2,967All time:1,145
 This week:1This week:1,545Down
User Ratings User Comments (1)  
 All time
Utility:87%StarStarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:75%StarStarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:66%StarStarStarStar
Rank:379
 
Excellent
5 years ago (kishore kumar)
80%StarStarStarStarStar