Format my output JSON more Readable

Question

This is my current PHP code

while ($row = mysql_fetch_array($result)) 
    {
        $post = new Post();
        $post->setId($row['post_id']); 
        $post->setBody($row['post_body']); 
        $post->setImage($row['post_imgurl']);
        $post->setStamp($row['post_stamp']);
        $postList[]  = $post;
    }
    return array('post'=> $postList);
}

and this is its output JSON. How can i make my JSON more readable like below and remove / the character?

More readable output:

ExtraCharacterandJSONFormat

More readable where? What's the real issue here? The / needs to be escaped in a JSON string, that's how it works (see: json.org) — gen_Eric
– gen_Eric, Commented Nov 15, 2013 at 17:12
If you don't escape the backslashes, it won't be valid JSON. What does it look like when you actually output the image value? — user399666
– user399666, Commented Nov 15, 2013 at 17:12
The / doesn't need to be escaped (\ does), but it does no harm if you do. PHP escapes them so that having </script> in a string literal will become <\/script> and thus won't terminate a script block if you use the JSON as JavaScript in HTML. — Quentin
– Quentin, Commented Nov 15, 2013 at 17:15
thank you guys. this is the current output of my JSON i.sstatic.net/Ue4Aa.png and i want to make it i.sstatic.net/Gwkz1.png :) — Toshi
– Toshi, Commented Nov 15, 2013 at 17:17

Quentin · Accepted Answer · 2013-11-15 17:16:55Z

4

If you want readable JSON, then read it in a tool designed to present JSON for reading (such as the Chrome JSONView extension). Don't try to munge raw data into particular patterns.

That said, you can persuade PHP to munge the data in that fashion with:

json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);

answered Nov 15, 2013 at 17:16

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

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

Comments

Yarik Dot · Accepted Answer · 2013-11-15 17:15:56Z

0

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

Please, take a look at the $options param of the json_encode function, I am sure, it solves your problem.

answered Nov 15, 2013 at 17:15

Yarik Dot

1,1331 gold badge7 silver badges12 bronze badges

1 Comment

Barmar Over a year ago

In particular, JSON_UNESCAPED_SLASHES

Collectives™ on Stack Overflow

Format my output JSON more Readable

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related