Some commonly used built-in functions for php to operate mysql database

1. Use the database:

Connect to the database:

$con = mysql_connect($hostname, $user, $ pass);

If the connection is successful, a connection identifier will be returned, otherwise false

Select database:

mysql_select_db('info'); //The return value is a Boolean type

Set the database character set:

mysql_query('set names utf8');

Disconnect database link：

mysql_close($con);

##Return the previous error message:

##mysql_error() ;2. Execute sql statement:

(1) sql The statements are add, delete, update

The return value of mysql_query() is a Boolean type

mysql_insert_id()To get the auto-incremented id, this id can be used to determine whether the insertion is successful, or used as an associated id for other database operations.

(2) When the sql statement is a query, select When the query is successful, the

of the result set is returned) ), otherwise return false## 3. Process the result set:

(1)

;##                                                                                                                                                                    Every time mysql_fetch_row is executed, a piece of data is fetched from the resource, that is, the result set, and returned in the form of an array. The last piece of data has been fetched at this time. , this time an empty result is returned.

The returned array is a one-dimensional index array

(2)

($query) mysql_fetch_assoc is executed every time Each time, a piece of data is fetched from the resource, that is, the result set, and returned in the form of an array. When the last piece of data has been fetched the previous time, an empty result is returned this time.

The returned array is a one-dimensional associative array, each key value corresponds to a field in the database.

(3)mysql_fetch_array

Optional parameter param2: MYSQL_ROW: equivalent to mysql_fetch_row($query) MySQL_ASSOC: Equivalent to mysql_fetch_assoc ($ Query);

MySQL_BOTH (default):

This is performed by the result of the result of the result of the result of the resource. Fetch a piece of data one by one and return it in the form of an array. When the last piece of data has been fetched previously, an empty result is returned this time.

The array returned is

.

(4)

mysql_fetch_object($query)

          Each time it is executed, a piece of data is taken from the resource, that is, the result set, and returned in the form of object. The attributes in the object are the field names, and the values ​​correspond to Corresponding field value

## $con=mysql_connect( $host, $user, $pass);

## mysql_affected_rows($con);

The above is the detailed content of Some commonly used built-in functions for php to operate mysql database. For more information, please follow other related articles on the PHP Chinese website!