📁 File Manager
Editing:
/home/wvl7mof7402e/www/domain/emails/edit.php.php
<?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>
Save
Cancel