Json decoding in php

Question

I have the following json line and I want to extract only the email address from it. How to do this in php?

{"communications":{"communication":[{"@array":"true","@id":"23101384","@uri":"xyz/v1/Communications/1111","household":{"@id":"111111","@uri":"xyz/v1/Households/5465465"},"person":{"@id":"","@uri":""},"communicationType":{"@id":"1","@uri":"xyz/v1/Communications/CommunicationTypes/1","name":"Home Phone"},"communicationGeneralType":"Telephone","communicationValue":"1111","searchCommunicationValue":"2693240758","listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:40:02"},{"@array":"true","@id":"11111","@uri":"xyz/v1/Communications/111111111","household":{"@id":"14436295","@uri":"xyz/v1/Households/11111"},"person":{"@id":"2222222","@uri":"xyz/v1/People/22222222"},"communicationType":{"@id":"2","@uri":"xyz/v1/Communications/CommunicationTypes/2","name":"Work Phone"},"communicationGeneralType":"Telephone","communicationValue":"11111","searchCommunicationValue":"789787987","listed":"false","communicationComment":null,"createdDate":"2009-08-09T15:49:27","lastUpdatedDate":"2009-08-11T23:40:02"},{"@array":"true","@id":"11111","@uri":"xyz/v1/Communications/11111","household":{"@id":"1111","@uri":"xyz/v1/Households/1111"},"person":{"@id":"244404","@uri":"xyz/v1/People/1111"},"communicationType":{"@id":"3","@uri":"xyz/v1/Communications/CommunicationTypes/3","name":"Mobile"},"communicationGeneralType":"Telephone","communicationValue":"22222","searchCommunicationValue":"5475454","listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:40:02"},{"@array":"true","@id":"15454","@uri":"xyz/v1/Communications/111111","household":{"@id":"14436295","@uri":"xyz/v1/Households/1111"},"person":{"@id":"244444474","@uri":"xyz/v1/People/111111"},"communicationType":{"@id":"4","@uri":"xyz/v1/Communications/CommunicationTypes/4","name":"Email"},"communicationGeneralType":"Email","communicationValue":" [e-mail] ","searchCommunicationValue":" [e-mail] ","listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:39:06"}]}} 

Answer 1

Another twist on how inerte would access it, for example:

 $json_object = '{"communications": {"communication": [{"@array":"true","@id":"23101384","@uri":"xyz/v1/Communications/1111","household": {"@id":"111111","@uri":"xyz/v1/Households/5465465"}, "person": {"@id":"","@uri":""}, "communicationType":{"@id":"1","@uri":"xyz/v1/Communications/CommunicationTypes/1","name":"Home Phone"}, "communicationGeneralType":"Telephone","communicationValue":"1111","searchCommunicationValue":"2693240758", "listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:40:02"}, {"@array":"true","@id":"11111","@uri":"xyz/v1/Communications/111111111","household": {"@id":"14436295","@uri":"xyz/v1/Households/11111"}, "person": {"@id":"2222222","@uri":"xyz/v1/People/22222222"}, "communicationType": {"@id":"2","@uri":"xyz/v1/Communications/CommunicationTypes/2","name":"Work Phone"}, "communicationGeneralType":"Telephone","communicationValue":"11111","searchCommunicationValue":"789787987","listed":"false", "communicationComment":null,"createdDate":"2009-08-09T15:49:27","lastUpdatedDate":"2009-08-11T23:40:02"}, {"@array":"true","@id":"11111","@uri":"xyz/v1/Communications/11111","household": {"@id":"1111","@uri":"xyz/v1/Households/1111"}, "person":{"@id":"244404","@uri":"xyz/v1/People/1111"}, "communicationType":{"@id":"3","@uri":"xyz/v1/Communications/CommunicationTypes/3","name":"Mobile"}, "communicationGeneralType":"Telephone","communicationValue":"22222","searchCommunicationValue":"5475454","listed":"true", "communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:40:02"}, {"@array":"true","@id":"15454","@uri":"xyz/v1/Communications/111111","household":{"@id":"14436295","@uri":"xyz/v1/Households/1111"}, "person":{"@id":"244444474","@uri":"xyz/v1/People/111111"}, "communicationType":{"@id":"4","@uri":"xyz/v1/Communications/CommunicationTypes/4","name":"Email"}, "communicationGeneralType":"Email","communicationValue":" [e-mail] ","searchCommunicationValue":" [e-mail] ","listed":"true", "communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:39:06"} ] } }'; $json_decoded = json_decode($json_object); echo "email: ".$json_decoded->communications->communication[3]->communicationValue."<br />"; 

