如何添加和显示在表中的PHP mysql - how to add sum and show in the table in php mysql

how to add sum and show in the table in php mysql

本文关键字：mysql PHP 显示何添加添加 | 更新日期: 2023-09-27

这是我的代码。问题是……我有2nm的db。休假类型和休假数量。目前我的代码将休假类型和检查休假类型对emp id和显示总和..像如果半天有2计数对emp id，那么它显示2..但是我想先检查leavetype，然后检查leave count，然后显示结果

<?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 = 'HalfDay'") as $HalfDay) 
       {  
       echo "<table ><tr ><td style='border: 0px; '>" . $HalfDay['cnt'] . "</td></tr></table>";    
                    echo "<br>"; 
       }
?>

您可以在empid之前检查leavetype，但HAVING不能放在查询的中间。

foreach($dbh->query("SELECT COUNT(*) as cnt
    FROM ams 
    sum(leavetype) as leavecount
    where leavetype = 'HalfDay' and 
    where empid= {$_SESSION['sess_user_id']} and
    where leavecount > 2
    GROUP BY leavetype 
    HAVING leavetype = 'HalfDay'") as $HalfDay)