Parsing JSON file in php

Question

2.00/5 (1 vote)

See more:

Hi All,

I want to parse a JSON files which contains data in the format as shown below,

[
{
"Country": "United States"
"States": [
{
"Cities": [
"Abbeville",
"Abernant",
"Adamsville",
"Addison"
],
"State": "AL"
},
{
"Cities": [
"Adak",
"Akiak",
"Akutan",
"Ambler"
],
"State": "AK"
},
]
},
{
"Country": "Canada"
"States": [
{
"Cities": [
"Barrie",
"Belleville",
"Brampton",
"Brant"
],
"State": "ON"
},
{
"Cities": [
"Acton Vale",
"Alma",
"Amos",
"Amqui",
"Asbestos"
],
"State": "QC"
},
]
}

]

From above JSON format, I want to get list of all Country names, State names,City Names.

First,I want all the country names list. Then when I pass country name as "Canada" then all its states should be fetched and so on to get the city names of respective country ,state and city.

Posted 3-Jul-13 9:06am

Phionix11

Add a Solution

3 solutions

Solution 1

Please see:
http://php.net/manual/en/book.json.php[^],
http://php.net/manual/en/function.json-decode.php[^].

—SA

Posted 3-Jul-13 9:19am

Sergey Alexandrovich Kryukov

Solution 2

First, read your json data into a string.

PHP

$strJson = file_get_contents('data.json');

Second, decode the json data into an array variable

PHP

$arrJson = json_decode($strJson);

Posted 3-Jul-13 16:39pm

thanh_bkhn

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Phionix11 · Accepted Answer · 2013-07-04T02:49:00

Below is the code that I have used to solve my problem,

Condition 1] To get list of all countries

$jsonDecode=json_decode(file_get_contents(file_get_contents("D:\abc.json")),true);
$result=array();

foreach($jsonDecode as $countries)
{
$result[]=$countries{'Country'};
}
=============================
Condition 2] If Country name is passed then get all states list

$jsonDecode=json_decode(file_get_contents(file_get_contents("D:\abc.json")),true);
$result=array();

foreach($jsonDecode as $countries)
{
if($countries{'Country'}==$countryName)
{
foreach($countries{'States'} as $states)
{
$result[]=$states{'State'};
}
}
}
=============================
Condition 3] If Country,State is passed then get Cities list

$jsonDecode=json_decode(file_get_contents(file_get_contents("D:\abc.json")),true);
$result=array();

foreach($jsonDecode as $countries)
{
if($countries{'Country'}==$countryName)
{
foreach($countries{'States'} as $states)
{
if($states{'State'}==$stateName)
{
foreach($states{'Cities'} as $cities)
{
$result[]=$cities;
}
}
}
}
}