Two ways to connect MySQL via PHP (1)

MySQL MySQL can be connected to the Web through PHP in two ways, one via PHP mysql-related functions, the other through PHP's ODBC-related functions

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.
Odbc_binmode: Set binary data processing mode.
Odbc_close: Close ODBC connection.
Odbc_close_all: Closes all ODBC connections.
Odbc_commit: Changes ODBC database.
Odbc_connect: Link to ODBC repository.
Odbc_cursor: Gets the cursor name.
Odbc_do: Execute SQL directives.
Odbc_exec: Execute SQL directives.
Odbc_execute: Executes preset SQL directives.
Odbc_fetch_into: Gets the specified column returned.
Odbc_fetch_row: Get a column back.
Odbc_field_name: Gets the field name.
Odbc_field_type: Get field data form.
Odbc_field_len: Gets the field data length.
Odbc_free_result: Release the memory that returns the data.
Odbc_longreadlen: Sets the maximum value for the return column.
Odbc_num_fields: Gets the number of fields.
Odbc_pconnect: Link to ODBC database for a long time.
Odbc_prepare: Presets SQL directives.
Odbc_num_rows: Gets the number of returned columns.
Odbc_result: Get the information back.
Odbc_result_all: Returns HTML form data.
Odbc_rollback: Undo current transaction.
Odbc_setoption: adjust ODBC settings.