Introduction
Introduction – A feature overview
MDB2 Description
PEAR MDB2 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 database abstraction packages is that MDB2 goes much further
to ensure portability. Among other things MDB2 features:
-
An OO-style query API
-
A DSN (data source name) or array format for
specifying database servers
-
Datatype abstraction and on demand datatype conversion
-
Portable error codes
-
Sequential and non sequential row fetching as well as bulk fetching
-
Ability to make buffered and unbuffered queries
-
Ordered array and associative array for the fetched rows
-
Prepare/execute (bind) emulation
-
Sequence emulation
-
Replace emulation
-
Limited Subselect emulation
-
Row limit support
-
Transactions support
-
Large Object support
-
Index/Unique support
-
Module Framework to load advanced functionality on demand
-
Table information interface
-
RDBMS management methods (creating, dropping, altering)
-
Full integration into the PEAR Framework
-
PHPDoc API documentation
Currently supported RDBMS:
-
MySQL
-
MySQLi (PHP5 only)
-
PostgreSQL
-
Oracle
-
Frontbase (unmaintained)
-
Querysim
-
Interbase/Firebird (PHP5 only)
-
MSSQL
-
SQLite
Installation
When you install PEAR MDB2, you only get the base classes,
but you also need to install the driver of the appropriate DBMS to have a
working installation. For instance, to install the MySQL and the PostgreSQL drivers,
you have to run these commands:
$ pear install MDB2
$ pear install MDB2#mysql
$ pear install MDB2#pgsql
Still having problems? Check the F.A.Q.
External support resources