sum total free html 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> Total: <?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> Total number of Items: <?php echo $rows1['sum(qty)']; ?></div> </div> </div> <?php } ?></div></body></html>
Are there any code examples left?
New code examples in category Html
-
Html 2022-03-27 21:55:05 how to kill html
-
Html 2022-03-27 21:55:02 How to create web urls without extensions
-
Html 2022-03-27 21:45:11 space between 2 h tags without break
-
Html 2022-03-27 21:40:13 how to resize submit button in html
-
Html 2022-03-27 20:40:18 https://www.codegrepper.com
-
Html 2022-03-27 19:55:09 show image inside table with innerhtml
-
Html 2022-03-27 19:30:47 html email input
-
Html 2022-03-27 18:45:01 how to add favicon in html
-
Html 2022-03-27 18:15:21 picture html
-
Html 2022-03-27 18:15:11 ex: javaasdasdasdasd