Answer 2

Given that you are json_decode d you are like this:

 $data = json_decode($json); 

You can use var_dump (well, it looks better if used with Xdebug , which is nice to have on a development machine, by the way, to find out what's in your data:

 // Allows you to know what in the data ;-) var_dump($data); 

You will get something like this:

 object(stdClass)[1] public 'communications' => object(stdClass)[2] public 'communication' => array 0 => object(stdClass)[3] public '@array' => string 'true' (length=4) public '@id' => string '23101384' (length=8) public '@uri' => string 'xyz/v1/Communications/1111' (length=26) public 'household' => object(stdClass)[4] public '@id' => string '111111' (length=6) public '@uri' => string 'xyz/v1/Households/5465465' (length=25) public 'person' => object(stdClass)[5] public '@id' => string '' (length=0) public '@uri' => string '' (length=0) public 'communicationType' => object(stdClass)[6] public '@id' => string '1' (length=1) public '@uri' => string 'xyz/v1/Communications/CommunicationTypes/1' (length=42) public 'name' => string 'Home Phone' (length=10) public 'communicationGeneralType' => string 'Telephone' (length=9) public 'communicationValue' => string '1111' (length=4) public 'searchCommunicationValue' => string '2693240758' (length=10) public 'listed' => string 'true' (length=4) public 'communicationComment' => null public 'createdDate' => string '2008-11-10T12:31:26' (length=19) public 'lastUpdatedDate' => string '2009-08-11T23:40:02' (length=19) 1 => object(stdClass)[7] public '@array' => string 'true' (length=4) public '@id' => string '11111' (length=5) public '@uri' => string 'xyz/v1/Communications/111111111' (length=31) public 'household' => object(stdClass)[8] public '@id' => string '14436295' (length=8) public '@uri' => string 'xyz/v1/Households/11111' (length=23) public 'person' => object(stdClass)[9] public '@id' => string '2222222' (length=7) public '@uri' => string 'xyz/v1/People/22222222' (length=22) public 'communicationType' => object(stdClass)[10] public '@id' => string '2' (length=1) public '@uri' => string 'xyz/v1/Communications/CommunicationTypes/2' (length=42) public 'name' => string 'Work Phone' (length=10) public 'communicationGeneralType' => string 'Telephone' (length=9) public 'communicationValue' => string '11111' (length=5) public 'searchCommunicationValue' => string '789787987' (length=9) public 'listed' => string 'false' (length=5) public 'communicationComment' => null public 'createdDate' => string '2009-08-09T15:49:27' (length=19) public 'lastUpdatedDate' => string '2009-08-11T23:40:02' (length=19) 2 => object(stdClass)[11] public '@array' => string 'true' (length=4) public '@id' => string '11111' (length=5) public '@uri' => string 'xyz/v1/Communications/11111' (length=27) public 'household' => object(stdClass)[12] public '@id' => string '1111' (length=4) public '@uri' => string 'xyz/v1/Households/1111' (length=22) public 'person' => object(stdClass)[13] public '@id' => string '244404' (length=6) public '@uri' => string 'xyz/v1/People/1111' (length=18) public 'communicationType' => object(stdClass)[14] public '@id' => string '3' (length=1) public '@uri' => string 'xyz/v1/Communications/CommunicationTypes/3' (length=42) public 'name' => string 'Mobile' (length=6) public 'communicationGeneralType' => string 'Telephone' (length=9) public 'communicationValue' => string '22222' (length=5) public 'searchCommunicationValue' => string '5475454' (length=7) public 'listed' => string 'true' (length=4) public 'communicationComment' => null public 'createdDate' => string '2008-11-10T12:31:26' (length=19) public 'lastUpdatedDate' => string '2009-08-11T23:40:02' (length=19) 3 => object(stdClass)[15] public '@array' => string 'true' (length=4) public '@id' => string '15454' (length=5) public '@uri' => string 'xyz/v1/Communications/111111' (length=28) public 'household' => object(stdClass)[16] public '@id' => string '14436295' (length=8) public '@uri' => string 'xyz/v1/Households/1111' (length=22) public 'person' => object(stdClass)[17] public '@id' => string '244444474' (length=9) public '@uri' => string 'xyz/v1/People/111111' (length=20) public 'communicationType' => object(stdClass)[18] public '@id' => string '4' (length=1) public '@uri' => string 'xyz/v1/Communications/CommunicationTypes/4' (length=42) public 'name' => string 'Email' (length=5) public 'communicationGeneralType' => string 'Email' (length=5) public 'communicationValue' => string ' [e-mail] ' (length=18) public 'searchCommunicationValue' => string ' [e-mail] ' (length=18) public 'listed' => string 'true' (length=4) public 'communicationComment' => null public 'createdDate' => string '2008-11-10T12:31:26' (length=19) public 'lastUpdatedDate' => string '2009-08-11T23:39:06' (length=19) 

This means that you must have access to the data you are looking for, for example:

 foreach ($data->communications->communication as $communication) { if ($communication->communicationGeneralType == 'Email') { var_dump($communication->communicationValue); var_dump($communication->searchCommunicationValue); } } 

What do you get:

 string ' [e-mail] ' (length=18) string ' [e-mail] ' (length=18) 

" communications " is an object containing " communication ", which is an array of objects, each of which contains communicationGeneralType , which allows you to determine whether the current communication is EMail or not.

In this case, you can use the communicationValue or searchCommunicationValue .

And I really don't see a way to do this without repeating each communication element ...

Hope this helps!

Answer 3

You can use json_decode() . Your example line is a bit complicated for me to think about right now, but as an example of my own:

 $json = '{"a":"apples","b":["bananas","boysenberries"],"c":"carrots"}'; $arr = json_decode($json); echo $arr['a']; // "apples" echo $arr['b'][0]; // "bananas" 

Answer 4

 <?php $string = '{"communications":{"communication":[{"@array":"true","@id":"23101384","@uri":"xyz/v1/Communications/1111","household":{"@id":"111111","@uri":"xyz/v1/Households/5465465"},"person":{"@id":"","@uri":""},"communicationType":{"@id":"1","@uri":"xyz/v1/Communications/CommunicationTypes/1","name":"Home Phone"},"communicationGeneralType":"Telephone","communicationValue":"1111","searchCommunicationValue":"2693240758","listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:40:02"},{"@array":"true","@id":"11111","@uri":"xyz/v1/Communications/111111111","household":{"@id":"14436295","@uri":"xyz/v1/Households/11111"},"person":{"@id":"2222222","@uri":"xyz/v1/People/22222222"},"communicationType":{"@id":"2","@uri":"xyz/v1/Communications/CommunicationTypes/2","name":"Work Phone"},"communicationGeneralType":"Telephone","communicationValue":"11111","searchCommunicationValue":"789787987","listed":"false","communicationComment":null,"createdDate":"2009-08-09T15:49:27","lastUpdatedDate":"2009-08-11T23:40:02"},{"@array":"true","@id":"11111","@uri":"xyz/v1/Communications/11111","household":{"@id":"1111","@uri":"xyz/v1/Households/1111"},"person":{"@id":"244404","@uri":"xyz/v1/People/1111"},"communicationType":{"@id":"3","@uri":"xyz/v1/Communications/CommunicationTypes/3","name":"Mobile"},"communicationGeneralType":"Telephone","communicationValue":"22222","searchCommunicationValue":"5475454","listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:40:02"},{"@array":"true","@id":"15454","@uri":"xyz/v1/Communications/111111","household":{"@id":"14436295","@uri":"xyz/v1/Households/1111"},"person":{"@id":"244444474","@uri":"xyz/v1/People/111111"},"communicationType":{"@id":"4","@uri":"xyz/v1/Communications/CommunicationTypes/4","name":"Email"},"communicationGeneralType":"Email","communicationValue":" [e-mail] ","searchCommunicationValue":" [e-mail] ","listed":"true","communicationComment":null,"createdDate":"2008-11-10T12:31:26","lastUpdatedDate":"2009-08-11T23:39:06"}]}}'; $encoded = json_decode($string, JSON_FORCE_OBJECT); echo $encoded['communications']['communication'][3]['communicationValue']; echo "\n"; echo $encoded['communications']['communication'][3]['searchCommunicationValue']; ?> 

But if communicationValue or searchCommunicationValue ever leaves index 3 of communication , you have problems. You will probably have to loop communication and look for these lines by your keys / values.

Answer 5

Good example written by me

Pass json_object and 1 in the function, you will see all the values ​​in accordance with the structure.

 function decodejson($value,$num){ if (count($value,0) > 0 && is_array($value)){ foreach ($value as $key =>$tvalue){ if (is_array($tvalue)){ //echo $key."-<br />"; $num++; decodejson($tvalue,$num); }else echo str_repeat("&nbsp;", $num).$key."->".$tvalue."<br />"; } }else echo str_repeat("&nbsp;", $num).$key."->".$value."<br />"; }