Adding Array to MySQL Fetch

Question

I'm fetching results from my database (fetchAll), and later encoding it into json.

However, I want to add additional values to it, but I have no idea how to achieve that.

I tried doing this is:

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

But it wasn't working.

The result I'm after is changing the results from this:

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

to

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

What should I do? Thanks!

I want to add additional data to the currently fetched results (in array). — Jas
– Jas, Commented Feb 9, 2015 at 3:23

xdazz · Accepted Answer · 2015-02-09 03:24:15Z

4

Don't use fetchAll and while together.

Then:

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

Or:

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

answered Feb 9, 2015 at 3:24

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jas Over a year ago

Thank you! Works fine your way. :)

Collectives™ on Stack Overflow

Adding Array to MySQL Fetch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related