How to add values to a single variable in while loop in php

Question

I would like to add the price values to a total_price and echo it.

My code takes values from session and makes a mysql query to take information from database tables. Once I have it, it shows the prices of each row. Now I'm adding a total price, but instead of taking the values of all prices and add them, it takes the values of the last row only. I would like that total_price to add all the values $price. Here is the code:

<?php 
if (empty($_SESSION['cart'])) { echo "Nothing here";} else {
$whereIn = implode(',', $_SESSION['cart']);

$list_query = mysqli_query($con,"SELECT * FROM packages WHERE id IN ($whereIn)"); 
while($run_list = mysqli_fetch_array($list_query)){
$id = $run_list['id'];
    $price = $run_list['package_price'];  
    $title = $run_list['package_title'];  


    $total_price = '';
$total_price += $price ;




echo '<p> Product :',$title,' | Price: ',$price; ?> <a href="add_to_cart/remove_from_cart.php?id=<?php echo $id; ?>">Remove item</a></p> 

<?php 

}?>  

<p> Total Price: <?php echo $total_price;?></p>

<p> <button> Checkout </button></p>

<?php } ?>

Move $total_price = ''; outside the loop... OR do $price[] = $run_list['package_price']; then use php.net/manual/en/function.array-sum.php. Also you current approach may be open to SQL injections.. — chris85
– chris85, Commented Jan 11, 2016 at 15:56
Thanks to all. All your answers are right. After few days of coding, maybe my brain burned out. I don't know how I did miss this very newbie thing. :) — user4651092
– user4651092, Commented Jan 11, 2016 at 16:01
You should look into use prepared statements, with parameterized queries. If remove_from_cart.php SQL acts like this SQL you are going to run into issues. — chris85
– chris85, Commented Jan 11, 2016 at 16:03
No it doesn't have any sql statement in remove_from_cart.php I have there only code that removes an array value from the session. — user4651092
– user4651092, Commented Jan 11, 2016 at 16:15

Bart · Accepted Answer · 2016-01-11 15:55:53Z

4

Put $total_price = ''; over while loop

answered Jan 11, 2016 at 15:55

Bart

1,2682 gold badges12 silver badges15 bronze badges

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

1 Comment

user4651092 Over a year ago

Yes, you are absolutely right :) How didn't I miss it ? Thanks

clean_coding · Accepted Answer · 2016-01-11 15:59:02Z

3

Try like this:

$total_price = 0;
while($run_list = mysqli_fetch_array($list_query)){
   $price = $run_list['package_price']; 
   $total_price += $price;
}

answered Jan 11, 2016 at 15:59

clean_coding

1,1661 gold badge9 silver badges14 bronze badges

Comments

Kisaragi · Accepted Answer · 2016-01-11 15:57:15Z

2

$total_price += $price;

You are currently resetting $total_price each time you iterate.

answered Jan 11, 2016 at 15:57

Kisaragi

2,2183 gold badges19 silver badges28 bronze badges

Comments

Martin Currah · Accepted Answer · 2016-01-11 15:58:16Z

1

Your total price variable is getting reset on each iteration. Initialise the variable outside of the loop.

$total_price = 0;

while($run_list = mysqli_fetch_array($list_query)){
    $id = $run_list['id'];
    $price = $run_list['package_price'];  
    $title = $run_list['package_title'];  
    $total_price += $price ;

    ...
}

answered Jan 11, 2016 at 15:58

Martin Currah

5171 gold badge5 silver badges15 bronze badges

Comments

S1arl · Accepted Answer · 2016-01-11 15:59:49Z

0

$total_price ='';
while {
$total_price += $price
}

Your total_price eq price every time the loop is iterating

answered Jan 11, 2016 at 15:59

S1arl

551 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to add values to a single variable in while loop in php

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related