创建一个逗号分隔的列表，从mysqli结果中回显

Question

$get_top10 = mysqli_query($con, "SELECT name, daily_points, daily_win FROM players WHERE daily_points > 0 ORDER BY daily_points DESC LIMIT 10");

我需要一个字符串:Name, daily_points, daily_win, Name, daily_points, daily_win(等最多10条记录)

php 7.4.27mysql 5.6.51-cll-lve

这个方法成功了，如果有更好的或首选的方法，请告诉我。

$sql = ("SELECT name, daily_points, daily_win FROM players WHERE daily_points > 0 ORDER BY daily_points DESC LIMIT 10");
$result = mysqli_query($con, $sql);
if (mysqli_num_rows($result)) {
while ($row = mysqli_fetch_assoc($result)) {
echo "{$row['name']},{$row['daily_points']},{$row['daily_win']},";
}
}

Answer 1

你可以试试这段代码，它会将你的PHP变量连接到HTML '，'这是首选方法

$sql = ("SELECT name, daily_points, daily_win FROM players WHERE daily_points > 0 ORDER BY daily_points DESC LIMIT 10");
$result = mysqli_query($con, $sql);

if (mysqli_num_rows($result)) {
while ($row = mysqli_fetch_assoc($result)) {
echo $row['name'].','.$row['daily_points'].','.$row['daily_win'];
}
}