php commonly used ODBC function set of detail

  • 2020-06-19 09:53:42
  • OfStack

ODBC joins class functions
odbc_connect function: Open 1 ODBC connection
odbc_close function: Closes an open ODBC connection
odbc_close_all function: Closes all open ODBC connections
odbc_pconnect function: Opens a continuously valid ODBC connection

ODBC operates on class functions
odbc_commit function: Updates all operations that are in pending state
odbc_do function: Executes the SQL statement on the open ODBC connection
odbc_exec function: Executes the SQL statement
odbc_execute function: Executes 1 preset SQL statement
odbc_free_result function: frees the memory taken up by the returned data
odbc_prepare function: Execution of the preset SQL statement
odbc_rollback function: Undo all operations that are in a pending state

ODBC information retrieval class function
odbc_columnprivileges function: Lists the columns of the given table and the associated permissions
odbc_columns function: Lists the name of the column of the specified table
odbc_cursor function: Gets the name of the cursor
odbc_data_source function: returns information about connecting to the database
odbc_error function: Gets the last error code
odbc_errormsg function: Gets the last error message
odbc_fetch_array function: Gets the result set set
odbc_fetch_into function: Gets the specified column returned
odbc_fetch_object function: Returns the result set to the object
odbc_fetch_row function: Gets the 1 column returned
odbc_field_len function: Gets the length of the field
odbc_field_name function: Gets the name of the field
odbc_field_num function: Gets the ordinal number of the field
odbc_field_precision function: Gets the length of the field
odbc_field_scale function: Gets the floating point number of the field
odbc_field_type function: Gets the data type of the field
odbc_foreignkeys function: Returns a foreign key for a particular table
odbc_gettypeinfo function: Returns the type information for the database
odbc_longreadlen function: Sets the maximum value of the return column
odbc_num_fields function: Gets the number of fields
odbc_num_rows function: Gets the number of columns returned
odbc_primarykeys function: Returns the name of the column as the primary key of the table
odbc_procedurecolumns function: Returns parameter information for the retrieval process
odbc_procedures function: Gets process information that exists in a particular data source
odbc_result_all function: returns HTML table information
odbc_result function: Gets the result data
odbc_specialcolumns function: Returns a column in the table that can be updated automatically when updates are passed
odbc_statistics function: Gets the state of the table and its index
odbc_tableprivileges function: Lists the permissions associated with the table and each table
odbc_tables function: Gets the name of the table on a particular database
odbc_autocommit function: Turn automatic updates on or off
odbc_binmode function: Sets the way data is processed in base 2
odbc_next_result function: Checks whether the next result set is available
odbc_setoption function: Adjusts the ODBC setting


Related articles: