Hi guys,
The purpose of this code is to teach you on how to calculate the values of a column using the Sum function.
Hope you will like this source code, for more question about this code email me at jkevlorayna@gmail.com 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> 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>
Sumber : http://www.sourcecodester.com
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 jkevlorayna@gmail.com 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> 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>
Sumber : http://www.sourcecodester.com
Tidak ada komentar:
Posting Komentar
tolong komentarnya ya...