Parsing nested json array value in php

Question

I am trying to parse the data from the following json

{
"id":"1",
"rawId":"1",
"displayName":"Distress Number",
"name":{"familyName":"Number","formatted":"Distress Number","givenName":"Distress"},
"nickname":null,
"phoneNumbers":[{"type":"other","value":"112","id":"2","pref":false}],
"emails":[{"type":"other","value":"[email protected]","id":"19","pref":false}],
"addresses":null,
"ims":null,"organizations":null,
"birthday":null,
"note":"","photos":null,
"categories":null,
"urls":null
}

I want to insert the displaName,phoneNumbers and emails to database table but its failed Here is my php

$contact=json_decode($json,true){
    foreach($contact as $con){

         $num=$con['phoneNumbers']['value'];
        $name=$con['displayName'];
        $email=$con['emails']['value'];
         //function to dbinsert 
        insertToDb($num,$name,$email);
     }

But it returns illegal offset warning

I don't understand how your data are structured. Is there only one record? — Phate01
– Phate01, Commented Mar 4, 2015 at 10:15

Devesh · Accepted Answer · 2015-03-04 10:06:54Z

0

It should be like this , phoneNumbers and emails are again the json array you need to parse

        $contact=json_decode($json,true);
        foreach($contact as $con){
        $num=$con['phoneNumbers'][0]['value'];
        $name=$con['displayName'];
        $email=$con['emails'][0]['value'];
     //function to dbinsert 
        insertToDb($num,$name,$email);
        }

answered Mar 4, 2015 at 10:06

Devesh

4,5501 gold badge20 silver badges28 bronze badges

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

Comments

Phate01 · Accepted Answer · 2015-03-04 09:58:08Z

0

You are calling json_decode in the wrong way. Try to do like this:

$contact=json_decode($json,true);
foreach($contact as $con) {

    $num=$con['phoneNumbers']['value'];
    $name=$con['displayName'];
    $email=$con['emails']['value'];

    insertToDb($num,$name,$email);
 }

answered Mar 4, 2015 at 9:58

Phate01

1,8573 gold badges34 silver badges58 bronze badges

2 Comments

Phate01 Over a year ago

I think this json_decode($json,true) { is incorrect. The bracket in particular

Blessan Kurien Over a year ago

i wiil get displayName but not $num and $name

Collectives™ on Stack Overflow

Parsing nested json array value in php

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related