我正在尝试从表中的行查询数据,将数据存储到数组中,然后从数组中回显出某个值。这是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/