ODBC (Unified)

Introduction

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.

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

Installing/Configuring
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
Odbc\Connection — The Odbc\Connection class
Odbc\Result — The Odbc\Result class