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

Question

Why does the JSON output show both the index number and the association colume name?

I only need just column name such as "UID"

PHP CODE

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

JSON OUTPUT

{
  "Record":[
    {
      "UID":"1001",
      "0":"1001",
      "NAME":"Robot2",
      "1":"Robot2",
      "EMAIL":"[e-mail]",
      "2":"[e-mail]",
      "GENDER":"f",
      "3":"f"
    },
    {
      "UID":"1030",
      "0":"1030",
      "NAME":"Anna",
      "1":"Anna",
      "EMAIL":"[e-mail]",
      "2":"[e-mail]",
      "GENDER":"f",
      "3":"f"
    }
  ]
}

Thanks

Answer 1

See the documentation for an explaination:

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

In order to only get the associative items, you should pass PDO::FETCH_ASSOC to your fetchAll.