index.php

<?php 
require_once 'config/db.php'; 
require_once 'config/functions.php'; 
isLogged();
include 'includes/header.php';

$e_count = $pdo->query("SELECT COUNT(*) FROM events")->fetchColumn();
$p_count = $pdo->query("SELECT COUNT(*) FROM participants")->fetchColumn();
$paid_count = $pdo->query("SELECT COUNT(*) FROM payments WHERE status='Paid'")->fetchColumn();
$onsite_count = $pdo->query("SELECT COUNT(*) FROM participants WHERE sleeping_onsite='Yes'")->fetchColumn();
?>
<div class="container-fluid">
    <h2 class="mb-4">Dashboard Overview</h2>
    <div class="row">
        <div class="col-md-3">
            <div class="card bg-primary text-white mb-4 shadow">
                <div class="card-body"><h5>Total Events</h5><h2><?php echo $e_count; ?></h2></div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-success text-white mb-4 shadow">
                <div class="card-body"><h5>Participants</h5><h2><?php echo $p_count; ?></h2></div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-info text-white mb-4 shadow">
                <div class="card-body"><h5>Fully Paid</h5><h2><?php echo $paid_count; ?></h2></div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card bg-warning text-dark mb-4 shadow">
                <div class="card-body"><h5>Sleeping Onsite</h5><h2><?php echo $onsite_count; ?></h2></div>
            </div>
        </div>
    </div>
</div>
<?php include 'includes/footer.php'; ?>