MySQL can be connected to the Web in two ways via PHP, a MySQL-related function via PHP, and an ODBC-related function via 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.
http://www.bkjia.com/PHPjc/631102.html www.bkjia.com true http://www.bkjia.com/PHPjc/631102.html techarticle There are two ways MySQL can be connected to the web via PHP, a MySQL-related function via PHP, and an ODBC-related function related function via PHP: MySQL function mysql_affected_rows: ...
