Javascript debugger
Website design
↑
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 these databases.
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 will follow:
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
--with-mysql=[DIR]
.
To get other supported databases to work with the dbx-module refer to their
specific documentation.
The behaviour of these functions is affected by settings in php.ini
.
Name | Default | Changeable | Changelog |
---|---|---|---|
dbx.colnames_case | "unchanged" | PHP_INI_SYSTEM | Available since PHP 4.3.0. Removed in PHP 5.1.0. |
For further details and definitions of the
PHP_INI_* constants, see the Appendix I, php.ini
directives.
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.
DBX_MYSQL
(integer)
DBX_ODBC
(integer)
DBX_PGSQL
(integer)
DBX_MSSQL
(integer)
DBX_FBSQL
(integer)
DBX_OCI8
(integer) (available from PHP 4.3.0)
DBX_SYBASECT
(integer)
DBX_SQLITE
(integer) (PHP 5)
DBX_PERSISTENT
(integer)
DBX_RESULT_INFO
(integer)
DBX_RESULT_INDEX
(integer)
DBX_RESULT_ASSOC
(integer)
DBX_RESULT_UNBUFFERED
(integer) (PHP 5)
DBX_COLNAMES_UNCHANGED
(integer) (available from PHP 4.3.0)
DBX_COLNAMES_UPPERCASE
(integer) (available from PHP 4.3.0)
DBX_COLNAMES_LOWERCASE
(integer) (available from PHP 4.3.0)
DBX_CMP_NATIVE
(integer)
DBX_CMP_TEXT
(integer)
DBX_CMP_NUMBER
(integer)
DBX_CMP_ASC
(integer)
DBX_CMP_DESC
(integer)
Table of Contents
DBX_RESULT_UNBUFFERED
flag set