MySQL can be connected to the Web in two ways via PHP, a MySQL-related function via PHP, and an ODBC-related function through PHP.
The relevant functions are as follows:
MySQL function
Mysql_affected_rows: Gets the number of columns affected by MySQL last operation.
Mysql_close: Close the MySQL server connection.
Mysql_connect: Turn on MySQL server connection.
mysql_create_db: Create a new MySQL database.
Mysql_data_seek: Move the internal return indicator.
Mysql_db_query: Send query string (query) to MySQL repository.
mysql_drop_db: Remove the database.
Mysql_errno: Returns the error message code.
Mysql_error: Returns the error message.
Mysql_fetch_array: Returns the array data.
Mysql_fetch_field: Get information about the field.
Mysql_fetch_lengths: Returns the maximum length of the column data.
Mysql_fetch_object: Returns the object data.
Mysql_fetch_row: Returns the columns of each column.
Mysql_field_name: Returns the name of the specified field.
Mysql_field_seek: Sets the indicator to a field that returns a value.
Mysql_field_table: Gets the table name of the current field.
Mysql_field_type: Gets the type of the current field.
Mysql_field_flags: Gets the current field flag.
Mysql_field_len: Gets the length of the current field.
Mysql_free_result: Release returns memory.
MYSQL_INSERT_ID: Returns the ID of the last use of the insert instruction.
Mysql_list_fields: Lists the fields (field) for the specified table.
Mysql_list_dbs: Lists the databases available to the MySQL server.
Mysql_list_tables: Lists the tables (table) for the specified database.
Mysql_num_fields: Gets the number of returned fields.
Mysql_num_rows: Gets the number of returned columns.
Mysql_pconnect: Open MySQL Server long-term connection.
Mysql_query: Send out a query string.
Mysql_result: Gets the result of the query.
mysql_select_db: Select a database.
Mysql_tablename: Gets the table name.
ODBC functions
Using ODBC functions to install MySQL ODBC
Odbc_autocommit: Switch automatic change function.
Odbc_binmode: Sets the binary data processing mode.
Odbc_close: Close the ODBC link.
Odbc_close_all: Closes all ODBC links.
Odbc_commit: Changes to ODBC repositories.
Odbc_connect: links to ODBC repositories.
Odbc_cursor: Gets the cursor name.
ODBC_DO: Executes the SQL instruction.
Odbc_exec: Executes the SQL instruction.
Odbc_execute: Executes the preset SQL instruction.
Odbc_fetch_into: Gets the specified column passed back.
Odbc_fetch_row: Gets a column returned.
Odbc_field_name: Gets the field name.
Odbc_field_type: Get field data form.
Odbc_field_len: Gets the column data length.
Odbc_free_result: Releases the memory that is transmitted back to the data.
Odbc_longreadlen: Sets the maximum value of the pass-back bar.
Odbc_num_fields: Gets the number of fields.
Odbc_pconnect: Long-term connectivity to ODBC repositories.
Odbc_prepare: Preset SQL instructions.
Odbc_num_rows: Gets the number of returned columns.
Odbc_result: Obtain the data returned.
Odbc_result_all: Returns HTML table data.
Odbc_rollback: Undoes the current transaction.
Odbc_setoption: adjust ODBC settings.
1
http://www.bkjia.com/PHPjc/446836.html www.bkjia.com true http://www.bkjia.com/PHPjc/446836.html techarticle MySQL can be connected to the Web in two ways via PHP, a MySQL-related function via PHP, and an ODBC-related function through PHP. The relevant functions are as follows: MySQL function Mysql_affected_ro ...