在PHP中自动输出MySQL行

Question

Continuing from my other question, I now know how to extract the fieldnames into variables with the result stored in them.

However, lets say I wish to output like this:

<?php
  echo "Here is field1: ".$row['field1'];
  echo "Here is field2: ".$row['field2'];
  echo "Here is field3: ".$row['field3']; 
?>

And I have over 40 fields in my table, so to avoid having to type them all out like the above, how can I automate it?

Answer 1

foreach ($row as $key => $value) {
    echo "Here is '" . $key . "': " . $value . "<br>
";
}