In this tutorial, we are going to create Total Sum in a Column using PHP/MySQL. This simple work created to teach the user on how to calculate the values of a column using the SUM function to the PHP query. If you want to create a simple system like a point of sale, you can put this simple function to your project. You can also check the live demo of this simple tutorial, so you can get an idea and you can try this out, let's start coding.

⚙ Live Demo

Sample Source Code

1. <?php
   
2. $result1 =
   
   mysql_query(
   
   "SELECT sum(qty) FROM product"
   
   )
   
   or die(
   
   mysql_error(
   
   )
   
   )
   
   ;
   
3. while (
   
   $rows1 =
   
   mysql_fetch_array(
   
   $result1)
   
   )
   
   {
   
4. ?>
   
5. <div
   
   class
   
   =
   
   "pull-left"
   
   >
   
6. <div
   
   class
   
   =
   
   "span"
   
   ><div
   
   class
   
   =
   
   "alert alert-danger"
   
   ><i
   
   class
   
   =
   
   "icon-credit-card icon-large"
   
   ></
   
   i
   
   >
   
   Total number of Items:
   
7. <b
   
   style
   
   =
   
   "color:red; font-size:18px;"
   
   ><?php echo $rows1[
   
   'sum(qty)'
   
   ]
   
   ; ?></
   
   b
   
   ></
   
   div
   
   ></
   
   div
   
   >
   
8. </
   
   div
   
   >
   
9. <?php }
   
10. ?>
    
11. 
    
12. <?php
    
13. $result =
    
    mysql_query(
    
    "SELECT sum(amount) FROM product"
    
    )
    
    or die(
    
    mysql_error(
    
    )
    
    )
    
    ;
    
14. while (
    
    $rows =
    
    mysql_fetch_array(
    
    $result)
    
    )
    
    {
    
15. ?>
    
16. <div
    
    class
    
    =
    
    "pull-left"
    
    >
    
17. <div
    
    class
    
    =
    
    "span"
    
    ><div
    
    class
    
    =
    
    "alert alert-danger"
    
    ><i
    
    class
    
    =
    
    "icon-credit-card icon-large"
    
    ></
    
    i
    
    >
    
    Total Amount:
    
18. <b
    
    style
    
    =
    
    "color:red; font-size:18px;"
    
    ><?php echo $rows[
    
    'sum(amount)'
    
    ]
    
    ; ?></
    
    b
    
    ></
    
    div
    
    ></
    
    div
    
    >
    
19. </
    
    div
    
    >
    
20. <?php }
    
21. ?>
    

Output



⚙ Live Demo

Hope that this simple yet useful tutorial that I created may help you to your future projects.

If you are interested in programming, we have an example of programs that may help you even just in small ways.

Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Download