Login   Register  
PHP Classes
elePHPant
Icontem

Class: HTML dbtree

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of jonathan gotti  >  HTML dbtree  >  Download .tar.gz .zip  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: HTML dbtree
Support forum Support forum
Base name: html_dbtree
Description: Manipulate hierarchical data stores in database
Related classes: , , , , , , ,
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 2735 users
All time rank: 1122
Week users: 1 user
Week rank: 2467
Picture of jonathan gotti
Author: jonathan gotti is available for providing paid consulting. Contact jonathan gotti .
Packages: 13 Browse this author's classes Browse this author's classes
Country: France France - PHP jobs in France
Age: 35
All time rank: 664 in France France
Week rank: 90 Down2 in France France Up
Innovation award
Innovation award
Nominee: 4x


  Detailed description  
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.

 

  Groups  
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

  Screenshots Screenshots   Rate classes User ratings   Dependencies  
  Applications   Related links   Files Files  
  Files folder image Screenshots  
show the jscookmenu integration
File Role Description
Accessible without login Image file jscookmenusupport.png Screen show the jscookmenu integration


  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (87.5%)
Good (81.2%)
Sufficient (75.0%)
Sufficient (75.0%)
-
-
Sufficient (66.9%)
341
Month:
Not yet rated by the users

  Packages needed by this class  
Class Dependency Why it is needed
class mysql
Required
 use to manage database connection
class sqlite
Conditional
 use instead of class mysql to work on a sqlite database

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

  Related links  
Link Description
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 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.