如何在MySQL/PHP中选择行 - How to select rows in MySQL/PHP?

How to select rows in MySQL/PHP?

本文关键字：选择 PHP MySQL | 更新日期: 2023-09-27

我正试图通过uid显示我的前10个用户及其信息。当我使用下面的代码时，它只返回一个uid:

include "db_conx.php";
$sql = ('SELECT uid,username,country FROM users ORDER BY uid DESC LIMIT 10');
$result = mysqli_query($db_conx, $sql);
echo $result->fetch_object()->uid;

我应该使用什么功能来正确显示行？

include "db_conx.php";
$sql = ('SELECT uid,username,country FROM users ORDER BY uid DESC LIMIT 10');
$result = mysqli_query($db_conx, $sql);
while($var = $result->fetch_object()->uid){
echo $var;
}

应该做的技巧

如果你得到一个对象列表，你应该使用一个循环来显示它们

include "db_conx.php";
$sql = ('SELECT uid,username,country FROM users ORDER BY uid DESC LIMIT 10');
$result = mysqli_query($db_conx, $sql);
while($row = mysqli_fetch_object($result)) {             
   $row->uid;
}