显示保存在数据库中的所有用户名 - Display all usernames saved in database

Display all usernames saved in database

所以我想知道如何显示当前保存在数据库中的所有用户名？

我目前拥有的仍然只显示 1 个用户名

感谢您的任何帮助。

<?php
 $con = new mysqli("blank", "blank", "blank", "blank");

$result = mysqli_query($con,"SELECT * FROM users WHERE user_id > '0'");
$row = mysqli_fetch_array($result);

echo $row['username'];
?>

$con = new mysqli("blank", "blank", "blank", "blank");
$result = mysqli_query($con,"SELECT * FROM users WHERE user_id > 0");
while ( $row = mysqli_fetch_assoc ( $result ) ) {
    echo $row [ 'username' ] ."<br />";
}

这只不过是循环播放您的结果。

        <?php
     $con = new mysqli("blank", "blank", "blank", "blank");

    $result = mysqli_query($con,"SELECT * FROM users WHERE user_id > '0'");
    $row = mysqli_fetch_array($result);
    while($row = mysqli_fetch_array($result)){
    foreach($row as $rs){
echo $rs['name']
}
    }

    ?>

试试这个