prepare($sql);
$stmt->bind_param('i', $id);
$stmt->execute();
$res = $stmt->get_result();
if (!$res || $res->num_rows === 0) die("Invalid entry");
$row = $res->fetch_assoc();
$name = $row['full_name'];
$email = $row['email'];
$competition_id = $row['competition_id'];
$filePath = __DIR__ . "/../certificates/competition_{$competition_id}/" . strtolower(str_replace(' ', '_', $name)) . ".pdf";
if (!file_exists($filePath)) die("Certificate not found for $name");
$subject = "Your UCF Competition Certificate";
$body = "Dear {$name},
Resending your competition certificate as requested.
Regards,
United Cultural Forum
";
admin_send_email($email, $subject, $body);
echo "✅ Certificate resent successfully to {$email}
";
?>