Group 2d array rows by one column and sum another column within each group [duplicate]

Question

I have an array:

Array
(
    [0] => Array
        (
            [qty] => 2
            [id] => 1
            [name] => Name 1
            [sku] => Model 1
            [options] => Color: <em>Black (+10$)</em>. Memory: <em>32GB (+99$)</em>. 
            [price] => 209.00
        )

    [1] => Array
        (
            [qty] => 1
            [id] => 1
            [name] => Name 1
            [sku] => Model 1
            [options] => Color: <em>Black (+10$)</em>. Memory: <em>16GB</em>. 
            [price] => 110.00
        )

    [2] => Array
        (
            [qty] => 1
            [id] => 3
            [name] => Name 2
            [sku] => Model 2
            [options] => 
            [price] => 100.00
        )
)

First step is to find the same id. And if the same id exist convert array. Is it possible to get output array (if id the same remove one and add qty to the another)?

 Array
    (
        [0] => Array
            (
                [qty] => 3 // 2+1
                [id] => 1
                [name] => Name 1
                [sku] => Model 1
                [options] => Color: <em>Black (+10$)</em>. Memory: <em>32GB (+99$)</em>. 
                [price] => 209.00
            )
    
        [1] => Array
            (
                [qty] => 1
                [id] => 3
                [name] => Name 2
                [sku] => Model 2
                [options] => 
                [price] => 100.00
            )
    )

If you don't care about the other attributes, it shouldbe pretty easy with a foreach loop. What have you tried and what was the problem? — Barmar
– Barmar, Commented Jun 27, 2013 at 6:36

Barmar · Accepted Answer · 2013-06-27 06:42:13Z

1

$result = array();
foreach ($input as $subarray) {
  $id = $subarray['id'];
  if (isset($result[$id])) { // Same ID
    $result[$id]['qty'] += $subarray['qty']; // Add quantities
  } else {
    $result[$id] = $subarray; // New ID, put in results
  }
}
$result = array_values($result); // Convert from associative array to indexed

answered Jun 27, 2013 at 6:42

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

Group 2d array rows by one column and sum another column within each group [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related