php - 从 PHP 查询获取特定格式的 JSON

Question

我想得到一个像这样的数组:

{
    "version": "1397992135_1932",
    "list": {
        "20514072":["John Carter","FiExJGIpsek.jpg",1],
        "7247045":["Joe Satriani","KzvE54Z4rlA.jpg",0],
        "91120813":["Mikel Arteta","JnPwkLKGeCA.jpg",1]
    }
}

在数据库中我有简单的行:

id | name | photo | vip

如何将查询结果格式化为我想要的格式？

更新

如果我有 100 条记录，我并不真正理解如何编写代码以从数据库中获取数据。

Answer 1

这将是实现您正在寻找的 JSON 字符串所需的数组设置:

$data = array(
        "version" => "1397992135_1932",
        "list" =>
    array(
        "20514072" => array(
        "John Carter",
        "iExJGIpsek.jpg",
         "1"
         ),
        "7247045" => array(
        "Joe Satriani",
        "KzvE54Z4rlA.jpg",
        "0"
        ),
        "91120813" => array(
        "Mikel Arteta",
        "JnPwkLKGeCA.jpg",
        "1"
    ))
);

echo "<pre>";   
echo json_encode($data);
echo "</pre>";
?>

输出:

{
    "version":"1397992135_1932",
    "list":{
        "20514072":["John Carter","iExJGIpsek.jpg","1"],
        "7247045":["Joe Satriani","KzvE54Z4rlA.jpg","0"],
        "91120813":["Mikel Arteta","JnPwkLKGeCA.jpg","1"]
    }
}