Home > Backend Development > PHP Tutorial > Two ways to connect to MYSQL through PHP_PHP tutorial

Two ways to connect to MYSQL through PHP_PHP tutorial

WBOY
Release: 2016-07-13 17:02:00
Original
847 people have browsed it

mysql can be connected to the web through PHP in two ways, one through php's mysql related functions, the other through php's ODBC related functions
The related 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 the internal return indicator.

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: Return 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 that returns the 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 and return the occupied memory.

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 MySQL server.

mysql_query: Send a query string.

mysql_result: Get the result of the query.

mysql_select_db: Select a database.

mysql_tablename: Get the name of the data table.
 

ODBC function
Using ODBC functions requires installing MYSQL ODBC
odbc_autocommit: Switch the automatic change function on and off.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631102.htmlTechArticlemysql can be connected to the web through PHP in two ways, one through the mysql related functions of php, and the other The related functions through php's ODBC related functions are as follows: MYSQL function mysql_affected_rows:...
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template