php - 将数组添加到 MySQL Fetch

Question

我正在从我的数据库 (fetchAll) 中获取结果，然后将其编码为 json。

但是，我想为其添加额外的值，但我不知道如何实现。

我试过这样做是:

while ($posts = $database->fetchAll()) {
    $posts['additional'] = 'test';
}

但它不起作用。

我想要的结果是改变结果:

[
    {"firstName":"John", "lastName":"Doe"}, 
    {"firstName":"Anna", "lastName":"Smith"}, 
    {"firstName":"Peter", "lastName":"Jones"}
]

到

[
    {"firstName":"John", "lastName":"Doe", "additional":"test"}, 
    {"firstName":"Anna", "lastName":"Smith", "additional":"test"}, 
    {"firstName":"Peter", "lastName":"Jones", "additional":"test"}
]

我该怎么办？谢谢!

Answer 1

不要将 fetchAll 和 while 一起使用。

然后:

$posts = array();
while ($post = $database->fetch()) {
    $post['additional'] = 'test';
    $posts[] = $post;
}

或者:

$posts = $database->fetchAll();
foreach ($posts as &$post) {
  $post['additional'] = 'test';
}