Login   Register  
PHP Classes
elePHPant
Icontem

Closure Table: Manage transitive closure tables stored in MySQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Tom Schaefer
Name: Tom Schaefer is available for providing paid consulting. Contact Tom Schaefer .
Classes: 39 packages by
Country: Germany Germany
Age: ???
All time rank: 1109 in Germany Germany
Week rank: 73 Up5 in Germany Germany Up
Innovation award
Innovation award
Nominee: 9x

Winner: 1x


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

  Classes of Tom Schaefer  >  Closure Table  >  Download Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Closure Table
Base name: closuretable
Description: Manage transitive closure tables stored in MySQL
Version: 0.1
PHP version: 5.0
License: The PHP License
All time users: 750 users
All time rank: 4077
Week users: 1 user
Week rank: 1419 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings  
  Applications   Related pages   Files Files  

  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

  Files folder image Screenshots  
sample.png
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


Prize: One book of choice by Manning
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  
Not enough user ratings

  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  
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)
Accessible without login Plain text file index.php Aux. load classes
Accessible without login Plain text file Readme.txt Doc. Readme
Accessible without login Plain text file sample.sql Data sample db layout

  Files folder image Files  /  img  
File Role Description
  Accessible without login Image file node_delete.png Icon delete
  Accessible without login Image file node_delete_tree.png Icon delete tree
  Accessible without login Image file node_delete_tree_gray.png Icon delete tree unselect
  Accessible without login Image file node_move_down.png Icon move down
  Accessible without login Image file node_move_down_gray.png Icon move down unselect
  Accessible without login Image file node_move_left.png Icon move left
  Accessible without login Image file node_move_left_gray.png Icon move left unselect
  Accessible without login Image file node_move_right.png Icon move right
  Accessible without login Image file node_move_right_unselect.png Icon move right unselect
  Accessible without login Image file node_move_up.png Icon move up
  Accessible without login Image file node_move_up_gray.png Icon move up unselect

  Files folder image Files  /  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
  Accessible without login Plain text file index.php Aux. autoloader

  Files folder image Files  /  Tool  
File Role Description
Files folder imageClosureTable (2 files)
Files folder imageView (3 files)
  Accessible without login Plain text file index.php Aux. autoloader

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

  Files folder image Files  /  Tool  /  View  
File Role Description
  Plain text file Href.php Class View Link Href Builder
  Accessible without login Plain text file index.php Aux. autoloader
  Plain text file Link.php Class View Link Builder

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

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

Download 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.