How can I addition mysql numeric data with another mysql numeric data

Question

<?php 
        $new_result = mysqli_query($con, "SELECT input_cost FROM data_input");
        while ($new = mysqli_fetch_array($new_result)) {

            $sum += $new['input_cost'];
        }

        echo "<h2> total cost of this month is $".$sum. "</h2>";

     ?>

but the result say

<br>

Notice: Undefined variable: sum in C:\xampp\htdocs\work_shop\back_end\data_input_output\result.php on line 57

<br>

total cost of this month is $300 which is correct result....

<br>

How can I solve this problem...??

define $sum before loop.

Death-is-the-real-truth
– Death-is-the-real-truth

2015-06-05 10:36:11 +00:00
Commented Jun 5, 2015 at 10:36 — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jun 5, 2015 at 10:36

Death-is-the-real-truth · Accepted Answer · 2015-06-05 10:26:53Z

3

You need to define $sum variable outside loop. Try this-

<?php 


$sum = 0; // define sum outside loop

$new_result = mysqli_query($con, "SELECT input_cost FROM data_input");
while ($new = mysqli_fetch_array($new_result)) {

     $sum += $new['input_cost'];
}

 echo "<h2> total cost of this month is $".$sum. "</h2>";

?>

answered Jun 5, 2015 at 10:26

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

Comments

N. Hamelink · Accepted Answer · 2015-06-05 10:26:42Z

3

$sum is undefined because you are only adding, and not setting a value.

<?php 
  $new_result = mysqli_query($con, "SELECT input_cost FROM data_input");
  $sum = 0;
  while ($new = mysqli_fetch_array($new_result)) {
    $sum += $new['input_cost'];
  }
  echo '<h2> total cost of this month is $'.$sum.'</h2>';
?>

answered Jun 5, 2015 at 10:26

N. Hamelink

7285 silver badges15 bronze badges

Collectives™ on Stack Overflow

How can I addition mysql numeric data with another mysql numeric data

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