Home > Article > Backend Development > How to query the sum of fields in an array in php
How to query the sum of fields in an array in php
- PHPzOriginal
- 2023-04-23 09:12:08539browse
PHP is a popular programming language often used for web development. In PHP, arrays are one of the common data structures, and arrays can be easily operated and processed. This article will introduce how to query the sum of a field in an array to perform statistics and analysis on data during the development process.
For a two-dimensional array, we need to find the sum of one of the specific fields, such as the age of each person in the array, we need to calculate the sum of the ages of all people. First, we can use a foreach loop to traverse the entire array and select the fields to be calculated. Here is the sample code:
$people = array(
array('name' => 'John', 'age' => 25),
array('name' => 'Mary', 'age' => 27),
array('name' => 'Bob', 'age' => 30),
);
$sum = 0;
foreach ($people as $person) {
$sum += $person['age'];
}
echo "The total age is: " . $sum;
In this example, we define an array containing three people. In the foreach loop, we iterate through each person's age and add them to the variable $sum. Finally, we output the sum of everyone’s ages.
In addition to the foreach loop, PHP also provides a function to calculate the sum of a field in an array. This function is called array_sum(), and it calculates the sum of all values in an array. However, since our array is a two-dimensional array and we only need to calculate one field in it, we need to use the array_column() function to get the column where the field we want is located. Here is the sample code:
$people = array(
array('name' => 'John', 'age' => 25),
array('name' => 'Mary', 'age' => 27),
array('name' => 'Bob', 'age' => 30),
);
$ages = array_column($people, 'age');
$sum = array_sum($ages);
echo "The total age is: " . $sum;
In this example, we use the array_column() function to get the age of all people (i.e. the 'age' field) and save them in the variable $ages. We then use the array_sum() function to calculate the sum of all the numbers in the $ages array. Finally, we output the sum of everyone's ages.
Summary:
This article introduces how to query the sum of a field in an array in PHP. For a two-dimensional array, use a foreach loop to iterate through the entire array and calculate the sum of the required fields. In addition, PHP also provides array_column() and array_sum() functions to easily calculate the values in the array. In actual development, we can choose the most appropriate method to operate according to specific needs.
The above is the detailed content of How to query the sum of fields in an array in php. For more information, please follow other related articles on the PHP Chinese website!