Multi-dimensional array return keys with duplicate values

Question

Please Help! I want to validate array with duplicate sub-array values. I have an multi-dimensional array. I want to return keys of sub-array with duplicate product_id value. Example: In my array, I have sub-array with duplicate product_id = 124. I want to return their key.

[purchase_order_products] => Array
    (
        [0] => Array
            (
                [product_id] => 124
                [barcode] => 480001407081
                [item_code] => 
                [name] => Brew Kettle Can 330mL
                [qty] => 
                [unit] => 2
                [pcs_have] => 1
                [total_pcs] => 1
                [cost] => 34.83
                [total_item_price] => 34.83
                [stocks] => 
                [po_qty] => 
            )

        [1] => Array
            (
                [product_id] => 125
                [barcode] => 480001416108
                [item_code] => 
                [name] => Colt 45 Can 330mL
                [qty] => 
                [unit] => 2
                [pcs_have] => 1
                [total_pcs] => 1
                [cost] => 29.58
                [total_item_price] => 29.58
                [stocks] => 
                [po_qty] => 
            )

        [2] => Array
            (
                [product_id] => 124
                [barcode] => 480001407081
                [item_code] => 
                [name] => Brew Kettle Can 330mL
                [qty] => 
                [unit] => 2
                [pcs_have] => 1
                [total_pcs] => 1
                [cost] => 34.83
                [total_item_price] => 34.83
                [stocks] => 
                [po_qty] => 
            )
)

The output I want is:

Array(0,2)

I've updated my answer, now it gives the exact output asked for for multiple pairs of duplicates. Will you take a look at it and see if it solves your problem? — glaux
– glaux, Commented Apr 5, 2017 at 10:10

glaux · Accepted Answer · 2017-04-05 11:03:39Z

Edit: I've updated the answer quite a bit.
Edit 2: Now utilizing the built in array functions to find the duplicates

$products = [
  0 => ['product-id' => 124],
  1 => ['product-id' => 125],
  2 => ['product-id' => 124],
  3 => ['product-id' => 126],
  4 => ['product-id' => 126],
  8 => ['product-id' => 124],
];

// Find the duplicates
$product_ids = array_column($products, 'product-id');
$count = array_count_values($product_ids);
$duplicates = array_filter($count, function($var) {
  return $var > 1;
});

// List all the entries with duplicate ids:
foreach ( array_flip($duplicates) as $product_id ) {
  $filter = array_filter($products, function($var) use ($product_id) {
    return ( $var['product-id'] === $product_id );
  });
  print_r('Product-id: ' . $product_id . ' is duplicated in entries: ');
  print_r(array_keys($filter));
}

The output:

// Product-id: 124 is duplicated in entries: Array
// (
//     [0] => 0
//     [1] => 2
//     [2] => 8
// )
// Product-id: 126 is duplicated in entries: Array
// (
//     [0] => 3
//     [1] => 4
// )

Gaurav · Accepted Answer · 2017-04-03 11:02:08Z

1

Use this code to get key for duplicate product id:

$products = $array['purchase_order_products'];

$duplicate_products_keys = array();
$products_ids = array();

foreach($products as $key => $product) {
   if(in_array($product['product_id'], $products_ids)) {
      $duplicate_products_keys[] = $key;
   }
   $products_ids[$product['product_id']] = $product['product_id'];
}

prinr_r($duplicate_products_keys);

answered Apr 3, 2017 at 11:02

Gaurav

7135 silver badges14 bronze badges

Collectives™ on Stack Overflow

Multi-dimensional array return keys with duplicate values

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