Home >Backend Development >PHP Problem >How to sum a certain column of a two-dimensional array in PHP
Summing steps: 1. Use array_column() to obtain all elements of the specified column in the two-dimensional array. The syntax "array_column(two-dimensional array, 'specified column name')" will return an array containing all the specified columns. The result array of elements; 2. Use array_sum() to sum the result array and calculate the sum of all elements in the result array. The syntax is "array_sum (result array)".
The operating environment of this tutorial: windows7 system, PHP version 8.1, DELL G3 computer
php two-dimensional array Method for summing specified columns in:
Implementation idea:
Take out the specified column in the two-dimensional array All elements of the column form a new array
Find the sum of the new array
Implementation steps:
Step 1. Use array_column() to obtain all elements of the specified column in the two-dimensional array
<?php header('content-type:text/html;charset=utf-8'); $arr=array( array( 'name' => "小明", 'score' => 85, ), array( 'name' => "小华", 'score' => 92, ), array( 'name' => "霄晓", 'score' => 100, ), array( 'name' => "萧洁", 'score' => 99, ), array( 'name' => "赵峰", 'score' => 96, ) ); var_dump($arr); $score=array_column($arr, 'score'); var_dump($score); ?>
Step 2. Use array_sum() sums the result array
$score=array_column($arr, 'score'); var_dump($score); $sum=array_sum($score); echo "多维数组中days列的和:".$sum;
Description:
array_column()
can return the value of a single column in the specified array; it will return a result array containing the value of the specified column (the array value is the value of the specified column).
array_column(array,column_key,index_key);
Parameters | Description |
---|---|
array | Required . Specifies the multidimensional array (record set) to use. |
column_key | Required. The column whose value needs to be returned. Can be an integer index of a column of an index array, or a string key value of a column of an associative array. This parameter can also be NULL, in which case the entire array will be returned (very useful when used with the index_key parameter to reset the array key). |
index_key | Optional. The column that is the index/key of the returned array. |
Return value: Return an array. The value of the array is the value of a single column in the input array.
array_sum()
function can calculate the sum of all elements in the specified array.
array_sum ( $arr )
If all elements of array arr are integers, return an integer value; if one or more of the values are floating point numbers, return a floating point number.
If there are non-numeric elements in the array arr, PHP will try to convert them to a numeric value, and if the conversion fails, it will be treated as a 0 value. For example, the string "45" will be converted to the integer 45, and the string "12.4abc" will be converted to the decimal 12.4.
Recommended learning: "PHP Video Tutorial"
The above is the detailed content of How to sum a certain column of a two-dimensional array in PHP. For more information, please follow other related articles on the PHP Chinese website!