Add / SUM the table row values in database using PHP

Here i'm going to tell about, how to make addition or sum the table row values in the mysql database using PHP, this concept is very simple one, let see how to make this addition in mysql database using PHP.

DOWNLOAD            LIVE DEMO

you know this, like the above sample image is the demo of the add or sum the database data values in the database using PHP, you can see the out put value in the last row the table. ok let see the code.

DATABASE 

<?php 
$conn=mysql_connect('localhost','root','');
$db=mysql_select_db('2my4edge',$conn);
?>

CODE

<table>
  <tr>
    <td class="head" >S No</td>
    <td class="head">Mark</td>
    <td class="head">Mark 1</td>
  </tr>
  
  <?php 
  include('db.php');
  $table=mysql_query('SELECT * FROM `add`');
  while($row=mysql_fetch_array($table))
  {
      $number=$row['id'];
      $smark=$row['mark'];
      $smark1=$row['mark1'];
  ?>
  <tr>
    <td class="sno"><?php echo $number ?></td>
    <td class="mark"><?php echo $smark ?></td>
    <td class="mark"><?php echo $smark1 ?></td>
  </tr>
  <?php } ?>
  
  <?php 
  $add=mysql_query('SELECT SUM(mark),SUM(mark1) from `add`');
  while($row1=mysql_fetch_array($add))
  {
    $mark=$row1['SUM(mark)'];
    $mark1=$row1['SUM(mark1)'];  
 ?>
  <tr>
    <td class="foot">Total</td>
    <td class="foot"><?php echo $mark ?></td>
    <td class="foot"><?php echo $mark1 ?></td>
  </tr>
  <?php } ?>
</table>

i hope you can get clear idea from the above code. SUM(column-name) is very important. i hope this is very useful to everyone. Thank you.

RELATED POST :

Detect Operating System and Detect the Browser using Php

Ajax delete with PHP and MySql

Facebook style 'see more' text onclick using php, mysql, Ajax and Javascript

Autocomplete search using php, mysql and ajax

Export the MySQL database table as CSV format using PHP

Simple Pagination with loading effect using Qjuery, PHP and MySql

Marquee style in different manner with PHP and MySql

File download coding using PHP and Mysql

Simple Login logout system using php

Username live availability Check using php and Ajax

Comment System using PHP and MySql

Create Database with MySql and INSERT coding in php