PHP: How to get sum of elements of 2 dimension array?

Question

I want to get total of elements of each row at the end of that row and total of elements of each column at the end of each column.

For Example:

I have an array with digits values like this:

$twoDimArr = array(  array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4")

);

output something like this:

$twoDimArr = array(  array("1" , "2" , "3" , "4", "total" => "10"),
                     array("1" , "2" , "3" , "4", "total" => "10"),
                     array("1" , "2" , "3" , "4", "total" => "10"),
                     array("1" , "2" , "3" , "4", "total" => "10"),
                     array("1" , "2" , "3" , "4", "total" => "10"),
                     array("1" , "2" , "3" , "4", "total" => "10"),
                     array("1" , "2" , "3" , "4", "total" => "10"))
                     "columnTotal => "array("7" , "14" , "21" , "28", "70")

    );

Input Array: No of elements in rows may vary but no of each row element will be equal to other rows elements. indexes in input array may be anything.

I have coded this and it is working for me but I am not happy with the amount of code. May be someone will code more efficient and less code solution.

Thanks

Perhaps post the code you have now so that we can try to optimize it? — Raphael Caixeta
– Raphael Caixeta, Commented Aug 14, 2010 at 5:31

Raphael Caixeta · Accepted Answer · 2010-08-14 05:39:50Z

3

Here you go

<?php

$twoDimArr = array(  array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4"),
                     array("1" , "2" , "3" , "4")

);  

$current = 0;
foreach($twoDimArr as $evaluate) {
    $total = 0;
    foreach($evaluate as $value) {
        $total = $total + $value;
    }
    $twoDimArr[$current]['total'] = $total;
    $twoDimArr['columnTotal'][] = $total;
    $current++;
}

print_r($twoDimArr);

?>

Edited it to include your column total.

edited Aug 14, 2010 at 5:39

answered Aug 14, 2010 at 5:34

Raphael Caixeta

7,8469 gold badges54 silver badges76 bronze badges

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

3 Comments

Naveed Over a year ago

Column counting in incorrect here. You are adding rows total result into column total result.

Raphael Caixeta Over a year ago

What's the column total supposed to be?

Naveed Over a year ago

Means total of each column elements. Look at my example in my question. $twoDimArr['columnTotal'][0] should be the sum of all first elements from each row. $twoDimArr['columnTotal'][1] should be the sum of all 2nd elements from each row.

segFault · Accepted Answer · 2021-08-15 01:54:30Z

2

I hope it helps you out.

$total = [];
foreach ($twoDimArr as $arrayData) {
    foreach ($arrayData as $key => $value) {
        if (empty($total[$key])) {
            $total[$key] = 0;
        }
        $total[$key] = $total[$key] + $value;
    } 
}
var_dump($total);

edited Aug 15, 2021 at 1:54

segFault

4,0541 gold badge21 silver badges34 bronze badges

answered Aug 14, 2021 at 4:06

Ahmad Reza Azimi

5825 silver badges17 bronze badges

Comments

Naveed · Accepted Answer · 2010-08-18 18:31:18Z

Here is my solution:

function getTotalArray( $twoDimArr ) {

    if( !empty( $twoDimArr ) && is_array( $twoDimArr ) ) {

        // Create an array to store column total
        $myArr = array();
        for( $i = 0; $i < count( end($twoDimArr) ); $i++ ) {
            $myArr[$i] = 0; 
        }


        foreach( $twoDimArr as $key => $value ) {

            $colCount = 0;
            $rowCount = 0;
            $i = 0;

            foreach( $twoDimArr[$key] as $key1 => $value1 ) {
                $colCount += $value1;
                $myArr[$i] += $value1;
                $i++;
            }

            // Add column total
            $twoDimArr[$key]['total'] = $colCount;
        }

        // Last column total that is created while row elements sum
        $myArr['totaloftotal'] = 0;
        foreach( $twoDimArr as $key2 => $values3 ) {
            $myArr['totaloftotal'] += end($twoDimArr[$key2]);
        }

        $twoDimArr = array_merge($twoDimArr, array( "total" => $myArr) );

        return $twoDimArr;

    } else {

        $twoDimArr = array();
        return $twoDimArr;
    }

} // end function

mickmackusa · Accepted Answer · 2021-03-05 21:59:36Z

As you iterate your rows of data, populate the new total element briefly with array_sum().

Then iterate the columns of the mutated row to keep a running tally of the columnTotal values.

To avoid generating notices and warnings, check if $twoDimArr['columnTotal'][$column] is declared before trying to perform addition.

Code: (Demo)

$twoDimArr = [
    ["1", "2", "3", "4"],
    ["1", "2", "3", "4"],
    ["1", "2", "3", "4"],
    ["1", "2", "3", "4"],
    ["1", "2", "3", "4"],
    ["1", "2", "3", "4"],
    ["1", "2", "3", "4"],
];

foreach ($twoDimArr as $i => $row) {
    $twoDimArr[$i]['total'] = array_sum($row);
    foreach ($twoDimArr[$i] as $column => $value) {
        $twoDimArr['columnTotal'][$column] = ($twoDimArr['columnTotal'][$column] ?? 0) + $value;
    }
}
var_export($twoDimArr);

Collectives™ on Stack Overflow

PHP: How to get sum of elements of 2 dimension array?

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related