php - 从 Mysql 在 Php 中检索和显示数据

Question

我想从 z1760359 的成员表中检索 firstName 。当我执行代码时，它只显示成员表中的名字，其余的不显示

Member table in z1760359

select firstName from member

| Roberto   |
| Savannah  |
| Sai       |
| Adarsh    |
| Jane      |

---

$hostname='localhost';
$username='root';
$pass='';  
$db="z1760359";
$db1=mysqli_connect($hostname,$username,$pass,$db) or die('Oops something     went wrong ');
$query= "SELECT firstName from member";
$message1=mysqli_query($db1,$query);
$message2=mysqli_fetch_assoc($message1);
foreach($message2 as $r1)
  {
     echo"$r1";

     echo"<br>";
   }
?>

Answer 1

代码仅将最后一行存储到变量中。尝试 -

while($message2=mysqli_fetch_assoc($message1)) {
    echo $message2['firstName'];
    echo"<br>";
}

使用 'while' 循环而不是使用 foreach。