Count multidimmensional array values by same array value

Question

Let's assume this scenario. We have multidimmensional $products array like this. 2 products, but 3 attributes and different cart_quantity for every one.

Array
(
    [0] => Array
        (
            [id_product] => 1
            [id_product_attribute] => 5
            [cart_quantity] => 1
        )
    [1] => Array
        (
            [id_product] => 620
            [id_product_attribute] => 784
            [cart_quantity] => 8
        )
    [2] => Array
        (
            [id_product] => 1
            [id_product_attribute] => 12
            [cart_quantity] => 3
        )
)

How I can sum all of $product['cart_quantity'] for each array entry with same id_product that I would have result like this:

Array
(
     [1] => 4 // 1 + 3
     [620] => 8
)

I am really sorry about thread title I can't even form what I want to achieve without showing this in example above.

Have you tried foreach()? If not, i can write you an example with documentation — Ronnie Oosting
– Ronnie Oosting, Commented Aug 9, 2018 at 12:29
But how I can check that id_product was in foreach? This id_product will be random all the time. I can't use in foreach if ($value['id_product'] == 1) because this will be random in all of the carts. — Eryk Wróbel
– Eryk Wróbel, Commented Aug 9, 2018 at 12:31
I'll write an example ;-). One moment. Or is Siddharth his answer enough? — Ronnie Oosting
– Ronnie Oosting, Commented Aug 9, 2018 at 12:32

Barmar · Accepted Answer · 2018-08-09 12:57:31Z

1

Use a simple foreach loop. Use $product['product_id'] as the key in the result array, which you simply add to when you get a duplicate ID.

$result = array();
foreach ($products as $product) {
    $id = $product['product_id'];
    $quant = $product['cart_quantity'];
    if (isset($result[$id])) {
        $result[$id] += $quant;
    } else {
        $result[$id] = $quant;
}

answered Aug 9, 2018 at 12:57

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

3 Comments

Eryk Wróbel Over a year ago

Your code works perfectly. I didn't even thought about such a simple and clever solution. I have to memorize this case to use it in future. Thank You. codepad.org/LDCD8Wu0

Barmar Over a year ago

If you're programming by memorizing snippets like this, you're not doing it right. You need to learn general principles and how to combine them to solve problems. Otherwise, it's like being only able to drive to places you've been to before.

Eryk Wróbel Over a year ago

I mean I will remember that I can use array values as array keys in foreach - I always keep forgeting about that. I know what You mean and I totally agree that it is not idea of learning programming.

Samir Sheikh · Accepted Answer · 2018-08-09 13:07:58Z

1

Please Try using following way..

$totals = array();
foreach ($main as $row) {
  $product = $row['id_product'];
  $quantity = $row['cart_quantity'];
  $totals[$product] += $quantity;
}

answered Aug 9, 2018 at 13:07

Samir Sheikh

2,4522 gold badges22 silver badges40 bronze badges

Collectives™ on Stack Overflow

Count multidimmensional array values by same array value

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related