ODBC (Unified)
简介
The ODBC extension allows using ODBC database drivers from PHP, using the same functions in PHP for any driver.
The following drivers and driver managers have direct support:
» IBM DB2,
» iODBC, and
» unixODBC. A user-defined
driver, such as Sybase SQL Anywhere, can also be linked directly
via --with-custom-odbc.
Versions of PHP before 8.5 supported using these databases directly: » Adabas D, DBMaker, Empress, and » Solid.
注意:
It is strongly recommended to use a driver manager like iODBC or unixODBC with PHP. While a driver can be used directly with the ODBC extension through building against it directly, a driver manager provides better flexibility and compatibility. On Windows, the system driver manager is always used.
- 安装/配置
- 预定义常量
- ODBC 函数
- odbc_autocommit — Toggle autocommit behaviour
- odbc_binmode — Handling of binary column data
- odbc_close — Close an ODBC connection
- odbc_close_all — Close all ODBC connections
- odbc_columnprivileges — Lists columns and associated privileges for the given table
- odbc_columns — Lists the column names in specified tables
- odbc_commit — Commit an ODBC transaction
- odbc_connect — Connect to a datasource
- odbc_connection_string_is_quoted — Determines if an ODBC connection string value is quoted
- odbc_connection_string_quote — Quotes an ODBC connection string value
- odbc_connection_string_should_quote — Determines if an ODBC connection string value should be quoted
- odbc_cursor — Get cursorname
- odbc_data_source — Returns information about available DSNs
- odbc_do — 别名 odbc_exec
- odbc_error — Get the last error code
- odbc_errormsg — Get the last error message
- odbc_exec — Directly execute an 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 — 别名 odbc_field_len
- odbc_field_scale — Get the scale of a field
- odbc_field_type — Datatype of a field
- odbc_foreignkeys — Retrieves a list of foreign keys
- odbc_free_result — Free objects associated with a result
- odbc_gettypeinfo — Retrieves 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 — Gets the primary keys 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 — Get result data
- odbc_result_all — Print result as HTML table
- odbc_rollback — Rollback a transaction
- odbc_setoption — Adjust ODBC settings
- odbc_specialcolumns — Retrieves special columns
- 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
- Odbc\Connection — The Odbc\Connection class
- Odbc\Result — The Odbc\Result class
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
