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.