How to parse a JSON string using PHP

Question

I have a JSON string that has 1-n numbers of lat/lng records. It looks something like this:

{\"lat\":37.790388261934424,\"lng\":-122.46047996826172},{\"lat\":37.789608231530124,\"lng\":-122.46344112701416}

What is a good way to parse this to get lat/lng values loop? And do the escaped double quotes impact the parsing?

Thanks, Alex

Solution 1

$ll = '[{"lat":37.790388261934424,"lng":-122.46047996826172},{"lat":37.789608231530124,"lng":-122.46344112701416}]';
$ll = json_decode($ll);
print_r($ll);

Prints...

Array
(
    [0] => stdClass Object
        (
            [lat] => 37.7903882619
            [lng] => -122.460479968
        )

    [1] => stdClass Object
        (
            [lat] => 37.7896082315
            [lng] => -122.463441127
        )

)

Solution 2

Use json_decode.

You will need to unescape quotes first; just use

$unescaped_data = str_replace('\"','"',$data)

Solution 3

In your case it's probably best to use:

$array = json_decode(stripslashes("[$input_string]"), 1);

Note that you will lose some precision on your float values in PHP.

Solution 4

JSON_decode and remove escape quotes

View more solutions

Comments

[Marc B]

@lucifurious: probably because magic_quotes_gpc is turned on.

[ysrb]

try json_decode

[lucifurious]

Why does it have those slashes in it??

[mickmackusa]

This is not enough. The input string would still not be valid json after calling str_replace().