php - 如何获取按列名索引的数组？

Question

我有这个:

$pdo = new PDO("mysql:host=$host;dbname=$databaseName;charset=utf8", $user, $pass);
$query = "SELECT name FROM $tableName";
$stm = $pdo->prepare($query);
$stm->execute();
$array = $stm->fetchAll();
$firephp->log($array);
echo json_encode($array);

ajax 的结果是:

[{"name":"mike","0":"mike"},{"name":"john","0":"john"},{"name":"tito","0":"tito"}]

但我想得到这个:

{"name":[{"mike","john","tito"}]}

哪个 PDO fetch_style 或者我应该在 PHP 中做什么来接收我想要的 jQuery 字符串？

非常感谢。

Answer 1

$array = $stm->fetchAll(PDO::FETCH_COLUMN, 0);
echo json_encode(array('name' => $array));