Appropriate way to output SQL Result Array in JSON

Question

I'm outputting my DB result like this:

foreach($result as $row) {
    echo json_encode($row);
}

This outputs the following:

{"nummer":"600","name":"Location Name 600"}{"nummer":"698","name":"Location Name 698"}{"nummer":"1110","name":"Location Name 1110"}

Is this the right way? Do I have to seperate the result rows from each other?

Edit: If I get a callback id from jquery, what way would I format this into jsonp? To be more specific, I'd like to put an value containing the total amount of results, and then all results found, in jsonp (jquery sends me the id for a callback, which I'll have to put into the output).

This isnt valid JSON - you can check here and what is $result ? — Manse
– Manse, Commented May 4, 2012 at 8:15
It's the result array from a database query (2D Array, first array is numeric, second array is associative) — Ahatius
– Ahatius, Commented May 4, 2012 at 8:18

C. Leung · Accepted Answer · 2012-05-04 08:14:24Z

3

simply...

echo json_encode($result);

answered May 4, 2012 at 8:14

C. Leung

6,3283 gold badges22 silver badges32 bronze badges

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

1 Comment

Ahatius Over a year ago

Wow, that was easy. Thanks alot!

Collectives™ on Stack Overflow

Appropriate way to output SQL Result Array in JSON

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