Parse json and convert it to php array

Question

I am trying to echo a value from google map json url. I can var_dump() the keys and the values but I can't pull the specific value alone. Php code:

<?php
    $from = 'Piccadilly+Circus+London+UK';
    $to = 'Brighton+Railway+Station+Brighton+UK';
    $json ='https://maps.googleapis.com/maps/api/distancematrix/json?origins='.$from.'&destinations='.$to.'&mode=driving&key=APIKEY';
    $ch = curl_init($json);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    $data = curl_exec($ch);
    curl_close($ch);

    // Print Result
    echo '<pre>' . var_dump($data) . '</pre>';

?>

The var_dump() result is as follows;

       string(542) "{
       "destination_addresses" : [ "Brighton, Queens Rd, Brighton BN1 3XP, UK" ],
       "origin_addresses" : [ "Piccadilly Circus, London W1B, UK" ],
       "rows" : [
          {
             "elements" : [
                {
                   "distance" : {
                      "text" : "86.7 km",
                      "value" : 86665
                   },
                   "duration" : {
                      "text" : "1 hour 59 mins",
                      "value" : 7114
                   },
                   "status" : "OK"
                }
             ]
          }
       ],
       "status" : "OK"
    }
    "

I need to assign distance->text to a php variable. Could anyone help?

You need to use json_decode to make that an array.

Daerik
– Daerik

2019-02-22 21:10:47 +00:00
Commented Feb 22, 2019 at 21:10 — Daerik
– Daerik, Commented Feb 22, 2019 at 21:10
secure.php.net/manual/en/function.json-decode.php

Sammitch
– Sammitch

2019-02-23 02:14:48 +00:00
Commented Feb 23, 2019 at 2:14 — Sammitch
– Sammitch, Commented Feb 23, 2019 at 2:14

toh19 · Accepted Answer · 2019-02-22 21:17:23Z

1

Try this:

$variable = json_decode($data)->rows[0]->elements[0]->distance->text;

answered Feb 22, 2019 at 21:17

toh19

1,23912 silver badges24 bronze badges

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

Comments

Vidal · Accepted Answer · 2019-02-22 21:59:05Z

0

In order to convert the json to a php array variable you can use json_decode($data, true) with the second parameter to true, to convert it to an associative array.

code example.

$json = json_decode($date,true);

print  $jsonp['rows'][0]['elements']['0']['distance']['value'];

Doc. http://php.net/manual/en/function.json-decode.php

Hope it helps.

answered Feb 22, 2019 at 21:59

Vidal

2,6062 gold badges20 silver badges35 bronze badges

Collectives™ on Stack Overflow

Parse json and convert it to php array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related