PHP Common ODBC function set (verbose) _php tutorial

Source: Internet
Author: User
Tags odbc connection
ODBC Connection class functions
Odbc_connect function: Open an ODBC connection
Odbc_close function: Closes an ODBC connection that is already open
Odbc_close_all function: Close all ODBC connections that are already open
Odbc_pconnect function: Open a continuous, valid ODBC connection

ODBC Operation class Functions
Odbc_commit function: Update all pending state operations
ODBC_DO function: Execute SQL statement on an open ODBC connection
odbc_exec function: Execute SQL statement
Odbc_execute function: Execute a pre-built SQL statement
Odbc_free_result function: Releasing the memory used to transmit data back
Odbc_prepare function: Execution of a preset SQL statement
Odbc_rollback function: Undo all pending State operations

ODBC information Get class function
odbc_columnprivileges function: List columns and related permissions for a given table
Odbc_columns function: Lists the names of the columns for the specified table
Odbc_cursor function: Gets the name of the cursor
Odbc_data_source function: Returns information about a connected database
Odbc_error function: Get the last error code
odbc_errormsg function: Get the last error message
Odbc_fetch_array function: Getting an array of result sets
Odbc_fetch_into function: Gets the specified column returned
Odbc_fetch_object function: Return result set to Object
Odbc_fetch_row function: Gets the 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 of a 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 specific table
Odbc_gettypeinfo function: Returns the type information of the database
Odbc_longreadlen function: Sets the maximum value of the pass-back bar
Odbc_num_fields function: Get 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: Get process information that exists in a particular data source
Odbc_result_all function: Returns HTML table information
Odbc_result function: Get result data
Odbc_specialcolumns function: Returns the column in a table that can be automatically updated when the update is delivered
Odbc_statistics function: Gets the state of the table and its index
Odbc_tableprivileges function: List the permissions associated with tables and each table
Odbc_tables function: Get the name of a table on a specific database
Odbc_autocommit function: Turn Automatic Updates on or off
Odbc_binmode function: Set binary data processing mode
Odbc_next_result function: Check if the next result set is available
odbc_setoption function: Adjusting ODBC settings

http://www.bkjia.com/PHPjc/327801.html www.bkjia.com true http://www.bkjia.com/PHPjc/327801.html techarticle ODBC connection class function Odbc_connect function: Open an ODBC connection Odbc_close function: Close an ODBC connection that is already open Odbc_close_all function: Close all ODBC connections that are already open ...

  • Related Article

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.