<?php include '../db.php';

$id = $_GET['id'];
$stmt = $conn->prepare("SELECT * FROM emails WHERE id=?");
$stmt->execute([$id]);
$e = $stmt->fetch();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $stmt = $conn->prepare("UPDATE emails SET client_id=?, email_address=?, provider=?, renewal_date=? WHERE id=?");
    $stmt->execute([
        $_POST['client_id'],
        $_POST['email_address'],
        $_POST['provider'],
        $_POST['renewal_date'],
        $id
    ]);
    header("Location: index.php");
}
?>

<h2>Edit Email Record</h2>
<form method="post">
    <label>Client:</label>
    <select name="client_id" required>
        <?php
        $clients = $conn->query("SELECT id, name FROM clients")->fetchAll();
        foreach ($clients as $c) {
            $selected = ($c['id'] == $e['client_id']) ? 'selected' : '';
            echo "<option value='{$c['id']}' $selected>{$c['name']}</option>";
        }
        ?>
    </select><br>

    <input type="email" name="email_address" value="<?= $e['email_address'] ?>" required><br>
    <input name="provider" value="<?= $e['provider'] ?>" required><br>
    <input type="date" name="renewal_date" value="<?= $e['renewal_date'] ?>" required><br>

    <button type="submit">Update</button>
</form>
