Calculate Sum (Total) of Column in PHP

Submitted by jkev on Wednesday, May 15, 2013 - 13:19.

Language

Hi guys, The purpose of this code is to teach you on how to calculate the values of a column using the Sum function. This is very useful if you want to create a poin of sale system in your PHP project. Hope you will like this source code, for more question about this code email me at [email protected] thank you. databasename: db folder sum.sql Sample code:

<?php 
include('header.php');
?>
 
<body>
<br>
<br>
<div class="container">
        <div class="alert alert-success">Sum the Numbers in a Column</div>
        <br />
        <table  class="table table-striped table-bordered">
                <thead>
                        <tr>
                                <th>Product Name</th>
                                <th>Quantity</th>
                                <th>Price</th>
                                <th>Amount</th>
                        </tr>
                </thead>
                <tbody>
                        <?php 
                                $query=mysql_query("select * from product")or die(mysql_error());
                                while($row=mysql_fetch_array($query)){
                                $id=$row['product_id'];
                        ?>
                        <tr>
                                <td><?php echo $row['name'] ?></td>
                                <td><?php echo $row['qty'] ?></td>
                                <td><?php echo $row['Price'] ?></td>
                                <td><?php echo $row['amount'] ?></td>
                        </tr>
                        <?php } ?>
                </tbody>
        </table>
        <?php
                $result = mysql_query("SELECT sum(amount) FROM product") or die(mysql_error());
                while ($rows = mysql_fetch_array($result)) {
        ?>
        <div class="pull-right">
                <div class="span">
                        <div class="alert alert-success"><i class="icon-credit-card icon-large"></i>&nbsp;Total:&nbsp;<?php echo $rows['sum(amount)']; ?></div>
                </div>
        </div>
        <?php }
      
        $result1 = mysql_query("SELECT sum(qty) FROM product") or die(mysql_error());
        while ($rows1 = mysql_fetch_array($result1)) {
        ?>      
        <div class="pull-right">
                <div class="span">
                        <div class="alert alert-info"><i class="icon-credit-card icon-large"></i>&nbsp;Total number of Items:&nbsp;<?php echo $rows1['sum(qty)']; ?></div>
                </div>
        </div>
        <?php } ?>
</div>
</body>
</html>

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Log in or register to post comments
12550 views

Calculate Sum (Total) of Column in PHP

Comments

Question

programm

Calculate Sum (Total) of Column in PHP

its error please give the…