Finding sum of values of keys having duplicates values in php

Question

I'm not able to find a solution for the given scenario where I have a multidimensional array in which I have to find the sum of the values of the arrays that have same ID.

demo.php

$array = array("1"=>array("id"=>"1", "total"=>"100"),
                "2"=>array("id"=>"2", "total"=>"300"),
                "3"=>array("id"=>"3", "total"=>"400"),
                 "4"=>array("id"=>"4", "total"=>"500"),
                 "5"=>array("id"=>"1", "total"=>"560"));

I want to get the sum of the total of all the duplicates IDs e.g 1 is the ID and the sum of the total would be 100 + 560 = 650.

Just loop through it with a foreach.

Script47
– Script47

2019-08-28 09:31:08 +00:00
Commented Aug 28, 2019 at 9:31 — Script47
– Script47, Commented Aug 28, 2019 at 9:31

Eddie · Accepted Answer · 2019-08-28 11:55:29Z

2

One option is using array_reduce to summarize the array into an associative array.

$array = //....

$result = array_reduce( $array, function( $c, $v ){

    if ( !isset( $c[ $v["id"] ] ) ) $c[ $v["id"] ] = 0;
    $c[ $v["id"] ] += $v["total"];

    return $c;
}, array() );

$result will be:

Array
(
    [1] => 660
    [2] => 300
    [3] => 400
    [4] => 500
)

UPDATE

Add another reduce to group the array first. The second reduce is to only include the array elements with more than one count.

$array = //....
$group = array_reduce( $array, function( $c, $v ){
    if ( !isset( $c[ $v["id"] ] ) ) $c[ $v["id"] ] = [ "count" => 0, "total" => 0, "id" => $v["id"] ];
    $c[ $v["id"] ]["count"] += 1;
    $c[ $v["id"] ]["total"] += $v["total"];
    return $c;
}, array() ); 

$result = array_reduce( $group, function( $c, $v ){
    if ( $v["count"] > 1 ) $c[ $v["id"] ] = $v["total"];
    return $c;
}, array() );

This will result to:

Array
(
    [1] => 660
)

edited Aug 28, 2019 at 11:55

answered Aug 28, 2019 at 9:32

Eddie

26.8k6 gold badges39 silver badges59 bronze badges

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

1 Comment

Dinesh Vishwakarma Over a year ago

result array should not contain other elements . it should contain only the sum of the values of the duplicate id's

Script47 · Accepted Answer · 2019-08-28 10:16:27Z

2

Another take while using a foreach:

$array = array("1"=>array("id"=>"1", "total"=>"100"),
            "2"=>array("id"=>"2", "total"=>"300"),
            "3"=>array("id"=>"3", "total"=>"400"),
             "4"=>array("id"=>"4", "total"=>"500"),
             "5"=>array("id"=>"1", "total"=>"560"));

$total = [];

foreach ($array as $sub) {
    $total[$sub['id']] = isset($total[$sub['id']]) ? $total[$sub['id']] += $sub['total'] : $total[$sub['id']] = $sub['total'];
}

Output

Array
(
    [1] => 660
    [2] => 300
    [3] => 400
    [4] => 500
)

Live Example

Repl

Reading Material

Ternary Operator

answered Aug 28, 2019 at 10:16

Script47

14.6k4 gold badges49 silver badges69 bronze badges

Comments

Ankur Tiwari · Accepted Answer · 2019-08-28 09:40:56Z

1

You can use simple foreach loop to get the expected result

<?php
// Your code here!
$array = array("1"=>array("id"=>"1", "total"=>"100"),
                "2"=>array("id"=>"2", "total"=>"300"),
                "3"=>array("id"=>"3", "total"=>"400"),
                 "4"=>array("id"=>"4", "total"=>"500"),
                 "5"=>array("id"=>"1", "total"=>"560"));
$issetArray = array();

foreach ($array as $key => $value) {
    if(isset($issetArray[$value['id']]))
    {
        $issetArray[$value['id']]['total'] += $value['total'];
    }
    else
    {
        $issetArray[$value['id']] = array();
        $issetArray[$value['id']] = $value;
    }
}

$result = array();
foreach ($issetArray as $value) {
    array_push($result, $value);
}

print_r($result);
?>

Example: https://paiza.io/projects/Fnay-hbk4Cuf_-rMTL5AFA

answered Aug 28, 2019 at 9:40

Ankur Tiwari

2,7782 gold badges27 silver badges42 bronze badges

2 Comments

Ankur Tiwari Over a year ago

@Script47 You can suggest some point. I'm using the same code in my day by day coding. It would be helpful for me to reduce complicated code. Thanks

Ankur Tiwari Over a year ago

Great, Just seen your example from the next time I'll keep the same in mind. Thanks to you learned a new way to do the same thing.

jspit · Accepted Answer · 2019-08-28 11:07:56Z

If you want to use the external class tableArray and you want to preserve the structure of the input array try this:

$array = array("1"=>array("id"=>"1", "total"=>"100"),
                "2"=>array("id"=>"2", "total"=>"300"),
                "3"=>array("id"=>"3", "total"=>"400"),
                 "4"=>array("id"=>"4", "total"=>"500"),
                 "5"=>array("id"=>"1", "total"=>"560"));

$newData = tableArray::create($array)
  ->filterGroupSum('total',['id'])
  ->fetchAll()
;

$newData:

array (
  0 => 
  array (
    'id' => "1",
    'total' => 660,
  ),
  1 => 
  array (
    'id' => "2",
    'total' => 300,
  ),
  2 => 
  array (
    'id' => "3",
    'total' => 400,
  ),
  3 => 
  array (
    'id' => "4",
    'total' => 500,
  ),
)

Collectives™ on Stack Overflow

Finding sum of values of keys having duplicates values in php

4 Answers 4

1 Comment

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related