Closure Table
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Author | ||
 |
|
Innovation award Nominee: 9x Winner: 1x | |||||||||||||||||||
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.
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 .zip .tar.gz | > |  Support forum (3) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||
| Groups |  Screenshots |
 User ratings |
||||
| Applications | Related links |  Files |
||||
| Groups | ||
 |
PHP 5 | Classes using PHP 5 specific features | View top rated classes |
|
Databases | Database management, accessing and searching | View top rated classes |
|
Data types | Modeling and manipulating data types | View top rated classes |
| Innovation Award | ||
 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 | ||
| There are not enough user ratings to display for this class. |
| Applications that use this class | ||
No application links were specified for this class.
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 | ||
|---|---|---|---|---|
| img (11 files) |
||||
| Db (10 files) |
||||
| Tool (1 file, 2 directories) |
||||
| samples (1 file, 1 directory) |
||||
 index.php |
Aux. | load classes | ||
| Readme.txt |
Doc. | Readme | ||
| sample.sql |
Data | sample db layout | ||
| Files | / | img |
||
| File | Role | Description |
|---|---|---|
| node_delete.png |
Icon | delete |
| node_delete_tree.png |
Icon | delete tree |
| node_delete_tree_gray.png |
Icon | delete tree unselect |
| node_move_down.png |
Icon | move down |
| node_move_down_gray.png |
Icon | move down unselect |
| node_move_left.png |
Icon | move left |
| node_move_left_gray.png |
Icon | move left unselect |
| node_move_right.png |
Icon | move right |
| node_move_right_unselect.png |
Icon | move right unselect |
| node_move_up.png |
Icon | move up |
| node_move_up_gray.png |
Icon | move up unselect |
| Files | / | Db |
||
| File | Role | Description |
|---|---|---|
| ClosureTable.php |
Class | Closure Table Wrapper |
| ClosureTableBase.php |
Class | Closure Table Base |
| ClosureTableCreate.php |
Class | Create Table Class |
| ClosureTableDelete.php |
Class | Closure Table Delete |
| ClosureTableInsert.php |
Class | Closure Table Insert |
| ClosureTableInterface.php |
Class | interface for db class |
| ClosureTableRetrieve.php |
Class | Closure Retrieve Data |
| ClosureTableSort.php |
Class | Various Tree Sort Operations |
| Db.php |
Class | Sample Db Adapter - very basic |
| index.php |
Aux. | autoloader |
| Files | / | Tool | / | ClosureTable |
||
| File | Role | Description |
|---|---|---|
| index.php |
Aux. | autoloader |
| TreeAdmin.php |
Class | Demo Helper Tool for visualizing a ul-tree |
| Files | / | samples | / | ClosureTable |
||
| File | Role | Description |
|---|---|---|
| config.inc.php |
Conf. | config sample |
| index.php |
Example | sample |
| server.php |
Example | sample |
| Download all files: closuretable.tar.gz closuretable.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2013