shall i retrieve database records with JSON ?

Question

i'm a little bit confused here. i've PHP file that retrieve database records . i'll call it with an Ajax call from my frontend . do i need to convert the records to JSON ? if no when do i need to do that

Similar: http://stackoverflow.com/questions/4881876/why-need-to-use-json-in-php-and-ajax/4881898#4881898 — Chris Laplante, Aug 16 '11 at 18:52
my apologize !! that question is exactly what i need . close the topic or delete it if u want ! Apologize again — Iyad Al aqel, Aug 16 '11 at 19:01

score 2 · Accepted Answer · edited May 23 '17 at 12:26

You don't "need" to return the results as JSON. But I would recommend it. JSON is very portable, so it will be easier for other applications to interact with your application. It's also much easier to parse JSON than it is records separated by simple delimiters.

For example, you can use Crockford's JSON parser: http://www.json.org/js.html

As for JSON vs XML: Why need to use JSON in php and AJAX

score 1 · Answer 2 · answered Aug 16 '11 at 18:50

1

You don't have to use JSON but you can encode any associative array using the function json_encode:

http://php.net/manual/en/function.json-encode.php

answered Aug 16 '11 at 18:50

Doug Molineux

12,283
25
92
144

score 0 · Answer 3 · answered Aug 16 '11 at 18:50

If your client is requesting the data in JSON format, then it's probably best to take the results from your database call and convert them to a JSON-formatted string before returning it to your client.

But your client's AJAX call could also be requesting the data in XML format, too.

So the answer depends on what the client is expecting.

shall i retrieve database records with JSON ?

3 Answers3