📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/domain/emails/index.php
<?php include '../db.php'; ?> <h2>Email Records</h2> <a href="add.php">+ Add Email</a><br><br> <table border="1" cellpadding="5"> <tr> <th>Client</th><th>Email Address</th><th>Provider</th><th>Renewal Date</th><th>Status</th><th>Actions</th> </tr> <?php $stmt = $conn->query(" SELECT e.*, c.name as client_name FROM emails e JOIN clients c ON e.client_id = c.id ORDER BY e.renewal_date ASC "); foreach ($stmt->fetchAll() as $e) { echo "<tr> <td>{$e['client_name']}</td> <td>{$e['email_address']}</td> <td>{$e['provider']}</td> <td>{$e['renewal_date']}</td> <td>{$e['status']}</td> <td> <a href='edit.php?id={$e['id']}'>Edit</a> | <a href='delete.php?id={$e['id']}' onclick=\"return confirm('Delete this email record?')\">Delete</a> </td> </tr>"; } ?> </table>
Save
Cancel