我从数据库中获取结果(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"}
]
我该怎么办?谢谢
不要同时使用fetchAll
和while
。
然后:
$posts = array();
while ($post = $database->fetch()) {
$post['additional'] = 'test';
$posts[] = $post;
}
或者:
$posts = $database->fetchAll();
foreach ($posts as &$post) {
$post['additional'] = 'test';
}