MySQL can be connected to the Web through PHP in two ways, one is mysql-related functions through PHP, and the other is ODBC-related functions through PHP.

The related functions are as follows:

MySQL Functions

Mysql_affected_rows: obtain the number of columns affected by the last MySQL operation.

Mysql_close: disconnect the MySQL server.

Mysql_connect: enables connections to the MySQL server.

Mysql_create_db: Create a New MySQL database.

Mysql_data_seek: Move internal return indicator.

Mysql_db_query: Send the query string to the MySQL database.

Mysql_drop_db: remove the database.

Mysql_errno: return the error code.

Mysql_error: returns an error message.

Mysql_fetch_array: returns the array data.

Mysql_fetch_field: obtains the field information.

Mysql_fetch_lengths: returns the maximum length of data in each column of a single column.

Mysql_fetch_object: returns object data.

Mysql_fetch_row: returns the columns of a single column.

Mysql_field_name: return the name of the specified field.

Mysql_field_seek: Set a field from the indicator to the returned value.

Mysql_field_table: Obtain the name of the table in the current column.

Mysql_field_type: Obtain the current column type.

Mysql_field_flags: obtains the flag of the current field.

Mysql_field_len: Get the length of the current column.

Mysql_free_result: releases the memory occupied by the returned data.

Mysql_insert_id: return the ID of the last INSERT command.

Mysql_list_fields: lists the fields of a specified data table ).

Mysql_list_dbs: List available databases of the MySQL server ).

Mysql_list_tables: lists the tables of a specified database ).

Mysql_num_fields: gets the number of returned fields.

Mysql_num_rows: gets the number of returned columns.

Mysql_pconnect: enables long-term connections to the MySQL server.

Mysql_query: returns a query string.

Mysql_result: gets the query result.

Mysql_select_db: select a database.

Mysql_tablename: Get the table name.

ODBC Functions

To Use ODBC functions, you must install MySQL ODBC

Odbc_autocommit: Enables or disables automatic change.

Odbc_binmode: sets the binary data processing method.

Odbc_close: Close the ODBC link.

Odbc_close_all: Close all ODBC connections.

Odbc_commit: updates the ODBC database.

Odbc_connect: connect to the ODBC database.

Odbc_cursor: Get the cursor name.

Odbc_do: Execute SQL commands.

Odbc_exec: Execute SQL commands.

Odbc_execute: Execute the preset SQL command.

Odbc_fetch_into: gets the specified column returned.

Odbc_fetch_row: returns a column.

Odbc_field_name: obtains the column name.

Odbc_field_type: obtains the column data format.

Odbc_field_len: obtains the length of the column data.

Odbc_free_result: refers to the memory used to send data back.

Odbc_longreadlen: sets the maximum value of the return column.

Odbc_num_fields: obtains the number of fields.

Odbc_pconnect: long-term connection to the ODBC database.

Odbc_prepare: preset SQL commands.

Odbc_num_rows: gets the number of returned columns.

Odbc_result: Obtain the returned data.

Odbc_result_all: returns HTML table data.

Odbc_rollback: undo the current transaction.

Odbc_setoption: adjusts ODBC settings.