Combined Strings and sum numeric two multidimensional arrays in PHP

Question

I have below two arrays with strings and numbers,

I want to keep only one strings header and sum numeric value from each key value with another array.

I have tried many of the solutions available online but nothing found as required.

Expected output as Strings should be use only once and numbers should be added to each other.

For example output should be 6 index i.e sum of 6 index from array1 and array2 -

[6] => Array
            (
                [0] => This Year<br/>(01-01-2020 - 04-26-2020)
                [1] => 1311
                [2] => 1328
                [3] => 1
            )

u_mulder · Accepted Answer · 2020-04-26 18:54:57Z

1

If your arrays are always sorted in the same order:

$newItems = [];
foreach ($array1 as $key => $item) {
    $newItems[] = [
        $item[0],
        $item[1] + $array2[$key][1],
        $item[2] + $array2[$key][2],
        $item[3] + $array2[$key][3],
    ];
}

If keys in arrays are in distinct orders:

$newItems = [];
foreach ($array1 as $item) {
    $name = $item[0];
    $newItems[$name] = $item;
}
foreach ($array2 as $item) {
    $name = $item[0];
    $newItems[$name][1] += $item[1];
    $newItems[$name][2] += $item[2];
    $newItems[$name][3] += $item[3];
}
// apply array_values to get 0-indexed array
$newItems = array_values($newItems);

answered Apr 26, 2020 at 18:54

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

2 Comments

Rahul Over a year ago

but while using 1st solution its giving output

[0] => Array         (             [0] => Out Of Warranty             [1] => 0             [2] => 0             [3] => 0         )

which causing 0 index label empty

u_mulder Over a year ago

So, check if key is 0 and not add / skip values, you can do it, right?

mickmackusa · Accepted Answer · 2020-04-27 22:26:59Z

Only iterate the elements that are necessary for your summing logic. Using 2 loops will be the most concise and deliberate way to sum columns [1], [2], and [3].

You can create a new output array, but merely adding the second array values to the first affords a simpler addition-assignment syntax.

Code: (Demo)

for ($i = 1, $size = count($array2); $i < $size; ++$i) {  // don't iterate [0] subarray (headers)
    for ($col = 1; $col <= 3; ++$col) {  // don't iterate [0] element (name)
        $array1[$i][$col] += $array2[$i][$col];
    }
}
var_export($array1);

Output:

array (
  0 => 
  array (
    0 => 'Out Of Warranty',
    1 => 'Total Orders',
    2 => 'Total Qty',
    3 => 'Canceled Orders',
  ),
  1 => 
  array (
    0 => 'Today<br/>(04-26-2020)',
    1 => 11,
    2 => 11,
    3 => 0,
  ),
  2 => 
  array (
    0 => 'Yesterday<br/>(04-25-2020)',
    1 => 7,
    2 => 7,
    3 => 0,
  ),
  3 => 
  array (
    0 => 'This Week<br/>(04-20-2020 - 04-26-2020)',
    1 => 73,
    2 => 90,
    3 => 0,
  ),
  4 => 
  array (
    0 => 'Last Week<br/>(04-13-2020 - 04-19-2020)',
    1 => 38,
    2 => 38,
    3 => 0,
  ),
  5 => 
  array (
    0 => 'This Month<br/>(04-01-2020 - 04-26-2020)',
    1 => 122,
    2 => 139,
    3 => 0,
  ),
  6 => 
  array (
    0 => 'This Year<br/>(01-01-2020 - 04-26-2020)',
    1 => 1311,
    2 => 1328,
    3 => 1,
  ),
)

Collectives™ on Stack Overflow

Combined Strings and sum numeric two multidimensional arrays in PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related