Three common methods for php to access and query mysql data

There are three common methods for PHP to access and query MySQL data:

1. $row = MySQL_fetch_row($result);

Returns a regular array $row, $row[0] is the first element, $row[1] is the second element, and so on...
mysql_num_fields($result) returns the number of elements in the result.

2. $row = mysql_fetch_array($result);

Returns an array $row. For example:
The table structure is as follows:

username | passWord
-------------------------------------
bourbon | abc
berber | efg

The first time you run $row = mysql_fetch_array($result), the result is as follows:

$row[0] = $row["username"] = "bourbon"
$row[1] = $row["password"] = "abc"

The first time you run $row = mysql_fetch_array($result), the result is as follows:

$row[0] = $row["username"] = "berber"
$row[1] = $row["password"] = "efg"


3. $row = mysql_fetch_object($result);

Returns an object description row. As in the above example
The first time you run $row = mysql_fetch_object($result), the results are as follows:

$row->username = "bourbon"
$row->password = "abc"

The second time you run $row = mysql_fetch_object($result), the results are as follows:
$row->username = "berber"
$row->password = "efg"

The above introduces the three commonly used methods of accessing and querying MySQL data in PHP, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.