prepare("
SELECT name, designation, photo, email, mobile, address
FROM office_bearers
WHERE status = 'active'
ORDER BY sort_order ASC, created_at DESC
");
$stmt->execute();
$office_bearers = $stmt->fetchAll(PDO::FETCH_ASSOC);
include 'header.php';
include 'navbar.php';
?>
Office Bearers
![<?php echo htmlspecialchars($bearer['name']); ?>](<?php echo $bearer['photo'] ? 'uploads/office-bearers/' . htmlspecialchars($bearer['photo']) : 'img/default-avatar.png'; ?>){kind=avatar}