Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/luckymerchan/code/admin/ajax/ |
<?php
$q_total = $DB->query("
SELECT count(*) as total FROM tb_kqloc_excel
UNION ALL
SELECT sum(so_tien) as total FROM tb_guest_pay_his WHERE nap_type!='luckymerchan' AND fee_type!='donate'
UNION ALL
SELECT count(*) as total FROM tb_user WHERE user_key<>'' AND user_key<>'giacbn'
UNION ALL
SELECT count(*) as total FROM tb_kqloc
");
$i = 0;
$arr_total = array();
while($r_total = $DB->fetch_row($q_total)){
$arr_total[$i] = $r_total['total'];
$i++;
}
$arr['total_kq_loc'] = $arr_total[0];
$arr['total_tiennap'] = (intval($arr_total[1])==0)?0:intval($arr_total[1]);
$arr['total_user'] = $arr_total[2];
$arr['total_comment'] = $arr_total[3];
echo json_encode($arr);
exit();
?>