从 MySQL PHP 创建逗号分隔列表 [英] Create Comma Seperated List from MySQL PHP

问题描述

我的表中有一个用户列表.我将如何获取该列表并将其作为一个 PHP 变量返回，每个用户名用逗号分隔?

I have a list of users in my table. How would I go about taking that list and returning it as one PHP variable with each user name separated by a comma?

推荐答案

您可以使用查询生成逗号分隔的列表:

You could generate a comma-separated list with a query:

SELECT GROUP_CONCAT(username) FROM MyTable

或者你可以获取行并在 PHP 中加入它们:

Or else you could fetch rows and join them in PHP:

$sql = "SELECT username FROM MyTable";
$stmt = $pdo->query($sql);
$users = array();
while ($username = $stmt->fetchColumn()) {
    $users[] = $username;
}
$userlist = join(",", $users);

这篇关于从 MySQL PHP 创建逗号分隔列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！