Sum values in one column of a 2d array

Question

I have this:

Array (
    [0] => Array ( [f_count] => 1 [uid] => 105 ) 
    [1] => Array ( [f_count] => 0 [uid] => 106 ) 
    [2] => Array ( [f_count] => 2 [uid] => 107 ) 
    [3] => Array ( [f_count] => 0 [uid] => 108 ) 
    [4] => Array ( [f_count] => 1 [uid] => 109 ) 
    [5] => Array ( [f_count] => 0 [uid] => 110 ) 
    [6] => Array ( [f_count] => 3 [uid] => 111 )
)

What I need is: 7", which is the the sum of the f_count column.

I've been trying to figure this out for a couple hours. I thought array_sum() would work, but not with a multidimensional array. So, I've tried figuring out how to isolate the f_counts by unset() or splicing or anything else, but every solution seems to involve a foreach loop. I've messed with array_map, array_walk, and others to no avail. I haven't found a function that works well with multidimensional arrays.

I'm running PHP 5.4.

Can someone please show me how to sum that column without a foreach loop?

If it helps, the f_count values will never be higher than 100, and the uid values will always be greater than 100.

Alternatively, if there's a way to run my query differently such that the array is not multidimensional, that would obviously work as well.

$query = "SELECT f_count, uid FROM users WHERE gid=:gid";
...
$array = $stmt->fetchAll();

I'm using PDO.

You cannot do anything with an array without looping. Why are you so averse to it? — deceze
– deceze ♦, Commented Apr 22, 2013 at 4:14
in case you are using Illuminate\Support\Collection, according to doc: $result = collect($arr)->sum('f_count'); — tinystone
– tinystone, Commented Oct 15, 2024 at 2:40

Marthijn Hoiting · Accepted Answer · 2015-09-06 18:06:21Z

127

In php 5.5+ you can just used array_column and array_sum like so:

 $value = array_sum(array_column($arr,'f_count'));

edited Sep 6, 2015 at 18:06

Marthijn Hoiting

852 silver badges9 bronze badges

answered Jun 25, 2014 at 15:12

Anthony Harley

1,4371 gold badge9 silver badges16 bronze badges

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

2 Comments

Nova Herdi Kusumah Over a year ago

thanks man, now i can sleep well. my version is not to sum, but just to count, so I use this function => $value = array_count_values(array_column($arr,'f_count'));

Fr0zenFyr Over a year ago

"... multidimensional array ..." what about a case where depth is, say, 3?

Ja͢ck · Accepted Answer · 2022-03-09 14:13:51Z

109

You need to couple it with array_map() to select the f_count column first:

array_sum(array_map(function($item) { 
    return $item['f_count']; 
}, $arr));

Nowadays you can replace the inner function with array_column():

array_sum(array_column($arr, 'f_count'));

Of course, internally, this performs a double loop; it's just that you don't see it inside the code. You could use array_reduce() to get rid of one loop:

array_reduce($arr, function(&$res, $item) {
    return $res + $item['f_count'];
}, 0);

However, if speed is the only interest, foreach remains the fastest:

$sum = 0;
foreach ($arr as $item) {
    $sum += $item['f_count'];
}

This is thanks to the "locality" of the variables that you're using, i.e. there are no function calls used to calculate the final sum.

edited Mar 9, 2022 at 14:13

answered Apr 22, 2013 at 2:11

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

4 Comments

David Over a year ago

I'm not being too presumptuous thinking that these options are likely to be more efficient than foreach?

Ja͢ck Over a year ago

@David No, they're both less efficient than foreach.

David Over a year ago

I guess I was misinformed. Thank you for clarifying.

David Over a year ago

I'd give you a bonus if I could for also coming up with a foreach that's prettier and simpler than the others I've seen. Thanks again.

Raja Imran Qamer · Accepted Answer · 2016-10-07 12:01:49Z

for these type of situation foreach loop is the best possible option but if u have to do this for multiple times on a single page then u should put foreach loop in a function so that your code remain clean

function sum_index($arr, $col_name){
    $sum = 0;
    foreach ($arr as $item) {
        $sum += $item[$col_name];
    }
    return $sum;
}

Edit

After searching alot I found that array_column function exist in php 5.5 + to get all values of single column as an array.

For users having lower version You can use following function and call it with array sum if you want sum of all values as well.

//to get all values of single column from multidimensional array, this function exist in php 5.5 or greater.
if(!function_exists("array_column"))
{
    function array_column($array,$column_name)
    {
        return array_map(function($element) use($column_name){return $element[$column_name];}, $array);
    }
}

If you want to get all values of single column then call above function like this:

$newArray = array_column($array,$column_name);

If you want sum of all values of single column then use following code:

$newArraySum = array_sum(array_column($array,$column_name));

Cave Johnson · Accepted Answer · 2018-05-16 19:17:31Z

Alternatively, if there's a way to run my query differently such that the array is not multidimensional, that would obviously work as well.
$query = "SELECT f_count, uid FROM users WHERE gid=:gid"; 
... 
$array = $stmt->fetchAll(); 
I'm using PDO.

Yes, there is another way to run your query differently. You could use the aggregate function SUM to get the sum of all the f_count directly in your query. You would combine this with $stmt->fetchColumn() to get the value of the first column (which would be the sum) of the first row (which will be the only row since we used an aggregate function).

Here is an example of how you could do this:

$query = "SELECT SUM(f_count) FROM users WHERE gid=:gid";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':gid' => 'yoursearchvalue'));
$sum = $stmt->fetchColumn();

kpk · Accepted Answer · 2017-03-29 04:51:59Z

Since you are using PHP 5.4 with PDO, there could be one more way to do it (available in PHP 5.1+):

use the PDO fetchAll() function with the PDO::FETCH_COLUMN as the fetch_style, and the 0-indexed column number as the fetch_argument.

As per your example, it could be:

$query = "SELECT f_count, uid FROM users WHERE gid=:gid";
...
$array_fcount = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);

Now use the array_sum function to sum the values of the array:

$fcount_sum = array_sum($array_fcount);

You could also consult the PHP documentation at http://php.net/manual/en/pdostatement.fetchall.php

Hope this helps, and the performance could be better than looping! As already mentioned in other answers, in PHP 5.5 onwards you have the array_column() function to get $array_fcount directly from another array.

Collectives™ on Stack Overflow

Sum values in one column of a 2d array

5 Answers 5

2 Comments

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related