How to sum array value with specific key [duplicate]

Question

"accounts" => array:6 [
    0 => array:2 [
      "acc_id" => 1
      "balance" => 1000.00
    ]
    1 => array:2 [
      "acc_id" => 2
      "balance" => -1500.00
    ]
    2 => array:4 [
      "acc_id" => 3
      "balance" => 5000.00
    ]
]

Hi, How could I sum up all the balance correct?

Code

foreach ($y['accounts'] as $k) 
{
    $sum_balance = $k['balance'];           
}
$sum_balance += $sum_balance;

With this code, The result will only sum the last balance itself. Example result is 10000.00

you are overwriting $sum_balance with every iteration of the loop, then double it after the loop. just go through your code line by line and actively try to understand what it is doing. — Franz Gleichmann
– Franz Gleichmann, Commented Apr 14, 2019 at 11:30

Jirka Hrazdil · Accepted Answer · 2019-04-14 11:30:01Z

3

You need to increment sum in the foreach loop:

$sum_balance = 0;
foreach ($y['accounts'] as $k) 
{
    $sum_balance += $k['balance'];           
}
var_dump($sum_balance);

answered Apr 14, 2019 at 11:30

Jirka Hrazdil

4,0211 gold badge16 silver badges17 bronze badges

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

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

combine array_sum() with array_column()

array_column()

Return the values from a single column in the input array

array_sum()

Calculate the sum of values in an array

$y = [
    'accounts' => [
        0 => [
          "acc_id" => 1,
          "balance" => 1000.00
        ],
        1 => [
          "acc_id" => 2,
          "balance" => -1500.00
        ],
        2 => [
          "acc_id" => 3,
          "balance" => 5000.00
        ]
    ]
];

var_dump(
    array_sum(array_column($y['accounts'], 'balance'))
);

result:`float 4500`

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Apr 14, 2019 at 11:39

Talal

4242 silver badges13 bronze badges

2 Comments

The fourth bird Over a year ago

You might want to add some explanation for the OP and future readers.

Nick Over a year ago

It would be better if you matched OPs data structure, in which case you would want array_sum(array_column($y['accounts'], 'balance'));

Hussain Abid · Accepted Answer · 2019-04-14 12:16:41Z

1

Your solution is almost correct, just initialize the $sum_balance before the loop and sum it inside the loop.

$sum_balance=0;
foreach ($y['accounts'] as $k) 
{
    $sum_balance += $k['balance'];           
}

Hope it helps, if you need any help feel free to connect.

answered Apr 14, 2019 at 12:16

Hussain Abid

1111 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to sum array value with specific key [duplicate]

3 Answers 3

Comments

result:`float 4500`

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

result:float 4500

2 Comments

Comments

Linked

Related

result:`float 4500`