我正在尝试从表中的行查询数据,将数据存储到数组中,然后从数组中回显出某个值。这是PHP:

$receiveuserdata = mysqli_query($connection, "SELECT * FROM s_users LIMIT 0,1");

$userdata = array();
$index = 0;
while ($row = mysqli_fetch_assoc($receiveuserdata)) {
    $userdata[$index] = $row;
    $index++;
};


我曾尝试使用与此问题相关的其他帖子寻求帮助,但大多数帖子已过时。这是我尝试从数组中回显一个值:

 <h3>Username: <?php echo $userdata[0]; ?></h3>


我使用$receiveuserdata的方式不正确吗?

最佳答案

检索单行

您习惯了LIMIT 0,1-因此它将仅检索一行

<?php
$receiveuserdata = mysqli_query($connection, "SELECT * FROM s_users LIMIT 0,1");
if (mysqli_num_rows($receiveuserdata) > 0)
{
    $row = mysqli_fetch_assoc($receiveuserdata);
    $username = $row['username'];
    echo '<h3>Username: '.$username.'</h3>';
}
?>


检索多行

<?php
$receiveuserdata = mysqli_query($connection, "SELECT * FROM s_users");
if (mysqli_num_rows($receiveuserdata) > 0)
{
while ($row = mysqli_fetch_assoc($receiveuserdata)) {
    $username = $row['username'];
    echo '<h3>Username: '.$username.'</h3>';
}
}
?>

关于php - 如何在PHP中将行存储到数组中并回显数组的某个值?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/36347840/

10-14 13:57
查看更多