php code to display sum of column from total

Question

My query gets below data from database.

This is correct but i also need to display sum of all rows like below total..

how can i do this...

I need to display sum of totalbooking column in last row..

bookno  bookingdate  totalbooking
 401      15-03-2015     1
 401      16-03-2015     2
 404      15-03-2015     1

          Total          4

Below is my code...

<?php
if($_POST && isset($_POST['Submit']))
{   
    if($_POST['hawkername']=='All')
    {   
    $cityname = $_SESSION['Auth']['city'];
    $data = $database->getRows("SELECT RE.book_no AS book, RE.bookingdate AS bookingdate, HM.hawker_name AS hawkername,SAM.tehsil AS centername,
    COUNT( DISTINCT RE.receipt_no ) AS totalbooking,SUM(DISTINCT RE.receipt_no) AS final FROM receipt_entry RE INNER JOIN hawker_master HM ON HM.id = RE.hawkername INNER JOIN sub_agent_master SAM ON SAM.id = RE.subagentname WHERE RE.city_name = :cityname GROUP BY RE.hawkername, RE.book_no",array(':cityname'=>$cityname)); 
    } 

?>


<?php  if (is_array($data)) {    foreach($data as $row){  ?>
        <tr>    
        <td><?php echo htmlspecialchars($row['book']); ?></td>
        <td><?php echo htmlspecialchars($row['bookingdate']); ?></td>           
        <td><?php echo htmlspecialchars($row['totalbooking']); ?></td>
        </tr>
        <?php  } }  ?>  
        <tr>        
        <td>Total</td>
        <td></td>
        </tr>

Create a total variable - $total = 0 and add each totalbooking in the loop - $total += $row['totalbooking'];. Then echo the total. — Sean
– Sean, Commented Apr 2, 2015 at 15:45

christophetd · Accepted Answer · 2015-04-02 15:56:41Z

1

Change your query into this:

SELECT 
    (SELECT SUM(DISTINCT RE.receipt_no) FROM FROM receipt_entry RE) as totalbooking, 
    RE.book_no AS book, RE.bookingdate AS bookingdate, 
    ...

answered Apr 2, 2015 at 15:56

christophetd

3,87422 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

payal dubey · Accepted Answer · 2015-04-02 15:54:28Z

0

<?php  if (is_array($data)) {  $total = 0; foreach($data as $row){ $total += $row['totalbooking'];  ?>
        <tr>        

        <td><?php echo htmlspecialchars($row['book']); ?></td>
        <td><?php echo htmlspecialchars($row['bookingdate']); ?></td>           
        <td><?php echo htmlspecialchars($row['totalbooking']); ?></td>
        </tr>

        <?php $i++; } }  ?> 
        <tr>
        <td colspan="4"></td>
        <td style="font-size:13px; font-weight:bold;">Total</td>
        <td style="font-size:13px; font-weight:bold;"><?php echo $total; ?></td>
        </tr>

answered Apr 2, 2015 at 15:54

payal dubey

692 silver badges9 bronze badges

Collectives™ on Stack Overflow

php code to display sum of column from total

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related