MySQL can be connected to the Web through PHP in two ways, a MySQL-related function via PHP, and another ODBC-related function via PHP
The related functions are as follows: MySQL function Mysql_affected_rows: Gets the number of columns affected by the MySQL last operation.
Mysql_close: Close the MySQL server connection.
Mysql_connect: Open the MySQL server connection.
mysql_create_db: Create a new MySQL database.
Mysql_data_seek: Move internal return indicator.
Mysql_db_query: Send query string to MySQL database.
mysql_drop_db: Remove the repository.
Mysql_errno: Returns the error message code.
Mysql_error: Send back the error message.
Mysql_fetch_array: Returns the array data.
Mysql_fetch_field: Get field information.
Mysql_fetch_lengths: Returns the maximum length of column data.
Mysql_fetch_object: Returns the object data.
Mysql_fetch_row: Returns a single column of fields.
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 for the current field.
Mysql_field_type: Gets the current field type.
Mysql_field_flags: Get the flag for the current field.
Mysql_field_len: Gets the current field length.
Mysql_free_result: Release back to occupy memory.
MYSQL_INSERT_ID: Returns the ID for the last time the insert instruction was used.
Mysql_list_fields: Lists the fields (field) for the specified table.
Mysql_list_dbs: Lists the database (database) available for the MySQL server.
Mysql_list_tables: Lists the table (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 the MySQL server long-term connection.
Mysql_query: Send out a query string.
Mysql_result: Gets the results of the query.
mysql_select_db: Select a database.
Mysql_tablename: Gets the table name.
ODBC Functions use ODBC functions to install MySQL ODBC Odbc_autocommit: Switch automatic change function.
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.