Common ODBC function set in php Tutorial

ODBC Connection functions ODBC operation functions ODBC information retrieval class functions ODBC Connection functions
Odbc_connect function: open an ODBC Connection
Odbc_close function: Closes an open ODBC Connection.
Odbc_close_all function: close all open ODBC connections
Odbc_pconnect function: open a continuously valid ODBC Connection

ODBC operation functions
Odbc_commit function: update all pending operations
Odbc_do function: execute SQL statements on the open ODBC Connection
Odbc_exec function: execute SQL statements
Odbc_execute function: execute a preset SQL statement.
Odbc_free_result function: releases the memory occupied by the data returned.
Odbc_prepare function: Execution of preset SQL statements
Odbc_rollback function: undo all pending operations

ODBC information retrieval functions
Odbc_columnprivileges function: lists the columns and related permissions of a given table.
Odbc_columns function: lists the names of columns in a specified table.
Odbc_cursor function: Get the cursor name
Odbc_data_source function: returns the database connection information.
Odbc_error function: get the final error code
Odbc_errormsg function: gets the final error message
Odbc_fetch_array function: returns the number of result sets.
Odbc_fetch_into function: Gets the specified columns returned.
Odbc_fetch_object function: returns the result set to the object.
Odbc_fetch_row function: obtains a returned column.
Odbc_field_len function: obtains the length of a field.
Odbc_field_name function: obtains the field name.
Odbc_field_num function: obtains the serial number of a field.
Odbc_field_precision function: obtains the length of a field.
Odbc_field_scale function: obtains the floating point number of a field.
Odbc_field_type function: obtains the data type of a field.
Odbc_foreignkeys function: returns the foreign key of a specific table.
Odbc_gettypeinfo function: returns the type information of the database.
Odbc_longreadlen function: sets the maximum value of the return column.
Odbc_num_fields function: obtains the number of fields.
Odbc_num_rows function: obtains the number of returned columns.
Odbc_primarykeys function: returns the column name as the primary key of the table.
Odbc_procedurecolumns function: returns the parameter information of the retrieval process.
Odbc_procedures function: obtains process information that exists in a specific data source.
Odbc_result_all function: returns HTML table information.
Odbc_result function: get result data
Odbc_specialcolumns function: returns the columns that can be automatically updated when an update is transmitted in a table.
Odbc_statistics function: obtains the table status and its indexes.
Odbc_tableprivileges function: lists the permissions associated with a table and each table.
Odbc_tables function: obtains the name of a table in a specific database.
Odbc_autocommit function: enable or disable automatic update
Odbc_binmode function: sets the binary data processing mode.
Odbc_next_result function: checks whether the next result set is available.
Odbc_setoption function: adjusts ODBC settings

The above is the content of the commonly used ODBC function set in the php Tutorial. For more articles, please follow the PHP Chinese network (www.php1.cn )!