Introduction to two methods of connecting to MySQL through PHP_PHP Tutorial

mysql can be connected to the web through PHP in two ways, one through php's mysql related functions, and the other through php's ODBC related functions

The relevant functions are as follows:

MYSQL function

mysql_affected_rows: Get the number of columns affected by the last MySQL 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 metrics.

mysql_db_query: Send query string (query) to the MySQL database.

mysql_drop_db: Remove the database.

mysql_errno: Return error message code.

mysql_error: Return error message.

mysql_fetch_array: Return array data.

mysql_fetch_field: Get field information.

mysql_fetch_lengths: Returns the maximum length of each column of data in a single column.

mysql_fetch_object: Returns object data.

mysql_fetch_row: Returns each column of a single column.

mysql_field_name: Returns the name of the specified field.

mysql_field_seek: Set the indicator to a field of the returned value.

mysql_field_table: Get the name of the data table (table) of the current field.

mysql_field_type: Get the type of the current field.

mysql_field_flags: Get the flags of the current field.

mysql_field_len: Get the length of the current field.

mysql_free_result: Release the memory occupied by the returned data.

mysql_insert_id: Returns the ID of the last INSERT instruction used.

mysql_list_fields: List the fields of the specified data table.

mysql_list_dbs: Lists the databases available on the MySQL server.

mysql_list_tables: List the tables (tables) of the specified database.

mysql_num_fields: Get the number of fields returned.

mysql_num_rows: Get the number of columns returned.

mysql_pconnect: Enable long-term connection to the MySQL server.