PHP group and sum multidimensional array

Question

787 votes

2 answers

PHP group and sum multidimensional array

Get the solution ↓↓↓

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Welcome to programmierfrage.com

programmierfrage.com is a question and answer site for professional web developers, programming enthusiasts and website builders. Site created and operated by the community. Together with you, we create a free library of detailed answers to any question on programming, web development, website creation and website administration.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.

score 613 · Answer 1

Answer

Solution:

This is a way to get the desired result. I tried to be creative (I think this is not the most direct way and maybe not the best way).

The last element in each inner array in your input's array ($arr) is a string (without associative key), I don't know you made a mistake when put single quotes or this was your intention. I take them like key and value pairs.

Code:

I broke the original array (and the result array) in two arrays, one with the arrays to look for and the other with the amount's arrays. If I find the look for array in the result array, I sum both amounts. Finally I merge the two result arrays.

<?php

//Input data:
$array = [
        ['type' => 'x', 'color' => 'red', 'amount' => 100],
        ['type' => 'x', 'color' => 'red', 'amount' => 100],
        ['type' => 'y', 'color' => 'blue', 'amount' => 50]
    ];

$arrayResultSearch = array();
$arrayResultAmount = array();

foreach($array as $elemnt) {
    list($arrayTypeColor, $arrayAmount) = array_chunk($elemnt, 2, true);

    if(! in_array($arrayTypeColor, $arrayResultSearch)) {
        $arrayResultSearch[] = $arrayTypeColor;
        $arrayResultAmount[] = $arrayAmount;
    } else {
        $key = key($arrayAmount);
        $value = current($arrayAmount);

        $arrayResultAmount[array_search($arrayTypeColor, $arrayResultSearch)][$key] += $value;
    }
}

$arrrayResult = array_map(function($a, $b) { return array_merge($a, $b); }, $arrayResultSearch, $arrayResultAmount);

?>

Result ($arrrayResult):

array ( 0 => array ( 'type' => 'x', 'color' => 'red', 'amount' => 200, ), 1 => array ( 'type' => 'y', 'color' => 'blue', 'amount' => 50, ), )

score 296 · Answer 2

Answer

Solution:

I solved it like this:

$arr = [
        ['type' => 'x', 'color' => 'red', 'amount' => 100],
        ['type' => 'x', 'color' => 'red', 'amount' => 100],
        ['type' => 'y', 'color' => 'blue', 'amount' => 50]
    ];
    // Create an array with unique types
    $types = [];
    foreach ($arr as $a) {
       if(!in_array($a['type'], $types))
           $types[] = $a['type'];
    }
    // Loop through that array and sum amount of all equal types
    #$x = [];
    $i = 0;
    foreach ($types as $type) {
        $x[$i]['amount'] = 0;
        foreach ($arr as $a) {
            if($type == $a['type']){ // we have a matching type (x or y)
                $x[$i]['type'] = $a['type'];
                $x[$i]['color'] = $a['color'];
                $x[$i]['amount'] += $a['amount'];
            }
        }
        $i += 1;
    }

dump:

array (
  0 => 
  array (
    'amount' => 200,
    'type' => 'x',
    'color' => 'red',
  ),
  1 => 
  array (
    'amount' => 50,
    'type' => 'y',
    'color' => 'blue',
  ),
)