Merge duplicates in array PHP

Question

I have an array generated daily that will have duplicate products in it.

[0] => Array
    (
        [product_id] => 85
        [name] => Widescreen Espresso v6.1
        [quantity] => 1
    )

[1] => Array
    (
        [product_id] => 85
        [name] => Widescreen Espresso v6.1
        [quantity] => 2
    )

[2] => Array
    (
        [product_id] => 114
        [name] => Panama Esmerelda Diamond Mountain
        [quantity] => 1
    )

I want to find duplicate products and total them up in an array that would look like this:

[0] => Array
    (
        [product_id] => 85
        [name] => Widescreen Espresso v6.1
        [quantity] => 3
    )

[1] => Array
    (
        [product_id] => 114
        [name] => Panama Esmerelda Diamond Mountain
        [quantity] => 1
    )

UPDATE:

I didn't want to remove the duplicates I want to merge duplicates so that the quantity of the product is added together. I managed to work a solution to it with the help of Meenesh Jain's answer below.

           $final_array = array();
           foreach($order_data as $item => $item_value) {
               $pid = $item_value['product_id'];
               if(!isset($final_array[$pid])) {
                 $final_array[$pid] = $item_value;
               } else {
                 $final_array[$pid]['quantity'] += $item_value['quantity'];
               }
            }
            print_r(array_values($final_array));

You can build another array. The index would be the product_id and the value the accumulated quantity. — joconja, Jun 17 '15 at 09:06
possible duplicate of [How to remove duplicate values from an array in PHP](http://stackoverflow.com/questions/307650/how-to-remove-duplicate-values-from-an-array-in-php) — Patrik, Jun 17 '15 at 09:10
I want to merge the duplicates so I get the quantity of each product added up not remove them — MikeeeG, Jun 18 '15 at 08:38

score 1 · Accepted Answer · answered Jun 17 '15 at 09:15

1

You can do it with mysqli

OR

you can apply a custom method on your array

 $temp_array = $new_array = array();
 foreach($array as $key => $arr_values){
   if(!in_array($arr_values['product_id'], $temp_array)){
         array_push($temp_array, $arr_values['product_id']);
         array_push($new_array,$array[$key]);
   } 
  }

// this code will do the trick

answered Jun 17 '15 at 09:15

Meenesh Jain

2,532
2
19
29

This did not work. It just removed the duplicates from in the $new_array. – MikeeeG Jun 18 '15 at 07:48
i have tested it its working. the concept is simple. it will create a new array for the product id that are unique in the array or array – Meenesh Jain Jun 18 '15 at 08:48
But I wanted to merge the duplicate items in the array so that the quantities of unique products are added together not remove them – MikeeeG Jun 18 '15 at 08:53

tobiinformatik · Answer 2 · 2015-06-17T09:14:38.317

My try:

function newArray($oldarray){
    $newarray;
    $newarray[0] = $oldarray[0];
    $ids;
    $ids[0] = array($oldarray[0][product_id],0);
    for($i = 1; $i < count($oldarray);$i++){
        $add = true;
        for($x = 0; $x < count($ids);$x++){
            if($oldarray[$i][product_id] == $ids[$x][0]){
                $add = false;
                $newarray[$ids[$x][1]-1] = array($newarray[$ids[$x][1]-1][product_id],$newarray[$ids[$x][1]-1][name],$newarray[$ids[$x][1]-1][quantity]+$oldarray[$i][quantity]);
            }
        }
        if($add == true){
            $newarray[count($newarray)] = $oldarray[$i];
            $ids[count($ids)] = array($oldarray[$i][product_id],count($newarray));
        }
    }
    return $newarray;        
}

score 0 · Answer 3 · answered Jun 17 '15 at 09:18

You need to use this function (need to pass $array=name of array and $key as 'product_id'):

function super_unique($array,$key)

    {

       $temp_array = array();

       foreach ($array as &$v) {

           if (!isset($temp_array[$v[$key]]))

           $temp_array[$v[$key]] =& $v;

       }

       $array = array_values($temp_array);

       return $array;



    }

Example :

<?php
$vikas=array('0' => array
    (
        'product_id' => 85,
        'name' => "Widescreen Espresso v6.1", 
        'quantity' => 1
    ),

'1' => array
    (
        'product_id' => 85,
        'name' => "Widescreen Espresso v6.1",
        'quantity' => 2
    ),

 '2' => array
    (
        'product_id' => 114,
        'name' => "Panama Esmerelda Diamond Mountain",
        "quantity" => 1 
    )

    );


    function super_unique($array,$key)

{

   $temp_array = array();

   foreach ($array as &$v) {

       if (!isset($temp_array[$v[$key]]))

       $temp_array[$v[$key]] =& $v;

   }

   $array = array_values($temp_array);

   return $array;



}

//print_r(array_unique($vikas['product_id']));
$vik=super_unique($vikas,'product_id');
print_r($vik);

?>

Merge duplicates in array PHP

3 Answers3