json from string to array using php

Question

I have a problem with json parsing. I have already read the many questions here on stackoverflow but I can't figured out what I'm missing.

In my site I use Facebook Api to post my feed using curl and it respond with a json message. I take this response and I save it in my database.
In my Backoffice I need to retrieve this message and print it in case of error.

Here an example about an error message:

{"error":{"message":"(#1500) The url you supplied is invalid","type":"OAuthException","code":1500}}

In my php page I need to get just the message part so I did:

$message = get from the db and fetch;
$error_array = json_decode($message,true);
print_r($error_array);

but it doesn't print anything, just a blank page.
If I just print $message I can see the entire string.

What am I missing? This issue it's driving me crazy all day long!!

You do not have JSON functionality enabled for your PHP installation — Hanky Panky
– Hanky Panky, Commented Oct 30, 2013 at 13:06
The problem was a bad encoding of the data when I retrieve it from the DB. — Christian Giupponi
– Christian Giupponi, Commented Oct 30, 2013 at 13:16

Latheesan · Accepted Answer · 2013-10-30 13:07:01Z

2

I tried the following:

<pre>
<?php

$jsonStr = '{"error":{"message":"(#1500) The url you supplied is invalid","type":"OAuthException","code":1500}}';

$error_array = json_decode($jsonStr, true);

print_r($error_array);

?>

and getting output:

Array
(
    [error] => Array
        (
            [message] => (#1500) The url you supplied is invalid
            [type] => OAuthException
            [code] => 1500
        )
)

It's working as intended.

I suspect the problem is with this:

$message = get from the db and fetch;

After you load the $message variable, do a var_dump($message) and see if the string is in there (as expected).

answered Oct 30, 2013 at 13:07

Latheesan

24.1k34 gold badges113 silver badges212 bronze badges

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

3 Comments

Laurynas Mališauskas Over a year ago

it is the answer. your provided JSON string is perfectly valid. so the only reason your code does not work is that you get the wrong output from your DB. Possibly because of html entity encoding or something similar

Latheesan Over a year ago

if he doesn't have json_encode or json_decode functionality in his PHP, he would have gotten a function not exists error - which would have been shown on page (if display_error is on) or logged to file (if error_log is enabled).

Christian Giupponi Over a year ago

Thanks Latheesan Kanes the problem was the encoded string, when I retrieve the data from the db I get the double quotes parsed so it caused the errors. Thanks again

tailor · Accepted Answer · 2013-10-30 13:08:57Z

0

$jsonString = '["[email protected]","[email protected]","[email protected]"]'; $arrayOfEmails=json_decode($jsonString);

Or

$jsonString = "[\"[email protected]\",\"[email protected]\",\"[email protected]\"]"; $arrayOfEmails=json_decode($jsonString);

answered Oct 30, 2013 at 13:08

tailor

3763 gold badges6 silver badges20 bronze badges

Collectives™ on Stack Overflow

json from string to array using php

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related