Question

php中统计mysql数据库多条件，多条目

第一张图是原始表，如何用sql语句统计出第二张图？





Answer 1

$res_type = mysqli_query($link, "select 防患级别 from table1 group by 防患级别")；
while （$arr_type = mysqli_fetch_array($res_type)）{
$type = $arr_type[0];
$sum_wait = mysqli_num_rows(mysqli_query($link, "select * from table1 where 防患类别='{$type}' and 状态='代办'"));
$sum_done = mysqli_num_rows(mysqli_query($link, "select * from table1 where 防患类别='{$type}' and 状态='已解决"));
$sum_total = mysqli_num_rows(mysqli_query($link, "select * from table1 where 防患类别='{$type}' "));
mysqli_query($link, "insert into table2 values('{$type}','{$sum_wait}','{$sum_done}','{$sum_total}')")
}