MySQL mysqli_fetch_assoc field name & value. How?

Question

The following code returns the field names of a result set. I also want it to return the values. How can I do this?

while ($row = mysqli_fetch_assoc($result)) {
    foreach( $row as $field => $name) {
        echo $field."<br>";
    }
}

Answer 1

If we assume that your array looks like this:

$row["first_name"] = "John";
$row["last_name"] = "Doe";
$row["username"] = "john.doe";

Using this code:

while ($row = mysqli_fetch_assoc($result)) {
    foreach( $row as $field => $value) {
        echo "{$field} - {$value}<br>";
    }
}

You will get an output like this:

first_name - John
last_name - Doe
username - john.doe

When you iterate through an array, using => operator, you are iterating in a "key-value" pair style. Every iteration holds the key and value as you can see.

Take a look at foreach for more information.