📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/domain/admin/index.php
<?php include '../db.php'; ?> <h2>Domain List</h2> <a href="add.php">+ Add Domain</a> | <a href="index.php?filter=expired">Expired Domains</a> | <a href="index.php">All Domains</a> <br><br> <table border="1" cellpadding="5"> <tr> <th>Client</th><th>Domain</th><th>Provider</th><th>Purchase</th><th>Expiry</th><th>Status</th><th>Actions</th> </tr> <?php $filter = $_GET['filter'] ?? ''; $where = ""; if ($filter == 'expired') { $today = date('Y-m-d'); $where = "WHERE expiry_date < '$today'"; } $stmt = $conn->query(" SELECT d.*, c.name as client_name FROM domains d JOIN clients c ON d.client_id = c.id $where ORDER BY expiry_date ASC "); foreach ($stmt->fetchAll() as $d) { echo "<tr> <td>{$d['client_name']}</td> <td>{$d['domain_name']}</td> <td>{$d['provider']}</td> <td>{$d['purchase_date']}</td> <td>{$d['expiry_date']}</td> <td>{$d['status']}</td> <td> <a href='edit.php?id={$d['id']}'>Edit</a> | <a href='delete.php?id={$d['id']}' onclick=\"return confirm('Delete this domain?')\">Delete</a> | <a href='print.php?id={$d['id']}'>Print</a> </td> </tr>"; } ?> </table>
Save
Cancel