English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية

PHP Basic Tutorial

PHP Advanced Tutorial

PHP & MySQL

PHP Reference Manual

PHP ODBC Functions

Open Database Connectivity is an application programming interface (API) that allows programmers to extract programs from databases

Function List

Version-Represents the earliest version of PHP that supports this function.

NumberFunctionDescriptionVersion
1odbc_autocommit()It is used to switch the automatic commit behavior.4
2odbc_binmode()Disconnect4
3odbc_close_all()Used to close all ODBC connections4
4odbc_close()Used to close an ODBC connection4
5odbc_columnprivileges()It contains information about the column list4
6odbc_columns()It is used to obtain a list of column names in a specific table.5
7odbc_commit()Used to commit an ODBC transaction5
8odbc_connect()Used to connect to an ODBC data source5
9odbc_cursor()Used to obtain the cursor5
10odbc_data_source()It returns information about the current connection4.3
11odbc_error()Used to obtain the last error4.0.5
12odbc_errormsg()It is used to obtain the last error message4
13odbc_exec()It is used to prepare and execute Sql statements4
14odbc_fetch_array()It is used to obtain the result row as an associative array4
15odbc_fetch_into()It is used to extract the results into a row5.4
16odbc_fetch_object()It is used to obtain the result row as an object4.0.2
17odbc_fetch_row()It is used to obtain a row4
18odbc_field_len()It is used to obtain the length of the file4
19odbc_filed_name()It is used to obtain the general name4
20odbc_field_num()It is used to obtain the field number4
21odbc_field_scale()It is used to obtain the scale of the field.5.1
22odbc_field_type()It is used to obtain information about the data type of the field5.1
23odbc_foreignkeys()It is used to retrieve the foreign key list.5
24odbc_free_result()It contains information about the available resources that contain the results5
25odbc_gettypeinfo()It is used to retrieve information about data types4
26odbc_loongreadlen()It is used to handle long columns4
27odbc_next_result()It is used to check if there are multiple results4
28odbc_num_rows()It contains information about the number of rows in the result4
29odbc_pconnect()It is an open persistent database connection4
30odbc_prepare()It is used to prepare the execution statement4
31odbc_primarykeys()It is used to obtain the primary key of the table4
32odbc_procedurecolumns()It is used to retrieve information about procedure parameters4
33odbc_procedures()It is used to obtain the list of procedures stored in a specific data resource4
34odbc_result_all()It is used to print the results as an HTML table4
35odbc_result()It is used to print the results as an HTML table4
36odbc_rollback()It is used to roll back the transaction4
37odbc_setoption()It is used to adjust the odbc settings4
38odbc_specialcolumns()It is used to retrieve special columns4
39odbc_statistics()It is used to retrieve the static information of the table4
40odbc_tableprivileges()It is used to list tables and the permissions associated with each table4
41odbc_tables()It is used to obtain the list of tables stored in the data source4