Sum mysql array in PHP

Question

I need sum up quantity items. I have a database query, I print values:

while ($row = mysqli_fetch_array($lista)) {
    echo $row['przedmiot'].":".$row['ilosc'].'<br>';
}

then I get this result:

item1:1
item1:3
item2:1
item1:3
item2:5

I need to add these values, I would like to get this result:

item1:7
item2:6

Mureinik · Accepted Answer · 2020-08-30 13:26:15Z

4

@Sascha's answer will work, but I'd suggest a different approach - instead of querying all these rows, transferring them from the database to your application and then having to loop over them in the code, let the database do the heavy lifting for you:

SELECT   przedmiot, SUM(ilosc)  AS ilosc
FROM     mytable
GROUP BY przedmiot

edited Aug 30, 2020 at 13:26

answered Aug 30, 2020 at 13:11

Mureinik

316k54 gold badges399 silver badges405 bronze badges

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

Comments

Sascha A. · Accepted Answer · 2020-08-30 13:10:14Z

2

This should help:

$result=[];
while ($row = mysqli_fetch_array($lista)) {
    echo $row['przedmiot'].":".$row['ilosc'].'<br>';
    if (!array_key_exists ($result, $row['przedmiot'])) {
        $result[$row['przedmiot']] =  $row['ilosc'];
    } else {
        $result[$row['przedmiot']] +=  $row['ilosc'];
    }
}

answered Aug 30, 2020 at 13:10

Sascha A.

4,6463 gold badges17 silver badges34 bronze badges

Collectives™ on Stack Overflow

Sum mysql array in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related