session_start(); include("header.htm"); include("connectusers.php"); $sql="select noidung.user,users_ql.ten,users_ql.address, count(noidung.id) as tong,users_ql.ten from noidung INNER JOIN users_ql on users_ql.user=noidung.user where noidung.hienthi<>'2' and users_ql.trangthai='1' group by user order by tong desc"; //echo $sql; $result=mysql_query($sql); $num_results=mysql_num_rows($result); echo "
Báo cáo trạng thái website Các nhân
"; echo "Web site cá nhân:"; echo ""; echo "
\n"; echo " STT | \n"; echo "\n"; echo " Họ tên | \n"; echo "\n"; echo " Số câu hỏi/Trả lời | \n"; echo "\n"; echo " Tổng số trang | \n"; echo "
".$k." | \n"; echo "".$row["ten"]." | \n"; echo ""; //dem so cau tra loi $sql5="select count(id) as tong from tuvan where hienthi <>'2' and user='".$row["user"]."'"; $rs=mysql_query($sql5); $row5=mysql_fetch_array($rs); echo $row5["tong"]."/"; $sql5="select count(id) as tong from tuvan where hienthi='1' and user='".$row["user"]."'"; $rs=mysql_query($sql5); $row5=mysql_fetch_array($rs); echo $row5["tong"]; echo " | \n"; echo "".$row["tong"]." | \n"; echo "
".$k." | \n"; echo "".$row["ten"]." | \n"; echo ""; //dem so cau tra loi $sql5="select count(id) as tong from tuvan where hienthi <>'2' and user='".$row["user"]."'"; $rs=mysql_query($sql5); $row5=mysql_fetch_array($rs); echo $row5["tong"]."/"; $sql5="select count(id) as tong from tuvan where hienthi='1' and user='".$row["user"]."'"; $rs=mysql_query($sql5); $row5=mysql_fetch_array($rs); echo $row5["tong"]; echo " | \n"; echo "".$row["tong"]." | \n"; echo "
Các đơn vị cập nhật trong ngày hôm nay:".date("d-m-Y").""; echo "
Thống kê số lần xem trang"; //cac don vi chua co thong tinecho $sql="select users_ql.ten,users_ql.user,users_ql.address from users_ql left JOIN noidung on users_ql.user=noidung.user where noidung.id is Null and users_ql.trangthai='1' and users_ql.user<>'admin' order by user asc"; //echo $sql; $result=mysql_query($sql); $num_results=mysql_num_rows($result); echo "
Các trang chưa có thông tin"; echo ""; echo "
\n"; echo " STT | \n"; echo "\n"; echo " họ tên | \n"; echo "\n"; echo " Địac chỉ | \n"; echo "\n"; echo " Tổng số trang | \n"; echo "
".$k." | \n"; echo "".$row["ten"]." | \n"; echo "".$row["address"]." | \n"; echo "\n"; echo " |