PHP mysql结果json_encode返回键和索引号

Question

为什么 JSON 输出同时显示索引号和关联列名？

我只需要列名，例如“UID”

PHP 代码

$res = $statement->fetchAll();
$records = array('Record'=>$posts);
echo json_encode($records);

JSON 输出

{
  "Record":[
    {
      "UID":"1001",
      "0":"1001",
      "NAME":"Robot2",
      "1":"Robot2",
      "EMAIL":"robot2@test.com",
      "2":"robot2@test.com",
      "GENDER":"f",
      "3":"f"
    },
    {
      "UID":"1030",
      "0":"1030",
      "NAME":"Anna",
      "1":"Anna",
      "EMAIL":"Anna@msn.com",
      "2":"Anna@msn.com",
      "GENDER":"f",
      "3":"f"
    }
  ]
}

谢谢

Answer 1

请参阅文档以获取解释:

http://php.net/manual/en/pdostatement.fetchall.php

为了只获取关联项，您应该将 PDO::FETCH_ASSOC 传递给您的 fetchAll。