File "dashboard.php"

Full Path: /home/alphpwcp/previewstream.online/old/admin/dashboard.php
File size: 1.12 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?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>