how to sum in foreach loop in php

Question

this is my code i want the sum of the fields but unable to do this any one can help in this regards

<?php
     $hostname="localhost";  
     $username="root";  
     $password="";  
     $db = "usman";  

     $dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);  

     foreach($dbh->query("SELECT COUNT(*) as cnt
     FROM ams 
     WHERE empid= {$_SESSION['sess_user_id']} 
     GROUP BY leavetype 
     HAVING leavetype =               
     sum('Absent'), sum('Annual'),sum('Medical'), 
     sum('Casual') , sum('LWOP') ") as  $GrandTotal) 
     {  
           echo "<table ><tr ><td style='border: 0px; ' >" .        
           $GrandTotal['cnt'] . "</td></tr></table>";    
           echo "<br>"; 
     }
?>

SUM(column) and not SUM('string'). dev.mysql.com/doc/refman/5.7/en/… and make sure you started the session. — Funk Forty Niner
– Funk Forty Niner, Commented Sep 29, 2016 at 14:13
Question should have been "How do I indent my code so its readable?" — RiggsFolly
– RiggsFolly, Commented Sep 29, 2016 at 14:13
i want to add these field ..these are come from 1 coulm against id — Muhammad Usman
– Muhammad Usman, Commented Sep 29, 2016 at 14:15

Raphaël Althaus · Accepted Answer · 2016-09-29 14:27:59Z

1

HAVING is a filter on grouped results, not a way to select anything

I would guess you need something like

SELECT 
  leavetype, 
  count(*) as cnt
FROM ams 
 where empid= {$_SESSION['sess_user_id']} 
 and leavetype in ('Absent', 'Annual','Medical',  'Casual' , 'LWOP') -- if you want only certain leave types
GROUP BY leavetype

If you want only the count of all these leavetypes, just do

SELECT 
 count(*) as cnt
FROM ams 
where empid= {$_SESSION['sess_user_id']} 
and leavetype in ('Absent', 'Annual','Medical',  'Casual' , 'LWOP')

edited Sep 29, 2016 at 14:27

answered Sep 29, 2016 at 14:17

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

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

3 Comments

LukStorms Over a year ago

The grouping probably isn't needed. Since the php only shows a count.

Raphaël Althaus Over a year ago

@LukStorms Maybe, but the "non-working" code make me think that it's desired. Who knows, who knows...

Muhammad Usman Over a year ago

leave type is a column and i want to count the sum of all entries against emp id from this leave type column. like('Absent', 'Annual','Medical', 'Casual' , 'LWOP') in leavetype is 6 show as grand total

Collectives™ on Stack Overflow

how to sum in foreach loop in php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related