Home > Database > Mysql Tutorial > How to Sum Column Values in a Multidimensional Array Without Loops in PHP?

How to Sum Column Values in a Multidimensional Array Without Loops in PHP?

Mary-Kate Olsen
Release: 2024-12-29 09:38:14
Original
339 people have browsed it

How to Sum Column Values in a Multidimensional Array Without Loops in PHP?

Sum Column Values in a Multidimensional Array Without Loops

When working with multidimensional arrays, calculating the sum of specific column values can be challenging. Consider the following array:

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 )
)
Copy after login

The desired output is the sum of the f_count values, which is 7.

Solution Without Loops

For PHP versions 5.5 and above, a concise solution is available using the array_column and array_sum functions:

$f_counts = array_column($array, 'f_count');
$sum = array_sum($f_counts);
Copy after login

This approach avoids the need for loops or complex data manipulation techniques.

Alternative Solution

If using a different version of PHP, or if you prefer, you can achieve column value summation using a more traditional approach:

$sum = 0;
foreach ($array as $row) {
    $sum += $row['f_count'];
}
Copy after login

The above is the detailed content of How to Sum Column Values in a Multidimensional Array Without Loops in PHP?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template