What is the usage of fetch in php

Usage: 1. "mysql_fetch_row" is used to obtain a row from the result set as a numeric array; 2. "mysql_fetch_array" is used to obtain a row from the result set as an associative array; 3. "mysql_fetch_object" is used to obtain a row from the result set as an associative array Gets a row as an object.

The operating environment of this article: Windows 10 system, PHP version 7.1, Dell G3 computer

What is the usage of fetch in php

The usage and difference of fetch for php query data are summarized as follows:

• mysql_fetch_row;

mysql_fetch_row() The function takes a row from the result set as an array of numbers.

The syntax is:

mysql_fetch_row(data)

data required. The data pointer to use. The data pointer is the result returned from mysql_query().

• mysql_fetch_array;

mysql_fetch_array() function gets a row from the result set as an associative array, or numeric array, or Both

Returns an array based on the rows obtained from the result set, or false if there are no more rows.

mysql_fetch_array(data,array_type)

data Optional. Specifies the data pointer to be used. This data pointer is the result of the mysql_query() function.

array_type optional. Specifies what kind of results are returned. Possible values:

MYSQL_ASSOC - Associative array

MYSQL_NUM - Numeric array

MYSQL_BOTH - Default. Produces both associative and numeric arrays

• mysql_fetch_assoc;

mysql_fetch_assoc() function obtains a row from the result set as an associative array .

Returns an associative array generated based on the rows obtained from the result set, or false if there are no more rows.

mysql_fetch_assoc(data)

data Required. The data pointer to use. The data pointer is the result returned from mysql_query().

• mysql_fetch_object;

mysql_fetch_object() function obtains a row as an object from the result set (record set).

If successful, this function gets a row from mysql_query() and returns an object. Returns false on failure or if there are no more rows.

mysql_fetch_object(data)

data Required. The data pointer to use. The data pointer is the result returned from mysql_query().

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of What is the usage of fetch in php. For more information, please follow other related articles on the PHP Chinese website!