What does fetch mean in php?

Fetch in php refers to the fetch method for querying data. The commonly used fetch methods in php are mysqli_fetch_assoc, mysqli_fetch_row, mysqli_fetch_array, and mysqli_fetch_object.

The operating environment of this article: Windows 7 system, PHP version 7.4, DELL G3 computer

What does fetch mean in php?

The fetch in php refers to the fetch method for querying data.

The difference between four commonly used fetch in PHP

In PHP, mysqli_fetch is often used to fetch data from the result set returned by the database. The most commonly used one is:

mysqli_fetch_assoc() , mysqli_fetch_row(), mysqli_fetch_array(), mysqli_fetch_object(), when used, their differences are as follows:

$publicMes = mysqli_fetch_assoc($res);
var_dump($publicMes);

The results are as follows:

 $a = mysqli_fetch_row($res);
 var_dump($a);

The results are as follows

 $b = mysqli_fetch_array($res);
 var_dump($b);
 echo $b[1].'<br>';
 echo $b['user'];

The results are as follows:

$c = mysqli_fetch_object($res);
 var_dump($c);

The results are as follows:

In summary:
fetch_assoc() returns an associative array, using database fields as key values To get the value,
fetch_row() returns an index array, use the index to get the value,
fetch_array() returns an associative array, with both index numbers and fields. Values ​​can be obtained by both methods. ,
fetch_object() returns an object.

Note:

All fetch fetches data from the result set returned by the database Only one fetch is fetched at a time. After fetching, click the pointer. Move and fetch the new next time, so you need to use a while loop to get all the values. If fetch is used once before the loop, the data will be incomplete

Recommended learning: "PHP Video Tutorial》

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