Common ODBC function set in php Tutorial

Source: Internet
Author: User
Tags odbc connection
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 )!

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.