Removing items from an array based on items in another array

Question

I have 2 arrays:

Array ( [0] => Array ( [intTrackId] => 41 [intAverageRating] => 10 [bolNewRelease] => 0 [dtDateAdded] => 2013-03-08 17:32:26 ) [1] => Array ( [intTrackId] => 1 [intAverageRating] => 7 [bolNewRelease] => 0 [dtDateAdded] => 2013-03-08 18:54:35 ))

Array ( [0] => Array ( [intTrackId] => 41 [intAverageRating] => 5.5000 [bolNewRelease] => 1 [dtDateAdded] => 2014-03-25T09:39:28Q ) [1] => Array ( [intTrackId] => 361 [intAverageRating] => 8.0000 [bolNewRelease] => 1 [dtDateAdded] => 2014-03-25T09:39:28Q ))

I want to remove the items in the second which have a matching track ID in the first. So in this example, I would get:

Array ( [0] => Array ( [intTrackId] => 361 [intAverageRating] => 8.0000 [bolNewRelease] => 1 [dtDateAdded] => 2014-03-25T09:39:28Q ))

Is this possible with array_filter or is this a little complex for that?

Use array_diff(); stackoverflow.com/a/11821824/2768999

effone
– effone

2014-03-25 09:51:14 +00:00
Commented Mar 25, 2014 at 9:51 — effone
– effone, Commented Mar 25, 2014 at 9:51

Community · Accepted Answer · 2023-11-17 20:33:26Z

1

Just use array_udiff() - it's intended to do this:

$one = Array (
   0 => Array ('intTrackId' => 41, 'intAverageRating' => 10, 'bolNewRelease' => 0, 'dtDateAdded' => '2013-03-08 17:32:26' ), 
   1 => Array ('intTrackId' => 1, 'intAverageRating' => 7, 'bolNewRelease' => 0, 'dtDateAdded' => '2013-03-08 18:54:35' )
);

$two = Array ( 
   0 => Array ('intTrackId' => 41, 'intAverageRating' => 5.5000, 'bolNewRelease' => 1, 'dtDateAdded' => '2014-03-25T09:39:28Q' ), 
   1 => Array ('intTrackId' => 361, 'intAverageRating' => 8.0000, 'bolNewRelease' => 1, 'dtDateAdded' => '2014-03-25T09:39:28Q' )
);


$result = array_udiff($two, $one, function($x, $y)
{
   return $x['intTrackId']-$y['intTrackId'];
});

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Mar 25, 2014 at 9:51

Alma Do

37.4k10 gold badges81 silver badges106 bronze badges

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

Comments

MrCode · Accepted Answer · 2014-03-25 09:50:09Z

1

Yes it can be done with array_filter:

$array1 = array(...);
$array2 = array(...);

$newArray = array_filter($array2, function($item) use ($array1){
    foreach($array1 as $elem){
        if($item['intTrackId'] == $elem['intTrackId']){
            return false;
        }
    }
    return true;
});

answered Mar 25, 2014 at 9:50

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

Comments

silkfire · Accepted Answer · 2014-03-25 09:55:24Z

1

I would first create a loop and store all track IDs from the first array in a separate array.

Then I'd loop over the second array and delete those keys that exist in the track ID array.

$track_ids = array();

foreach($array1 as $index => $items) {
   $track_ids[$items['intTrackId']] = $index;
}

foreach($array2 as $items) {
  if (isset($track_ids[$items['intTrackId']])) {
     unset($array2[$track_ids[$items['intTrackId']]]);
  }
}

edited Mar 25, 2014 at 9:55

answered Mar 25, 2014 at 9:50

silkfire

26.3k17 gold badges92 silver badges116 bronze badges

Collectives™ on Stack Overflow

Removing items from an array based on items in another 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