<?php
declare(strict_types=1);
ini_set('display_errors', '1');
error_reporting(E_ALL);

require_once __DIR__ . '/auth.php';
require_once __DIR__ . '/db/database.php';

if (!isset($_GET['id'])) {
    header('Location: index.php');
    exit;
}

$member_id = (int)$_GET['id'];

$pdo = get_db_connection();

// First, delete dependents of the member
$stmt = $pdo->prepare('DELETE FROM dependents WHERE member_id = ?');
$stmt->execute([$member_id]);

// Then, delete the member
$stmt = $pdo->prepare('DELETE FROM members WHERE id = ?');
$stmt->execute([$member_id]);

header('Location: index.php?success_message=Member deleted successfully');
exit;