json_encode on a two-dimensional array

16,152
$arr = array();
while($row = mysql_fetch_assoc($result)) {
    $arr[] = $row; 
}
echo json_encode($arr);
Share:
16,152
SUN Jiangong
Author by

SUN Jiangong

Updated on June 26, 2022

Comments

  • SUN Jiangong
    SUN Jiangong almost 2 years

    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?