PEAR  
Search package by name
 

Package Management
Package Management

 

Package Search
Package Search

 

Channel Management
Channel Management

 

Configuration
Configuration

 
Warning: This package management website is not protected with a password, this is a MAJOR security risk. Please read the README.
Package DB_Table
Installed - no -
Latest 1.5.6
License New BSD
Summary An object oriented interface to, and model of, a database. Integrates with HTML_QuickForm.
Description The DB_Table package provides an object oriented interface to a database.

Each instance of the core DB_Table class contains the schema for a table, defined using abstract data types. The class provides a portable api for insert, update, delete, and select SQL commands, and can validate data types upon insertion and updating. It provides methods to automatically create or verify a database table. DB_Table also provides methods (using PEAR HTML_QuickForm) to generate input forms that match the column definitions.

Each instance of the DB_Table_Database class contains a model of relationships between tables in a database, in which each table is represented by an instance of DB_Table. DB_Table_Database provides a method for automatic construction of join conditions for inner joins involving any number of tables, optional php validation of foreign key validity, and optional php emulation of actions triggered on delete or update of referenced rows, such as cascading deletes.

The DB_Table_Generator class auto-generates the php code necessary to create an interface to an existing database.
Dependencies
PHP Version: 4.3.0 or newer
PEAR Package: pear.php.net/PEAR 1.5.0 or newer
PEAR Package: pear.php.net/HTML_QuickForm
PEAR Package: pear.php.net/DB 1.7.11 or newer1
PEAR Package: pear.php.net/MDB2 2.4.1 or newer1
Options
install Install package
More extra info Extended Package Information
manual pear.php.net Developer Documentation
manual pear.php.net Package Manual