Login   Register  
PHP Classes
elePHPant
Icontem

Class: Closure Table

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tom Schaefer  >  Closure Table  >  Download .tar.gz .zip  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Closure Table
Support forum Support forum
Base name: closuretable
Description: Manage transitive closure tables stored in MySQL
Related classes: , , , , , , ,
Version: 0.1
PHP version: 5.0
License: The PHP License
All time users: 511 users
All time rank: 4464
Week users: 1 user
Week rank: 2467
Picture of Tom Schaefer
Author: Tom Schaefer <e-mail contact>
Packages: 27 Browse this author's classes Browse this author's classes
Country: Germany Germany - PHP jobs in Germany
Age: ???
All time rank: 15810 in Germany Germany
Week rank: 123 Up4 in Germany Germany Up
Innovation award
Innovation award
Nominee: 4x


  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.

 

  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

  Screenshots Screenshots   Rate classes User ratings   Applications   Related links   Files Files  
  Files folder image Screenshots  
sample tree view
File Role Description
Accessible without login Image file sample.png Screen sample tree view


  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

  User ratings  
There are not enough user ratings to display for this class.

  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 folder image Files  
File Role Description
Files folder imageimg (11 files)
Files folder imageDb (10 files)
Files folder imageTool (1 file, 2 directories)
Files folder imagesamples (1 file, 1 directory)
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  /  Files folder image img  
File Role Description
  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  /  Files folder image Db  
File Role Description
  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  /  Files folder image Tool  
File Role Description
Files folder imageClosureTable (2 files)
Files folder imageView (3 files)
  Plain text file index.php Aux. autoloader

  Files  /  Tool  /  Files folder image ClosureTable  
File Role Description
  Plain text file index.php Aux. autoloader
  Plain text file TreeAdmin.php Class Demo Helper Tool for visualizing a ul-tree

  Files  /  Tool  /  Files folder image View  
File Role Description
  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

  Files  /  Files folder image samples  
File Role Description
Files folder imageClosureTable (3 files)
  Plain text file config.inc.php Conf. main config

  Files  /  samples  /  Files folder image ClosureTable  
File Role Description
  Plain text file config.inc.php Conf. config sample
  Plain text file index.php Example sample
  Plain text file server.php Example sample

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.