json_encode on a two-dimensional array

Question

I have a problem using JSON and arrays.

Here is my code:

while($row = mysql_fetch_assoc($result)){ echo json_encode($row); }

The result is:

{"id":"1","title":"event1","start":"2009-11-10 14:18:15","end":"2009-11-03 14:38:22","allDay":"false","url":null}{"id":"2","title":"event2","start":"2009-11-09 15:41:20","end":"2009-11-10 16:41:25","allDay":"false","url":null}

But I want the result to look like this:

[{"id":"1","title":"event1","start":"2009-11-10 14:18:15","end":"2009-11-03 14:38:22","allDay":"false","url":null},{"id":"2","title":"event2","start":"2009-11-09 15:41:20","end":"2009-11-10 16:41:25","allDay":"false","url":null}]

How can I accomplish this?

viam0Zah · Accepted Answer · 2009-11-03 15:19:01Z

8

$arr = array();
while($row = mysql_fetch_assoc($result)) {
    $arr[] = $row; 
}
echo json_encode($arr);

answered Nov 3, 2009 at 15:19

viam0Zah

26.4k8 gold badges79 silver badges103 bronze badges

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

Comments

brettkelly · Accepted Answer · 2009-11-03 15:24:42Z

0

$myjsons = array();
while($row = mysql_fetch_assoc($result)){ 
    $myjsons[] = json_encode(array($row)); 
}
print_r($myjsons);

edited Nov 3, 2009 at 15:24

answered Nov 3, 2009 at 15:16

brettkelly

28.3k8 gold badges58 silver badges73 bronze badges

Collectives™ on Stack Overflow

json_encode on a two-dimensional array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related