php - removing elements from an array that have duplicates values on a specified key

Question

if i have an array like this :

Array (
  [0]=>
  Array (
    ["id"]=> "1"
    ["desc"]=> "desc 1"
    ["type"]=> "T"
    ["date"]=> "17-JAN-12"
  )
  [1]=>
  Array (
    ["id"]=> "2"
    ["desc"]=> "desc 2"
    ["type"]=> "P"
    ["date"]=> "05-JAN-12"
  )
  [2]=>
  Array (
    ["id"]=> "1"
    ["desc"]=> "desc 3"
    ["type"]=> "P"
    ["date"]=> "15-JAN-12"
  )
  [3]=>
  Array (
    ["id"]=> "3"
    ["desc"]=> "desc 4"
    ["type"]=> "P"
    ["date"]=> "06-JAN-12"
  )
  [4]=>
  Array (
    ["id"]=> "2"
    ["desc"]=> "desc 5"
    ["type"]=> "T"
    ["date"]=> "06-JAN-12"
  )
 )

I want to remove from it the elements that has duplicate values on only the key "id" , and get :

Array (
  [0]=>
  Array (
    ["id"]=> "1"
    ["desc"]=> "desc 1"
    ["type"]=> "T"
    ["date"]=> "17-JAN-12"
  )
  [1]=>
  Array (
    ["id"]=> "2"
    ["desc"]=> "desc 2"
    ["type"]=> "P"
    ["date"]=> "05-JAN-12"
  )
  [2]=>
  Array (
    ["id"]=> "3"
    ["desc"]=> "desc 4"
    ["type"]=> "P"
    ["date"]=> "06-JAN-12"
  )
 )

Thanks.

How do you want to handle duplicates? Pick first? Average? Sum? Count? — J0HN
– J0HN, Commented Jan 19, 2012 at 9:06

Gaurav · Accepted Answer · 2012-01-19 09:07:22Z

6

$result = array();
foreach($array as $arr){
   if(!isset($result[$arr["id"]])){
      $result[$arr["id"]] = $arr;
   }
}

answered Jan 19, 2012 at 9:07

Gaurav

28.8k9 gold badges54 silver badges81 bronze badges

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

Comments

rabudde · Accepted Answer · 2012-01-19 09:07:06Z

2

it seems, that id is your primary key. so loop through array and insert element to new array only if id doesn't still exists.

$new_array = array();
foreach ($old_array as $entry) {
    if (empty($new_array[$entry['id']])) $new_array[$entry['id']] = $entry;
}
$new_array = array_values($new_array);

btw. the last line is only for re-order your keys in final array

answered Jan 19, 2012 at 9:07

rabudde

7,7826 gold badges58 silver badges95 bronze badges

Collectives™ on Stack Overflow

php - removing elements from an array that have duplicates values on a specified key

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related