Adding items to a JSON encoded array

Question

I am using this solution found on stackoverflow to encode my MYSQL output to a JSON encoded array.

$sth = mysql_query("SELECT ...");

$rows = array();

    while($r = mysql_fetch_assoc($sth)) {
        $rows[] = $r;
    }

print json_encode($rows);

This works great and produces an output of

[{"id":"81","title":"Something Here","start":"2009-10-27 09:00:00"},{"id":"77","title":"Report on water","start":"2009-10-30 09:00:00"}]

Now I need to put a value of say

"colour":"Blue"

within the JSON encoded array.

So i need the ouput to look like

[{"id":"81","title":"Community Awareness","start":"2009-10-27 09:00:00", "colour":"Blue"},{"id":"77","title":"Write a 10,000 Page Report on Emma","start":"2009-10-30 09:00:00", "colour":"Blue"}]

Does anyone have any solutions on how I could achieve this?

Thanks,

Tim Mohr

Matt · Accepted Answer · 2009-11-18 02:28:11Z

5

Before you call json_encode($rows), just edit the value in the $rows array:

$rows[0]['colour'] = 'Blue'; // changes the colour of the first row in the array

edit in fact, if you just want to add a colour to all of the rows, you can do a simple foreach:

foreach ($rows as &$row) {
    $row['colour'] = 'Blue';
}

answered Nov 18, 2009 at 2:28

Matt

44.1k6 gold badges105 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

Adding items to a JSON encoded array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related