Home >Backend Development >PHP Problem >How to sum a certain column of a two-dimensional array in PHP

How to sum a certain column of a two-dimensional array in PHP

青灯夜游
青灯夜游Original
2022-06-30 19:35:203875browse

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)".

How to sum a certain column of a two-dimensional array in PHP

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(&#39;content-type:text/html;charset=utf-8&#39;);   
$arr=array(
  array(
    &#39;name&#39; => "小明",
    &#39;score&#39; => 85,
  ),
  array(
    &#39;name&#39; => "小华",
    &#39;score&#39; => 92,
  ),
  array(
    &#39;name&#39; => "霄晓",
    &#39;score&#39; => 100,
  ),
  array(
    &#39;name&#39; => "萧洁",
    &#39;score&#39; => 99,
  ),
  array(
    &#39;name&#39; => "赵峰",
    &#39;score&#39; => 96,
  )
);
var_dump($arr);
$score=array_column($arr, &#39;score&#39;);
var_dump($score);
?>

How to sum a certain column of a two-dimensional array in PHP

Step 2. Use array_sum() sums the result array

$score=array_column($arr, &#39;score&#39;);
var_dump($score);

$sum=array_sum($score);
echo "多维数组中days列的和:".$sum;

How to sum a certain column of a two-dimensional array in PHP

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!

Statement:
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