Login   Register  
PHP Classes

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

  Author Author  
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: 704 in France France
Week rank: 371 Down16 in France France Down
Innovation award
Innovation award
Nominee: 4x

  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of Jonathan Gotti  >  HTML dbtree  >  Download Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: HTML dbtree
Base name: html_dbtree
Description: Manipulate hierarchical data stores in database
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 2962 users
All time rank: 1146
Week users: 0 users
Week rank: 1503 Equal
  Groups   Screenshots Screenshots   Rate classes User ratings  
  Dependencies   Applications   Related pages   Files Files  

Group folder image HTML HTML generation and processing View top rated classes
Group folder image Algorithms Numerical and statistical algorithms View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes

  Files folder image Screenshots  
File Role Description
Accessible without login Image file jscookmenusupport.png Screen show the jscookmenu integration

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (87%) Good (81%) Sufficient (75%) Sufficient (75%) - - Sufficient (66%) 377
Month: Not yet rated by the users

  Packages needed by this class  
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

  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related pages  
MPTT from aesthetic-theory.com
the place where i learn this theory

  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

Download Download all files: html_dbtree.tar.gz html_dbtree.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.