XX_ dbx functions

Introducción

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_

Requerimientos

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:

FrontBase (available from PHP 4_1_0)_
Microsoft SQL Server
MySQL
ODBC
PostgreSQL
Sybase_CT (available from PHP 4_2_0)_
Oracle (oci8) (available from PHP 4_3_0)_
SQLite (cvs only)_

Documentation for adding additional database support to dbx can be found at http://www_guidance_nl/php/dbx/doc/_

Instalación

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_

Configuración en tiempo de ejecución

El comportamiento de estas funciones está afectado por los valores definidos en php_ini_

Tabla 1_ DBX Configuration Options

Name	Default	Changeable
dbx_colnames_case	"unchanged"	PHP_INI_SYSTEM

For further details and definition of the PHP_INI_* constants see ini_set()_

Nota: This ini_option is available available from PHP 4_3_0_

A continuación se presenta una corta explicación de las directivas de configuración

dbx_colnames_case string: Columns names can be returned "unchanged" or converted to "uppercase" or "lowercase"_ This directive can be overridden with a flag to dbx_query()_

Tipos de recursos

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_

Constantes predefinidas

Estas constantes están definidas por esta extensión y estarán disponibles solamente cuando la extensión ha sido o bien compilada dentro de PHP o grabada dinámicamente en tiempo de ejecución_

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) (cvs only)
DBX_PERSISTENT (integer)
DBX_RESULT_INFO (integer)
DBX_RESULT_INDEX (integer)
DBX_RESULT_ASSOC (integer)
DBX_RESULT_UNBUFFERED (integer) (CVS only)
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)

Tabla de contenidos
dbx_close __ Close an open connection/database
dbx_compare __ Compare two rows for sorting purposes
dbx_connect __ Open a connection/database
dbx_error __ Report the error message of the latest function call in the module (not just in the connection)
dbx_escape_string __ Escape a string so it can safely be used in an sql_statement_
dbx_fetch_row __ Fetches rows from a query_result that had the DBX_RESULT_UNBUFFERED flag set
dbx_query __ Send a query and fetch all results (if any)
dbx_sort __ Sort a result from a dbx_query by a custom sort function