How to parse json in php?

Question

I am trying to parse this json '{"options":"[{\"order\":\"1\"},{\"skill\":\"\\n wajghjk \"},{\"order\":\"2\"},{\"skill\":\"\\n aswedrty \"},{\"order\":\"3\"},{\"skill\":\"\\n skill1 \"},{\"order\":\"4\"},{\"skill\":\"\\n wasedjk \"},{\"order\":\"5\"},{\"skill\":\"\\n Feldsher \"},{\"order\":\"6\"},{\"skill\":\"\\n wasedjk \"},{\"order\":\"7\"},{\"skill\":\"\\n Autotransfusionist \"},{\"order\":\"8\"},{\"skill\":\"\\n Feldsher \"},{\"order\":\"9\"},{\"skill\":\"\\n Autotransfusionist \"}]"}' . using the code

<?php
$json = '{"options":"[{\"order\":\"1\"},{\"skill\":\"\\n                        wajghjk                    \"},{\"order\":\"2\"},{\"skill\":\"\\n                        aswedrty                    \"},{\"order\":\"3\"},{\"skill\":\"\\n                        skill1                    \"},{\"order\":\"4\"},{\"skill\":\"\\n                        wasedjk                    \"},{\"order\":\"5\"},{\"skill\":\"\\n                        Feldsher                    \"},{\"order\":\"6\"},{\"skill\":\"\\n                        wasedjk                    \"},{\"order\":\"7\"},{\"skill\":\"\\n                        Autotransfusionist                    \"},{\"order\":\"8\"},{\"skill\":\"\\n                        Feldsher                    \"},{\"order\":\"9\"},{\"skill\":\"\\n                        Autotransfusionist                    \"}]"}';

$decode = json_decode($json, true);
$a=array();
echo '<br/>';
foreach($decode['options'] as $a)
{
    echo $a['order'];echo '<br/>';
     echo $a['skill'];echo '<br/>';
}
?>

But it is showing error and not able to parse . Is there any better way to get the values of order and skill from this json ?

if you paste it in jsonviewer.stack.hu you'll see what you have isn't well-formed JSON. — Brad Christie
– Brad Christie, Commented Jul 23, 2013 at 12:20
Iam getting the error as Warning: Invalid argument supplied for foreach() on line 12 — anu
– anu, Commented Jul 23, 2013 at 12:24

Bart Friederichs · Accepted Answer · 2013-07-23 12:18:56Z

3

That's not JSON. You are escaping too many double quotes.

answered Jul 23, 2013 at 12:18

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

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

1 Comment

Zim84 Over a year ago

Check this out to see whether you have valid JSON or not: json.parser.online.fr

Tim · Accepted Answer · 2013-07-23 12:19:08Z

1

You're escaping your double quotes, which will come out as literal \ characters when the string is delimited by single quotes.

Either run stripslashes on the json string, or avoid the escaping in the first place.

answered Jul 23, 2013 at 12:19

Tim

8,7062 gold badges42 silver badges55 bronze badges

Comments

Ruslan Bes · Accepted Answer · 2013-07-23 12:32:16Z

You have two problems with the json string.

You escape double quotes inside single-quoted string. But single-quoted string has only one escape sequence and that is \'. Check this article.
You have a problem here: '{"options":"[{...}]"}'. You enclosed javascript [array] with quotes, which turned it into a string.

The correct json should look like this:

{"options":[{"order":"1"},{"skill":"\\n wajghjk "},{"order":"2"},{"skill":"\\n aswedrty "},{"order":"3"},{"skill":"\\n skill1 "},{"order":"4"},{"skill":"\\n wasedjk "},{"order":"5"},{"skill":"\\n Feldsher "},{"order":"6"},{"skill":"\\n wasedjk "},{"order":"7"},{"skill":"\\n Autotransfusionist "},{"order":"8"},{"skill":"\\n Feldsher "},{"order":"9"},{"skill":"\\n Autotransfusionist "}]}

Eval.in demo

Your Common Sense · Accepted Answer · 2013-07-23 12:33:28Z

1

it is showing error and not able to parse .

PHP is quite weak in debugging json. All you can do is

$json_errors = array(
    "",
    "The maximum stack depth has been exceeded",
    "Invalid or malformed JSON",
    "Control character error, possibly incorrectly encoded",
    "Syntax error",
    "Malformed UTF-8 characters, possibly incorrectly encoded",
);

$decode = json_decode($json, true);
if ($error = json_last_error())
{
    trigger_error($json_errors[$error]);
}

Though, in order to get values you have to have a valid json string, not just arbitrary string consists of some quotes and slashes.

And of course you should never ever create a json string manually.

answered Jul 23, 2013 at 12:33

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Collectives™ on Stack Overflow

How to parse json in php?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related