关于PHP中mysqli_fetch_array()及MYSQLI_ASSOC参数的功能咨询

Hey Luca, let's break down your questions clearly—this is core stuff for working with MySQL in PHP, so it's smart to get a solid grasp on it!

When you run a SELECT query with mysqli, the database sends back a result set (think of it as a collection of all the rows that matched your query). The "fetch" action is how you pull individual rows out of that result set and convert them into a format PHP can work with—like an array. Each time you call a fetch function, it moves an internal pointer to the next row in the result set. Once there are no more rows left, it returns null, which is handy for looping through all results.

MYSQLI_ASSOC is a constant that tells mysqli_fetch_array() to return an associative array. That means the keys of the array are exactly the column names from your database table.

For example, if your query pulls id and email from a users table, the returned $row would look like:

[
    'id' => 42,
    'email' => 'luca@example.com'
]

This is way more readable than using numeric indexes (like $row[0] or $row[1]) because you can refer to values by their actual column names—no need to remember which index maps to which column.

Other options include MYSQLI_NUM (numeric indexed array only) and MYSQLI_BOTH (both associative and numeric indexes), but MYSQLI_ASSOC is the go-to for most cases since it makes code easier to maintain.

The $result variable you get from mysqli_query() isn't directly usable data—it's a mysqli result object that holds the raw database response. You can't just echo it or loop through it directly.

mysqli_fetch_array() acts as a translator: it takes the next row from that result object and turns it into a PHP array, making the data accessible. Without it, you'd have no way to read or manipulate the rows returned by your query.

Here's a quick practical example to tie it all together:

// Assume $conn is your established database connection
$result = mysqli_query($conn, "SELECT id, name FROM users");

// Loop through every row in the result set
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    echo "User: " . $row['name'] . " (ID: " . $row['id'] . ")<br>";
}

This loop runs until mysqli_fetch_array() returns null (all rows processed), printing each user's details.

内容的提问来源于stack exchange，提问作者Luca21