来自 sql 数据库的 json_encode 结果

Question

数据库：ID  str域1   x.com2   y.com3   z.com$domainSettings = array();$db_domainList = DB::get("SELECT strDomain FROM domains ORDER BY id ASC;");foreach($db_domainList as $row) {    $domainSettings = array($row->strDomain);}$result = array('allowedDomains' => $domainSettings);echo json_encode($result, JSON_FORCE_OBJECT);当前输出：{"allowedDomains":{"0":"x.com"}}我需要类似于这样的输出：{"allowedDomains":"x.com","y.com","z.com"}输出echo json_encode($db_domainList);：[{"strDomain":"x.com"},{"strDomain":"z.com"},{"strDomain":"y.com"}]

Answer 1

如果考虑到所需的输出无效，我正确理解了您的问题，那么这段代码应该可以解决问题。

$db_domainList = DB::get("SELECT strDomain FROM domains ORDER BY id ASC;");

$domainSettings = []; //Just incase $db_domainList is empty

foreach($db_domainList as $row) {

    $domainSettings[] = $row->strDomain;

}

$result = array('allowedDomains' => $domainSettings);

echo json_encode($result);

请注意，我已删除JSON_FORCE_OBJECT标志，因为您要求包含和数组的输出。

上面代码的输出应该看起来像这样，这与您要查找的内容非常接近。

{

    "allowedDomains": [

        "x.com",

        "y.com",

        "z.com"

    ]

}

Answer 2

如果我没有误解你的要求，那么你可以这样做 -

$db_domainList = DB::get("SELECT strDomain FROM domains ORDER BY id ASC;");

foreach($db_domainList as $row) {

    $domainSettings[] = $row->strDomain;

}

$result = array('allowedDomains' => implode(',',$domainSettings));

echo json_encode($result, JSON_FORCE_OBJECT);