PEAR::DBA is a wrapper for the php DBA functions. It includes a file-based
emulator and provides a uniform, object-based interface for the
Berkeley-style database systems.
Table management extension to DBA
PEAR::DB_DataObject performs 2 tasks:
1. Builds SQL statements based on the objects vars and the builder methods.
2. acts as a datastore for a table row.
The core class is designed to be extended for each of your tables so that you
put the data logic inside the data classes.
included is a Generator to make your configuration files and your base classes.
DB_Pager retrieve and return information of database result sets.
This class handles all the stuff needed for displaying
paginated results from a database query of Pear DB.
including fetching only the needed rows and giving extensive information
for helping build an HTML or GTK query result display.
PEAR::DB_QueryTool is an OO-abstraction to the SQL-Query language, it provides
methods such as setWhere, setOrder, setGroup, setJoin, etc. to easily build
queries.
It also provides an easy to learn interface that interacts nicely with
HTML-forms using arrays that contain the column data, that shall be
updated/added in a DB. This package bases on an SQL-Builder which lets you
easily build SQL-Statements and execute them.
PEAR::DB_Table builds on PEAR DB to abstract datatypes and automate table
creation, data validation, insert, update, delete, and select; combines
these with PEAR::HTML_QuickForm to automatically generate input forms
that match the table column definitions.
PEAR::DB_ldap class provides a DB compliant interface to LDAP servers.
PEAR::DB_ldap class provides a DB compliant
interface to LDAP v2 and v3 database.
PEAR MDB is a merge of the PEAR DB and Metabase php database abstraction layers.
It provides a common API for all support RDBMS. The main difference to most
other DB abstraction packages is that MDB goes much further to ensure
portability.
Currently supported RDBMS are MySQL, PostGreSQL, Oracle, Frontbase, Querysim,
Interbase/Firebird, and MSSQL
PEAR MDB2 is a merge of the PEAR DB and Metabase php database abstraction
layers.
It provides a common API for all supported RDBMS. The main difference to
most other DB abstraction packages is that MDB2 goes much further to
ensure portability. MDB2 provides most of its many features optionally
that can be used to construct portable SQL statements.