# ODBC (Unified)

# Introduction

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.

> Note:

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

- Installing/Configuring
  - Requirements
  - Installation
  - Runtime Configuration
  - Resource Types
- Predefined Constants
- ODBC Functions
  - 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 — Alias of 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 — Alias of 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

`↑` and `↓` to navigate • `Enter` to select • `Esc` to close • `/` to open