prepare($sql); $stmt->execute($params); $members = $stmt->fetchAll(); // Fetch dependents for each member $dependentsByMember = []; if ($members) { $memberIds = array_column($members, 'id'); if (!empty($memberIds)) { $placeholders = implode(',', array_fill(0, count($memberIds), '?')); $stmt = $pdo->prepare("SELECT * FROM dependents WHERE member_id IN ($placeholders) ORDER BY created_at DESC"); $stmt->execute($memberIds); $dependents = $stmt->fetchAll(); foreach ($dependents as $dependent) { $dependentsByMember[$dependent['member_id']][] = $dependent; } } } function calculate_age($dob) { if (!$dob) return 'N/A'; $birthDate = new DateTime($dob); $today = new DateTime('today'); $age = $birthDate->diff($today)->y; return $age; } include __DIR__ . '/layout/header.php'; ?>

Members

Add New Member
Name Email Job Title Department Actions
No members found.
Add Dependent Edit Delete
Dependent Name Relationship Date of Birth Age Actions
Edit Delete