Trim data from JSON that doesn't include defined array?

Question

There's JSON data with Offers

foreach($json['offers'] as $offer)

Every offer has data that contains country

"countries":[{"name":"United States","code":"US"}]

How do I remove all the offers if they dont include for example "US"?

As far as I understand I should use array_map right? But how do I tell it to remove those that doesn't include value instead of those who does include value I define?

array_map() is for changing (all) data. You want array_filter(). — Dormilich
– Dormilich, Commented Nov 28, 2018 at 8:51
as @Dormilich you should use array_filter - var_dump(array_filter($offers, function($offer) { return ('US' === $offer['countries'][0]['code'] ?? null); })); — myxaxa
– myxaxa, Commented Nov 28, 2018 at 8:59

Mohammad · Accepted Answer · 2018-11-28 09:05:35Z

1

You need to use array_filter()

$json['offers'] = array_filter($json['offers'], function($item){
    return $item['countries'][0]['code'] == "US";
});

Check result in demo

answered Nov 28, 2018 at 9:05

Mohammad

21.5k16 gold badges58 silver badges86 bronze badges

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

Comments

A l w a y s S u n n y · Accepted Answer · 2018-11-28 09:07:12Z

0

If I don't misunderstood your question, then simple array_filter() will do the trick for you.

<?php

$json = '[{"countries":[{"name":"United States","code":"US"}]},{"countries":[{"name":"United Kingdom","code":"UK"}]},{"countries":[{"name":"Canada","code":"CA"}]}]';
$decode = json_decode($json,1);
$new = array_filter($decode, function ($var) {
    return ($var['countries'][0]['code'] != 'US');
});
print_r($new);
?>

DEMO: https://3v4l.org/LtPEl

answered Nov 28, 2018 at 9:07

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

Comments

ML Studios · Accepted Answer · 2018-11-28 09:37:14Z

0

Thank you guys for answers, but I've did it in another way..

$salys2 = array("US");      
$salys = array_map('trim', $salys2);    


if (!in_array($offer['countries'][0]['code'], $salys)) {

    // skipping
    continue;
}

Could someone explain me why are we keeping [0] between countries and code?

answered Nov 28, 2018 at 9:37

ML Studios

311 silver badge6 bronze badges

Collectives™ on Stack Overflow

Trim data from JSON that doesn't include defined array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related