????????????????????
??????????????????
ÿØÿà
JFIF ÿÛ C
! "$" $ ÿÛ C
ÿÂ p
" ÿÄ
ÿÄ ÿÚ
ÕÔË®
(% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤ @
adadasdasdasasdasdas
.....................................................................................................................................home/alphpwcp/previewstream.online/admin/dashboard.php 0000644 00000002174 15176644470 0017244 0 ustar 00 query("SELECT COUNT(*) FROM companies")->fetchColumn();
$totalUsers = $pdo->query("SELECT COUNT(*) FROM users")->fetchColumn();
$totalReviews = $pdo->query("SELECT COUNT(*) FROM reviews")->fetchColumn();
$topCompany = $pdo->query("
SELECT c.name, ROUND(AVG(r.rating),1) AS avg_rating
FROM companies c JOIN reviews r ON c.id=r.company_id
GROUP BY c.id ORDER BY avg_rating DESC LIMIT 1
")->fetch();
?>
Dashboard
Dashboard Stats
- Total Companies:
- Total Users:
- Total Reviews:
- Top Company: (/5)