JSON parsing php issue

Question

I have this json response

 {"success":true,"results":[{"response":["random1"],"id":"6566","Limit":1},{"response":["random2"],"id":"6563","Limit":1},{"response":["random3"],"id":"6568","Limit":1}]}

All I need is to extract the random1,random2,random,3 from response so the final results will be:

random1
random2
random3

I have this script

$jsonData = file_get_contents("json");

$json = json_decode($jsonData,true); 

foreach($json["results"][0]["response"] as $data) {
 {
   echo json_encode($data);

}
}

But this will extract only

random1

If I change [0] in [1] will extract the random2 and [2] random3 How can I get random1,random2,random3, response at once? so the final echo will be:

random1
random2
random3

Thank you in advance, any help would be appreciated!

roullie · Accepted Answer · 2016-02-26 10:00:44Z

3

Loop at your $json['result'] what your doing is only taking the first index 0 which have random1 as its response value

$json = '{"success":true,"results":[{"response":["random1"],"id":"6566","Limit":1},{"response":["random2"],"id":"6563","Limit":1},{"response":["random3"],"id":"6568","Limit":1}]}';
$json = json_decode($json,true); 

foreach($json["results"] as $data) {
   echo $data['response'][0]."\n";
}

Try it here

Update

if you want to filter let's say random1 then do like this

$json = json_decode($json,true); 
$filter = array("random1"); //You can add items to filter
$result = array();
foreach($json["results"] as $data) {
   if(!in_array($data['response'][0],$filter))
       $result[] = $data;
}
print_r($result);

$result will contain only random2 & random3

edited Feb 26, 2016 at 10:00

answered Feb 26, 2016 at 8:50

roullie

2,82019 silver badges26 bronze badges

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

9 Comments

roullie Over a year ago

@AlexandruVorobchevici No problem. glad i helped. Make sure to accept answers for future references and help others with the same problem.

Alexandru Vorobchevici Over a year ago

Is any change to insert a word filter in this? so I can filter some words I have tried with if(strpos($data, 'random1') !== false) but won't work

roullie Over a year ago

@AlexandruVorobchevici what kind of words? random1 to random3?

Alexandru Vorobchevici Over a year ago

Let's say I wanna filter random1.. so the final result will be random2 and random3

Alexandru Vorobchevici Over a year ago

Fixed with foreach($json["results"] as $data) { if(preg_match('/^(badword)$/i',$data['results'][0])) continue; echo $data['answers'][0]."\n"; } Thank you again for your help!

|

Sky · Accepted Answer · 2016-02-26 08:50:48Z

0

results is an array, so you got the first one in the array by this: $json["results"][0].

If you want to iterate all the values, it should be like this:

foreach($json["results"] as $data) {
   echo json_encode($data['response']);

}

answered Feb 26, 2016 at 8:50

Sky

7,7478 gold badges33 silver badges49 bronze badges

Comments

Sushant Yadav · Accepted Answer · 2016-02-26 12:38:41Z

0

foreach($json["results"] as $data) {    echo json_encode($data['response']);}

edited Feb 26, 2016 at 12:38

Sushant Yadav

7261 gold badge14 silver badges28 bronze badges

answered Feb 26, 2016 at 8:53

keerti Sawlani

2331 silver badge9 bronze badges

Collectives™ on Stack Overflow

JSON parsing php issue

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related