motleyCreu

try {
    // 1. KPI COUNTS
    
    $stats = [
        'candidates' => $pdo->query("SELECT COUNT(*) FROM candidates")->fetchColumn(),
        'open_jobs'  => $pdo->query("SELECT COUNT(*) FROM job_orders WHERE status='Open'")->fetchColumn(),
        'hired'      => $pdo->query("SELECT COUNT(*) FROM candidates WHERE status='Hired'")->fetchColumn(),
        'pending_req'=> $pdo->query("SELECT COUNT(*) FROM job_orders WHERE status='Pending'")->fetchColumn()
    ];