PHP commonly used ODBC function set (details)_PHP tutorial

ODBC connection function
odbc_connect function: open an ODBC connection
odbc_close function: close an already opened ODBC connection
odbc_close_all function: close all open ODBC connections
odbc_pconnect function: Open a persistent ODBC connection

ODBC operation class functions
odbc_commit function: update all pending operations
odbc_do function: execute SQL statements on the open ODBC connection
odbc_exec function: execute SQL Statement
odbc_execute function: execute a preset SQL statement
odbc_free_result function: release the memory occupied by the returned data
odbc_prepare function: execute the preset SQL statement
odbc_rollback function: cancel all pending Determine status operations

ODBC information acquisition class function
odbc_columnprivileges function: List the columns of a given table and related permissions
odbc_columns function: List the names of columns of the specified table
odbc_cursor function : Get the name of the cursor
odbc_data_source function: Return information about connecting to the database
odbc_error function: Get the last error code
odbc_errormsg function: Get the last error information
odbc_fetch_array function: Get the result set array
odbc_fetch_into function: Get the specified column returned
odbc_fetch_object function: Return the result set to the object
odbc_fetch_row function: Get a column returned
odbc_field_len function: Get the length of the field
odbc_field_name function: Get the field Name
odbc_field_num function: Get the serial number of the field
odbc_field_precision function: Get the length of the field
odbc_field_scale function: Get the floating point number of the field
odbc_field_type function: Get the data type of the 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 returned column
odbc_num_fields function: gets the number of fields
odbc_num_rows function: gets the returned Number of columns
odbc_primarykeys function: returns the name of the column as the primary key of the table
odbc_procedurecolumns function: returns parameter information of the retrieval process
odbc_procedures function: obtains process information that exists in a specific data source
odbc_result_all function: Return HTML table information
odbc_result function: Get the result data
odbc_specialcolumns function: Return the columns in a table that can be automatically updated when transmitting updates
odbc_statistics function: Get the status of the table and its index
odbc_tableprivileges Function: List the tables and the permissions associated with each table
odbc_tables function: Get the name of the table on a specific database
odbc_autocommit function: Turn on or off automatic update
odbc_binmode function: Set the binary data processing method
odbc_next_result function: Check whether the next result set is available
odbc_setoption function: Adjust ODBC settings