PHP Classes
Icontem

Class: Closure Table


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tom Schaefer  >  Closure Table  >  Download  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Closure Table Support forum
Base name: closuretable
Description: Manage transitive closure tables stored in MySQL
Related top rated classes: , , ,
Version: 0.1
Required PHP version: 5.0
License: The PHP License
All time users: 218 users
All time rank: 4654
Week users: 7 users
Week rank: 1094
 
  Screenshots Screenshots   Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Related links   Files Files  

Screenshots

sample tree view
File Role Description
Accessible without login Image file sample.png Screen sample tree view

Author

Picture of Tom Schaefer
Name: Tom Schaefer <e-mail contact>
Published packages: 24 Browse this author's classes Browse this author's classes
Country: Germany Germany - PHP jobs in Germany
Home page: http://www.query4u.de/tests/samples/
Age: ???
All time rank: 254
Week rank: 48

Innovation Award

PHP Programming Innovation award nominee
July 2009
Number 8
 Databases are often used to store records of information that are related in ways that form hierarchic trees and other types of graphs.

There are solutions to manipulate sets records that form these types of graph, like the Joe Celko's nested sets.

However, such solutions require that you have additional fields in the records to store information about the graph structures.

Using closure tables is a different approach that consists in using separate tables to store graph structural information.

This class implements an API that manages closure tables in PHP. It can be used to manage graphs of records of information created by existing PHP applications without changing the code that manages the application table records.

Manuel Lemos

Groups

Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Data types Modeling and manipulating data types View top rated classes

Detailed description

This package can be used to manage transitive closure tables (TCT) stored in a MySQL database.

It can create MySQL database tables that will store information about hierarchies of nodes stored in other database tables.

Different classes can organize nodes hierarchically by weight and depth. They can insert, delete, retrieve and sort nodes.

User ratings

Not yet rated by the users

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
Closure Table by Bill Karwin A good starting point for getting basic knowledge
A bit deeper Vadim Tropashko explains it
Transitive Closure This article is about the transitive closure of a binary relation.
Transitive Closures Another hook to get info about it

Files

File Role Description
Files folder image img
  Image file node_delete.png Icon delete
  Image file node_delete_tree.png Icon delete tree
  Image file node_delete_tree_gray.png Icon delete tree unselect
  Image file node_move_down.png Icon move down
  Image file node_move_down_gray.png Icon move down unselect
  Image file node_move_left.png Icon move left
  Image file node_move_left_gray.png Icon move left unselect
  Image file node_move_right.png Icon move right
  Image file node_move_right_unselect.png Icon move right unselect
  Image file node_move_up.png Icon move up
  Image file node_move_up_gray.png Icon move up unselect
Files folder image Db
  Plain text file ClosureTable.php Class Closure Table Wrapper
  Plain text file ClosureTableBase.php Class Closure Table Base
  Plain text file ClosureTableCreate.php Class Create Table Class
  Plain text file ClosureTableDelete.php Class Closure Table Delete
  Plain text file ClosureTableInsert.php Class Closure Table Insert
  Plain text file ClosureTableInterface.php Class interface for db class
  Plain text file ClosureTableRetrieve.php Class Closure Retrieve Data
  Plain text file ClosureTableSort.php Class Various Tree Sort Operations
  Plain text file Db.php Class Sample Db Adapter - very basic
  Plain text file index.php Aux. autoloader
Files folder image Tool/ClosureTable
  Plain text file index.php Aux. autoloader
  Plain text file TreeAdmin.php Class Demo Helper Tool for visualizing a ul-tree
Files folder image Tool
  Plain text file index.php Aux. autoloader
Files folder image Tool/View
  Plain text file Href.php Class View Link Href Builder
  Plain text file index.php Aux. autoloader
  Plain text file Link.php Class View Link Builder
Plain text file index.php Aux. load classes
Plain text file Readme.txt Doc. Readme
Plain text file sample.sql Data sample db layout
Files folder image samples/ClosureTable
  Plain text file config.inc.php Conf. config sample
  Plain text file index.php Example sample
  Plain text file server.php Example sample
Files folder image samples
  Plain text file config.inc.php Conf. main config
Download all files: closuretable.tar.gz closuretable.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products