The dbx module is a database abstraction layer (db 'X', where 'X'
is a supported database). The dbx functions allow you to access
all supported databases using a single calling convention.
The dbx_functions themselves do not interface directly to the
databases, but interface to the modules that are used to support
This extension has been moved to the PECL repository and is no longer bundled with
PHP as of PHP 5.1.0.
To be able to use a database with the dbx_module, the module must be either
linked or loaded into PHP, and the database module must be supported by the
dbx_module. Currently, the following databases are supported, but others
Documentation for adding additional database support to dbx can be
found at http://www.guidance.nl/php/dbx/doc/.
In order to have these functions available, you must compile PHP with
dbx support by using the --enable_dbx
option and all options for the databases that will be used, e.g. for
MySQL you must also specify
To get other supported databases to work with the dbx_module refer to their
The behaviour of these functions is affected by settings in php.ini.
Table 1. DBX Configuration Options
|dbx.colnames_case||"unchanged"||PHP_INI_SYSTEM||Available since PHP 4.3.0.|
For further details and definitions of the
PHP_INI_* constants, see the Appendix G
Here's a short explanation of
the configuration directives.
Columns names can be returned "unchanged" or converted to
"uppercase" or "lowercase". This directive can be overridden
with a flag to dbx_query().
There are two resource types used in the dbx module. The first one is the
link-object for a database connection, the second a
result-object which holds the result of a query.
The constants below are defined by this extension, and
will only be available when the extension has either
been compiled into PHP or dynamically loaded at runtime.