简介

In addition to normal ODBC support, the Unified ODBC functions in PHP allow you to access several databases that have borrowed the semantics of the ODBC API to implement their own API. Instead of maintaining multiple database drivers that were all nearly identical, these drivers have been unified into a single set of ODBC functions.

The following databases are supported by the Unified ODBC functions: » Adabas D, » IBM DB2, » iODBC, » Solid, and » Sybase SQL Anywhere.

注意: With the exception of iODBC, there is no ODBC involved when connecting to the above databases. The functions that you use to speak natively to them just happen to share the same names and syntax as the ODBC functions. However, building PHP with iODBC support enables you to use any ODBC-compliant drivers with your PHP applications. More information on iODBC, is available at » www.iodbc.org with the alternative unixODBC available at » www.unixodbc.org.

需求

To access any of the supported databases you need to have the required libraries installed.

安装

To disable unified ODBC support in PHP 3 add --disable-unified-odbc to your configure line. Only applicable if iODBC, Adabas, Solid, Velocis or a custom ODBC interface is enabled.

PHP 的 Windows 版本已经内置该扩展模块的支持。无需加载任何附加扩展库即可使用这些函数。

运行时配置

这些函数的行为受 php.ini 的影响。

注意: Entries marked with * are not implemented yet.

以下是配置选项的简要解释。

资源类型

This extension defines two resource types: an ODBC connection identifier and an ODBC result identifier.

预定义常量

以下常量由本扩展模块定义，因此只有在本扩展模块被编译到 PHP 中，或者在运行时被动态加载后才有效。

目录

odbc_autocommit Toggle autocommit behaviour

odbc_binmode Handling of binary column data

odbc_close_all Close all ODBC connections

odbc_close Close an ODBC connection

odbc_columnprivileges Returns a result identifier that can be used to fetch a list of columns and associated privileges

odbc_columns Lists the column names in specified tables

odbc_commit Commit an ODBC transaction

odbc_connect Connect to a datasource

odbc_cursor Get cursorname

odbc_data_source Returns information about a current connection

odbc_do Synonym for odbc_exec()

odbc_error Get the last error code

odbc_errormsg Get the last error message

odbc_exec Prepare and execute a SQL statement

odbc_execute Execute a prepared statement

odbc_fetch_array Fetch a result row as an associative array

odbc_fetch_into Fetch one result row into array

odbc_fetch_object Fetch a result row as an object

odbc_fetch_row Fetch a row

odbc_field_len Get the length (precision) of a field

odbc_field_name Get the columnname

odbc_field_num Return column number

odbc_field_precision Synonym for odbc_field_len()

odbc_field_scale Get the scale of a field

odbc_field_type Datatype of a field

odbc_foreignkeys Returns a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the specified table

odbc_free_result Free resources associated with a result

odbc_gettypeinfo Returns a result identifier containing information about data types supported by the data source

odbc_longreadlen Handling of LONG columns

odbc_next_result Checks if multiple results are available

odbc_num_fields Number of columns in a result

odbc_num_rows Number of rows in a result

odbc_pconnect Open a persistent database connection

odbc_prepare Prepares a statement for execution

odbc_primarykeys Returns a result identifier that can be used to fetch the column names that comprise the primary key for a table

odbc_procedurecolumns Retrieve information about parameters to procedures

odbc_procedures Get the list of procedures stored in a specific data source

odbc_result_all Print result as HTML table

odbc_result Get result data

odbc_rollback Rollback a transaction

odbc_setoption Adjust ODBC settings

odbc_specialcolumns Returns either the optimal set of columns that uniquely identifies a row in the table or columns that are automatically updated when any value in the row is updated by a transaction

odbc_statistics Retrieve statistics about a table

odbc_tableprivileges Lists tables and the privileges associated with each table

odbc_tables Get the list of table names stored in a specific data source