Skip to content

Instantly share code, notes, and snippets.

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()
];