Pages

How to Add the Table Row Values in Database Using PHP

Let's discuss on how to make addition or summation the table row values in MySQL database with using PHP Development.

php development
                     DOWNLOAD                                                             LIVE DEMO

Check out the below image, which is a demo of the addition the database values using PHP. Also, you can see the output values in the last row. Let's move onto the code.s

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>

ethan

Phasellus facilisis convallis metus, ut imperdiet augue auctor nec. Duis at velit id augue lobortis porta. Sed varius, enim accumsan aliquam tincidunt, tortor urna vulputate quam, eget finibus urna est in augue.

No comments:

Post a Comment