PHP 매뉴얼
이전 |  | 다음

# XX. dbx Functions

# 소개

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.

# 요구 사항

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/.

# 설치

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.

# 런타임 설정

이 함수의 작동은 `php.ini` 설정에 영향을 받습니다.

표 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().

> 참고: This ini-option is available available from PHP 4.3.0.

위 설정 지시어에 대한 간단한 설명입니다.

`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().

# 리소스 종류

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.

# 상수 정의

이 확장 모듈은 다음의 상수를 정의합니다. 이는 확장 모듈을 PHP에 내장했거나, 실행시에 동적으로 읽어들일 경우에만 사용할 수 있습니다.

`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)

이전 | 처음으로 | 다음
dbmreplace | 위로 | dbx_close