json_decode(json_encode(an indexed array)) gives NULL

Question

i encode the user entred testarea content with json_encode here is how it storred in mysql (there is a return to line after "aaa")

{"content":"aaa
bbb"}

now when i get the the content from database and trying to decoded it using json_decode, i get NULL for this, instead of what expected.

what wrrong? a bug in PHP?

EDIT 1: more details

$data =array('content'=>$textareaText);
$addres_insert = "INSERT INTO `rtable` (`data`) VALUES ('".json_encode($data)."');";
$rows = mysql_query($addres_insert);

then to get the content

$query = "SELECT * FROM  `rtable` WHERE id =  '".$id."'";
        $rows = mysql_query($query);
    if ( $rows ){
        $row = mysql_fetch_array($rows);
        $res['data'] = json_decode($row['data']);//i tryed substr($row['data'],3) but didn't work
    }

It could be utf8. Check stackoverflow.com/questions/689185/json-decode-returns-null-php for almost same discussion. — Kerhong
– Kerhong, Commented Dec 2, 2011 at 8:47

Community · Accepted Answer · 2017-05-23 12:20:12Z

4

JavaScript and JSON do not allow line returns to be contained within a string. You need to escape them.

json_encode() should escape them automatically for you.

Here is the output of my playing with your JSON code supplied on the PHP interactive shell:

php > $json = '{"content":"aaa
php ' bbb"}';
php > var_dump(json_decode($json, true));
NULL

As you can see when I escape your line return it works just fine:

php > $json = '{"content":"aaa\n bbb"}';
php > var_dump(json_decode($json, true));
array(1) {
  ["content"]=>
  string(8) "aaa
 bbb"
}

This is also further discussed in a previous question relating to a similar problem: Problem when retrieving text in JSON format containing line breaks with jQuery

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Dec 2, 2011 at 8:49

Treffynnon

21.6k6 gold badges68 silver badges99 bronze badges

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

1 Comment

Hassan Over a year ago

excelent , so for sur the content i get from mysql should be escaped too with some php fucntion . thanks

Collectives™ on Stack Overflow

json_decode(json_encode(an indexed array)) gives NULL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related