���ѧۧݧ�ӧ�� �ާ֧ߧ֧էا֧� - ���֧էѧܧ�ڧ��ӧѧ�� - /home/alphpwcp/previewstream.online/old/admin/dashboard.php
���ѧ٧ѧ�
<?php session_start(); if (!isset($_SESSION['admin_id'])) { header('Location: login.php'); exit; } include '../db.php'; // <-- this line makes $pdo available // Add these queries: $totalCompanies = $pdo->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(); ?> <?php include 'menu.php'; ?> <!DOCTYPE html> <html> <head> <title>Dashboard</title> <link rel="stylesheet" href="../style.css"> </head> <body> <h2>Dashboard Stats</h2> <ul> <li>Total Companies: <?= $totalCompanies ?></li> <li>Total Users: <?= $totalUsers ?></li> <li>Total Reviews: <?= $totalReviews ?></li> <?php if($topCompany): ?> <li>Top Company: <?= htmlspecialchars($topCompany['name']) ?> (<?= $topCompany['avg_rating'] ?>/5)</li> <?php endif; ?> </ul> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | ���֧ߧ֧�ѧ�ڧ� ����ѧߧڧ��: 0 |
proxy
|
phpinfo
|
���ѧ����ۧܧ