Php sum the values in while loop does not work

Question

I have a problem with sum values in while loop. So, I have a database witch has rows with same product name, but different quantities, different ids and different prices. When I do my while loop it prints each product, but I want to print only one and sum quantities.

My result is 11123, not 8, how it should be.

This is my code:

$found = 1;
while($stmt->fetch()){
    if(!($data3['Prod_price'] == '0' || $data3['Prod_name'] == ' Acne Cream')) {
        $price = $data3['Prod_total'] - ($data3['Prod_total'] *($data3['Discount']/100));
        $qty = $data3['Vial_type'] == " 50 Tablete" ? $data3['Prod_qty'] / 2 : $data3['Prod_qty'];
        if($data3['Prod_name'] == ' Antioxidant Star'){
            if($found==1){ // this is for showing only one product with same name 
                $found++;

                // here should be summed quantity divided by target (to extract the percentage)
                $andioxidtrg = $qty / $data2['Trg_antioxidant']; 
                // here shold be the quantity
                $andioxidqty = $qty; 

                echo 'Antioxidant Star: '.$andioxidqty.' din '.$data2['Trg_antioxidant'].' ('.round( $andioxidtrg * 100 )."%)<br>";
            }
        }
    }
}

Andreas · Accepted Answer · 2018-08-23 09:03:22Z

1

If you want to sum then sum it, you just overwrite the value.

$andioxidqty += $qty; // notice the +

Edit: this means you also need to add a line above the loop with: $andioxidqty =0; or you will get a notice on the first iteration

answered Aug 23, 2018 at 9:03

Andreas

24k7 gold badges34 silver badges75 bronze badges

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

10 Comments

Andreas Over a year ago

How can it be 1 if you say it's 11123? On the first iteration, yes it's one but when the loop is done you should have 8 as the value in $andioxidqty

Iulian Nistor Over a year ago

if i echo the "$qty" above the "if($found==1){" line the result is "11123" but inside the if statement "if($found==1)" the result is always 1 :(

Andreas Over a year ago

if($found==1){ is true the first iteration, then the very next line makes this if never again be true, $found++;. What is this found thing? It does not make any sense

Ziya Vakhobov Over a year ago

You are checking found to be equal to 1. then increment it to 1 so result will be incremented only once

Andreas Over a year ago

@ZiyaVakhobov I can't accept that edit, it's wrong. PHP typecasts if you add int to a string number. 3v4l.org/U6Jep

|

Collectives™ on Stack Overflow

Php sum the values in while loop does not work

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related