📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/domain/index.php
<?php include 'db.php'; session_start(); /* ========================================================= LOGIN CHECK ========================================================= */ if (!isset($_SESSION['user_id'])) { header("Location: login.php"); exit; } /* ========================================================= HELPER ========================================================= */ function e($value) { return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8'); } /* ========================================================= PAGINATION ========================================================= */ $limit = 10; $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; if ($page < 1) { $page = 1; } /* ========================================================= SEARCH ========================================================= */ $search = isset($_GET['search']) ? trim($_GET['search']) : ''; $where = ''; if ($search !== '') { $safeSearch = mysqli_real_escape_string( $conn, $search ); $where = " WHERE domain_name LIKE '%$safeSearch%' OR client_name LIKE '%$safeSearch%' OR client_mobile LIKE '%$safeSearch%' OR server_name LIKE '%$safeSearch%' OR email_id LIKE '%$safeSearch%' OR user_id LIKE '%$safeSearch%' "; } /* ========================================================= TOTAL RECORDS ========================================================= */ $countSql = " SELECT COUNT(*) AS total FROM domains $where "; $countRes = mysqli_query($conn, $countSql); if (!$countRes) { die("Count Error: " . mysqli_error($conn)); } $countData = mysqli_fetch_assoc($countRes); $total = (int)$countData['total']; $totalPages = max(1, (int)ceil($total / $limit)); if ($page > $totalPages) { $page = $totalPages; } $start = ($page - 1) * $limit; /* ========================================================= DOMAIN DATA ========================================================= */ $sql = " SELECT *, DATEDIFF(expiry_date, CURDATE()) AS days_left FROM domains $where ORDER BY expiry_date ASC LIMIT $start, $limit "; $result = mysqli_query($conn, $sql); if (!$result) { die("Database Error: " . mysqli_error($conn)); } /* ========================================================= STATISTICS ========================================================= */ $totalDomains = 0; $expired = 0; $last5 = 0; $next30 = 0; /* Total */ $q = mysqli_query( $conn, "SELECT COUNT(*) AS c FROM domains" ); if ($q) { $totalDomains = (int)mysqli_fetch_assoc($q)['c']; } /* Expired */ $q = mysqli_query( $conn, " SELECT COUNT(*) AS c FROM domains WHERE expiry_date < CURDATE() " ); if ($q) { $expired = (int)mysqli_fetch_assoc($q)['c']; } /* Within 5 Days */ $q = mysqli_query( $conn, " SELECT COUNT(*) AS c FROM domains WHERE expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 5 DAY) " ); if ($q) { $last5 = (int)mysqli_fetch_assoc($q)['c']; } /* Within 30 Days */ $q = mysqli_query( $conn, " SELECT COUNT(*) AS c FROM domains WHERE expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY) " ); if ($q) { $next30 = (int)mysqli_fetch_assoc($q)['c']; } /* ========================================================= DELETE MESSAGE ========================================================= */ $deleteMessage = ''; if (isset($_GET['deleted'])) { if ($_GET['deleted'] === '1') { $deleteMessage = ' <div class="success-alert"> <div class="success-icon"> <i class="bi bi-check-lg"></i> </div> <div> <strong>Domain Deleted</strong> <small>The domain record was deleted successfully.</small> </div> <button onclick="this.parentElement.remove()"> <i class="bi bi-x-lg"></i> </button> </div> '; } elseif ($_GET['deleted'] === 'notfound') { $deleteMessage = ' <div class="warning-alert"> <div class="success-icon"> <i class="bi bi-exclamation-triangle"></i> </div> <div> <strong>Record Not Found</strong> <small>The selected domain record does not exist.</small> </div> <button onclick="this.parentElement.remove()"> <i class="bi bi-x-lg"></i> </button> </div> '; } elseif ($_GET['deleted'] === 'error') { $deleteMessage = ' <div class="danger-alert"> <div class="success-icon"> <i class="bi bi-x-circle"></i> </div> <div> <strong>Delete Failed</strong> <small>Unable to delete this domain record.</small> </div> <button onclick="this.parentElement.remove()"> <i class="bi bi-x-lg"></i> </button> </div> '; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0" > <title>Domain Management | CAPAPP</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet" > <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.css" rel="stylesheet" > <style> /* ========================================================= ROOT ========================================================= */ :root{ --primary:#2563eb; --primary-dark:#1d4ed8; --sidebar:#0f172a; --sidebar2:#172554; --bg:#f4f7fb; --white:#ffffff; --text:#172033; --muted:#64748b; --border:#e2e8f0; --green:#16a34a; --orange:#f59e0b; --red:#dc2626; } /* ========================================================= RESET ========================================================= */ *{ margin:0; padding:0; box-sizing:border-box; } html, body{ min-height:100%; } body{ font-family: "Segoe UI", Arial, sans-serif; background: linear-gradient( 135deg, #eef4ff, #f8fafc, #eef6ff ); color:var(--text); } /* ========================================================= SIDEBAR ========================================================= */ .sidebar{ position:fixed; left:0; top:0; bottom:0; width:250px; background: linear-gradient( 180deg, #0f172a, #172554 ); color:#fff; z-index:2000; display:flex; flex-direction:column; box-shadow: 10px 0 35px rgba(15,23,42,.12); transition:.3s; } /* LOGO */ .sidebar-logo{ padding:22px 18px; display:flex; align-items:center; gap:12px; border-bottom: 1px solid rgba(255,255,255,.08); } .logo-icon{ width:45px; height:45px; border-radius:14px; display:flex; align-items:center; justify-content:center; background: linear-gradient( 135deg, #2563eb, #60a5fa ); font-size:21px; box-shadow: 0 8px 20px rgba(37,99,235,.3); } .logo-text strong{ display:block; font-size:16px; font-weight:800; } .logo-text span{ display:block; color:#94a3b8; font-size:10px; margin-top:2px; } /* MENU */ .sidebar-menu{ padding:18px 12px; flex:1; overflow-y:auto; } .menu-title{ color:#64748b; font-size:9px; font-weight:800; text-transform:uppercase; letter-spacing:1px; padding:8px 12px; margin-top:4px; } .menu-link{ display:flex; align-items:center; gap:11px; color:#cbd5e1; text-decoration:none; padding:11px 13px; margin:4px 0; border-radius:11px; font-size:12px; font-weight:600; transition:.2s; } .menu-link i{ width:20px; font-size:16px; text-align:center; } .menu-link:hover{ color:#fff; background: rgba(255,255,255,.08); transform:translateX(2px); } .menu-link.active{ color:#fff; background: linear-gradient( 135deg, #2563eb, #1d4ed8 ); box-shadow: 0 7px 18px rgba(37,99,235,.25); } /* SIDEBAR FOOTER */ .sidebar-footer{ padding:15px; border-top: 1px solid rgba(255,255,255,.08); } .admin-box{ display:flex; align-items:center; gap:10px; background: rgba(255,255,255,.06); border-radius:12px; padding:10px; } .admin-avatar{ width:36px; height:36px; border-radius:10px; background:#2563eb; display:flex; align-items:center; justify-content:center; } .admin-info strong{ display:block; font-size:11px; } .admin-info span{ color:#94a3b8; font-size:9px; } /* ========================================================= MOBILE SIDEBAR ========================================================= */ .sidebar-overlay{ position:fixed; inset:0; background: rgba(15,23,42,.55); backdrop-filter:blur(3px); z-index:1900; display:none; } .mobile-header{ display:none; } /* ========================================================= MAIN ========================================================= */ .main-content{ margin-left:250px; min-height:100vh; padding:20px; transition:.3s; } .dashboard-wrapper{ max-width:1700px; margin:auto; } /* ========================================================= TOP HEADER ========================================================= */ .top-header{ background: radial-gradient( circle at top right, rgba(255,255,255,.22), transparent 30% ), linear-gradient( 135deg, #2563eb, #1d4ed8, #1e40af ); border-radius:20px; padding:20px 22px; color:#fff; display:flex; justify-content:space-between; align-items:center; gap:15px; flex-wrap:wrap; box-shadow: 0 12px 30px rgba(37,99,235,.20); } .header-left{ display:flex; align-items:center; gap:13px; } .header-icon{ width:52px; height:52px; border-radius:15px; display:flex; align-items:center; justify-content:center; background: rgba(255,255,255,.16); border: 1px solid rgba(255,255,255,.20); font-size:25px; } .top-header h1{ margin:0; font-size:23px; font-weight:800; } .top-header p{ margin:4px 0 0; color:#dbeafe; font-size:12px; } .header-actions{ display:flex; gap:8px; flex-wrap:wrap; } .header-btn{ border:none; text-decoration:none; padding:11px 15px; border-radius:11px; font-size:12px; font-weight:700; display:inline-flex; align-items:center; justify-content:center; gap:7px; transition:.25s; } .header-btn:hover{ transform:translateY(-2px); } .btn-add{ background:#22c55e; color:#fff; } .btn-excel{ background:#fff; color:#166534; } .btn-dashboard{ background: rgba(255,255,255,.15); color:#fff; border: 1px solid rgba(255,255,255,.25); } /* ========================================================= SUCCESS ALERT ========================================================= */ .success-alert, .warning-alert, .danger-alert{ margin-top:15px; padding:12px 15px; border-radius:13px; display:flex; align-items:center; gap:11px; } .success-alert{ background:#ecfdf5; border:1px solid #bbf7d0; color:#166534; } .warning-alert{ background:#fffbeb; border:1px solid #fde68a; color:#92400e; } .danger-alert{ background:#fef2f2; border:1px solid #fecaca; color:#991b1b; } .success-icon{ width:36px; height:36px; border-radius:10px; display:flex; align-items:center; justify-content:center; background:rgba(255,255,255,.7); } .success-alert div:nth-child(2), .warning-alert div:nth-child(2), .danger-alert div:nth-child(2){ flex:1; } .success-alert strong, .warning-alert strong, .danger-alert strong{ display:block; font-size:12px; } .success-alert small, .warning-alert small, .danger-alert small{ display:block; margin-top:2px; font-size:10px; } .success-alert button, .warning-alert button, .danger-alert button{ border:none; background:transparent; color:inherit; } /* ========================================================= STATS ========================================================= */ .stats-row{ display:grid; grid-template-columns: repeat(4,1fr); gap:15px; margin:20px 0; } .stat-card{ position:relative; overflow:hidden; padding:18px; border-radius:17px; color:#fff; min-height:105px; box-shadow: 0 8px 25px rgba(15,23,42,.10); } .stat-card::after{ content:""; position:absolute; width:90px; height:90px; border-radius:50%; background: rgba(255,255,255,.10); right:-25px; top:-25px; } .stat-blue{ background: linear-gradient( 135deg, #2563eb, #1d4ed8 ); } .stat-green{ background: linear-gradient( 135deg, #16a34a, #15803d ); } .stat-orange{ background: linear-gradient( 135deg, #f59e0b, #d97706 ); } .stat-red{ background: linear-gradient( 135deg, #ef4444, #dc2626 ); } .stat-icon{ width:40px; height:40px; border-radius:12px; background: rgba(255,255,255,.15); display:flex; align-items:center; justify-content:center; font-size:19px; margin-bottom:8px; } .stat-number{ font-size:25px; line-height:1; font-weight:800; } .stat-label{ font-size:11px; opacity:.85; margin-top:5px; } /* ========================================================= ALERT GRID ========================================================= */ .alert-grid{ display:grid; grid-template-columns: repeat(3,1fr); gap:12px; margin-bottom:20px; } .notice{ border-radius:14px; padding:13px 15px; display:flex; align-items:center; gap:10px; font-size:12px; font-weight:700; } .notice i{ font-size:19px; } .notice-danger{ background:#fef2f2; color:#b91c1c; border:1px solid #fecaca; } .notice-warning{ background:#fffbeb; color:#92400e; border:1px solid #fde68a; } .notice-info{ background:#eff6ff; color:#1d4ed8; border:1px solid #bfdbfe; } /* ========================================================= SEARCH ========================================================= */ .search-card{ background:#fff; border:1px solid #e5eaf1; border-radius:16px; padding:14px; margin-bottom:20px; box-shadow: 0 5px 18px rgba(15,23,42,.04); } .search-form{ display:flex; gap:9px; } .search-wrap{ position:relative; flex:1; } .search-icon{ position:absolute; left:14px; top:50%; transform: translateY(-50%); color:#64748b; font-size:17px; } .search-input{ width:100%; height:47px; border: 1px solid #dbe3ed; border-radius:11px; padding: 0 14px 0 42px; outline:none; font-size:13px; } .search-input:focus{ border-color:#2563eb; box-shadow: 0 0 0 4px rgba(37,99,235,.09); } .search-btn{ border:none; background: linear-gradient( 135deg, #2563eb, #1d4ed8 ); color:#fff; border-radius:11px; padding:0 20px; font-size:13px; font-weight:700; } .clear-btn{ height:47px; display:flex; align-items:center; padding:0 16px; border-radius:11px; background:#fff; color:#64748b; border: 1px solid #dbe3ed; text-decoration:none; font-size:13px; font-weight:700; } /* ========================================================= TABLE ========================================================= */ .table-card{ border: 1px solid #e6ebf2; border-radius:17px; overflow:hidden; background:#fff; box-shadow: 0 8px 25px rgba(15,23,42,.05); } .table-title{ display:flex; justify-content:space-between; align-items:center; padding:16px 18px; border-bottom: 1px solid #edf1f5; } .table-title h3{ margin:0; font-size:15px; font-weight:800; } .total-badge{ background:#eff6ff; color:#2563eb; padding:6px 10px; border-radius:20px; font-size:11px; font-weight:800; } .table-responsive{ overflow-x:auto; } .domain-table{ width:100%; min-width:1180px; border-collapse: separate; border-spacing:0; } .domain-table thead th{ background:#f8fafc; color:#64748b; padding:13px 11px; font-size:10px; font-weight:800; text-transform:uppercase; letter-spacing:.5px; border-bottom: 1px solid #e5e7eb; white-space:nowrap; } .domain-table tbody td{ padding:13px 11px; border-bottom: 1px solid #edf1f5; vertical-align:middle; font-size:12px; } .domain-table tbody tr{ transition:.2s; } .domain-table tbody tr:hover{ background:#f8fbff; } .domain-table tbody tr:last-child td{ border-bottom:none; } /* ========================================================= TABLE ITEMS ========================================================= */ .id-badge{ width:31px; height:31px; display:inline-flex; align-items:center; justify-content:center; background:#0f172a; color:#fff; border-radius:9px; font-size:11px; font-weight:800; } .domain-name{ display:flex; align-items:center; gap:9px; } .domain-icon{ width:35px; height:35px; display:flex; align-items:center; justify-content:center; border-radius:10px; background:#eff6ff; color:#2563eb; } .domain-text{ font-weight:800; color:#1d4ed8; max-width:180px; word-break:break-word; } .hosting-text, .server-text{ display:inline-flex; align-items:center; gap:6px; padding:7px 9px; border-radius:9px; font-weight:700; } .hosting-text{ background:#f0fdf4; color:#166534; } .server-text{ background:#faf5ff; color:#7e22ce; } .password-cell{ display:flex; align-items:center; gap:5px; background:#f5f3ff; border-radius:9px; padding:6px 8px; max-width:150px; } .pass-input{ border:none; background:transparent; outline:none; width:100%; font-size:11px; font-weight:700; color:#6d28d9; } .copy-btn{ border:none; background:transparent; color:#7c3aed; cursor:pointer; } .client-name{ font-weight:700; color:#155e75; } .mobile-link{ display:inline-flex; align-items:center; gap:5px; text-decoration:none; color:#15803d; background:#f0fdf4; padding:7px 9px; border-radius:9px; font-weight:700; } .expiry{ display:inline-flex; align-items:center; gap:5px; background:#fff1f2; color:#be123c; padding:7px 9px; border-radius:9px; font-weight:700; white-space:nowrap; } /* ========================================================= STATUS ========================================================= */ .status{ display:inline-flex; align-items:center; gap:6px; padding:7px 10px; border-radius:20px; font-size:10px; font-weight:800; white-space:nowrap; } .status::before{ content:""; width:6px; height:6px; border-radius:50%; background:currentColor; } .status-active{ background:#dcfce7; color:#166534; } .status-warning{ background:#fef3c7; color:#92400e; } .status-danger{ background:#fee2e2; color:#b91c1c; } .row-warning{ background:#fffdf5; } .row-critical{ background:#fffaf2; } .row-expired{ background:#fff8f8; } /* ========================================================= ACTIONS ========================================================= */ .actions{ display:flex; align-items:center; gap:5px; } .action-btn{ width:34px; height:34px; border:none; border-radius:9px; display:flex; align-items:center; justify-content:center; text-decoration:none; cursor:pointer; transition:.2s; } .action-btn:hover{ transform: translateY(-2px); } .action-bill{ background:#dcfce7; color:#15803d; } .action-edit{ background:#dbeafe; color:#1d4ed8; } .action-delete{ background:#fee2e2; color:#dc2626; } .action-delete:hover{ background:#dc2626; color:#fff; } /* ========================================================= EMPTY ========================================================= */ .empty-state{ text-align:center; padding:60px 20px; } .empty-icon{ width:70px; height:70px; margin:auto; border-radius:20px; background:#eff6ff; color:#2563eb; display:flex; align-items:center; justify-content:center; font-size:30px; margin-bottom:14px; } .empty-state h4{ font-size:17px; font-weight:800; } .empty-state p{ color:#64748b; font-size:12px; } /* ========================================================= PAGINATION ========================================================= */ .pagination-wrap{ padding:16px; border-top: 1px solid #edf1f5; display:flex; align-items:center; justify-content:space-between; gap:10px; } .pagination-info{ color:#64748b; font-size:11px; font-weight:600; } .pagination{ margin:0; display:flex; gap:4px; } .page-link{ min-width:34px; height:34px; display:flex; align-items:center; justify-content:center; border:none !important; border-radius:9px !important; color:#2563eb; font-size:12px; font-weight:700; background:#f8fafc; } .page-link:hover{ background:#eff6ff; color:#1d4ed8; } .page-item.active .page-link{ background:#2563eb; color:#fff; } .page-item.disabled .page-link{ color:#94a3b8; background:#f8fafc; } /* ========================================================= DELETE MODAL ========================================================= */ .delete-modal-overlay{ position:fixed; inset:0; background: rgba(15,23,42,.65); backdrop-filter:blur(5px); display:none; align-items:center; justify-content:center; z-index:9999; padding:20px; } .delete-modal-overlay.show{ display:flex; } .delete-modal{ width:100%; max-width:420px; background:#fff; border-radius:20px; padding:25px; text-align:center; box-shadow: 0 25px 70px rgba(0,0,0,.25); animation:modalIn .2s ease; } @keyframes modalIn{ from{ opacity:0; transform: scale(.94) translateY(10px); } to{ opacity:1; transform: scale(1) translateY(0); } } .delete-icon{ width:62px; height:62px; margin:auto; display:flex; align-items:center; justify-content:center; border-radius:18px; background:#fee2e2; color:#dc2626; font-size:27px; } .delete-modal h3{ margin-top:15px; font-size:18px; font-weight:800; } .delete-modal p{ color:#64748b; font-size:12px; line-height:1.6; margin:8px 0 20px; } .modal-actions{ display:flex; gap:9px; } .modal-btn{ flex:1; height:45px; border:none; border-radius:11px; font-size:12px; font-weight:800; cursor:pointer; } .cancel-delete{ background:#f1f5f9; color:#475569; } .confirm-delete{ background:#dc2626; color:#fff; } /* ========================================================= RESPONSIVE ========================================================= */ @media(max-width:1100px){ .stats-row{ grid-template-columns: repeat(2,1fr); } .alert-grid{ grid-template-columns:1fr; } } @media(max-width:900px){ .sidebar{ transform:translateX(-100%); } .sidebar.open{ transform:translateX(0); } .sidebar-overlay.show{ display:block; } .main-content{ margin-left:0; padding:10px; } .mobile-header{ display:flex; align-items:center; justify-content:space-between; margin-bottom:10px; background:#fff; padding:10px 12px; border-radius:14px; box-shadow: 0 5px 20px rgba(15,23,42,.07); } .mobile-brand{ display:flex; align-items:center; gap:9px; font-weight:800; font-size:13px; } .mobile-brand i{ width:35px; height:35px; border-radius:10px; display:flex; align-items:center; justify-content:center; color:#fff; background:#2563eb; } .mobile-menu-btn{ width:38px; height:38px; border:none; border-radius:10px; background:#eff6ff; color:#2563eb; font-size:19px; } } @media(max-width:768px){ .top-header{ padding:16px; } .top-header h1{ font-size:18px; } .header-actions{ width:100%; } .header-btn{ flex:1; } .stats-row{ grid-template-columns: 1fr 1fr; gap:10px; } .search-form{ flex-direction:column; } .search-btn, .clear-btn{ width:100%; height:45px; } .pagination-wrap{ flex-direction:column; align-items:center; } } @media(max-width:480px){ .stats-row{ grid-template-columns:1fr; } .header-actions{ flex-direction:column; } .header-btn{ width:100%; } .table-title{ align-items:flex-start; flex-direction:column; } } </style> </head> <body> <!-- ===================================================== SIDEBAR ===================================================== --> <aside class="sidebar" id="sidebar"> <div class="sidebar-logo"> <div class="logo-icon"> <i class="bi bi-globe2"></i> </div> <div class="logo-text"> <strong>CAPAPP</strong> <span>Domain Management</span> </div> </div> <div class="sidebar-menu"> <div class="menu-title"> Main Menu </div> <a href="dashboard.php" class="menu-link"> <i class="bi bi-grid-1x2-fill"></i> <span>Dashboard</span> </a> <a href="index.php" class="menu-link active"> <i class="bi bi-globe2"></i> <span>Domain Management</span> </a> <a href="add-domain.php" class="menu-link"> <i class="bi bi-plus-circle-fill"></i> <span>Add Domain</span> </a> <div class="menu-title"> Management </div> <a href="export-excel.php" class="menu-link"> <i class="bi bi-file-earmark-excel-fill"></i> <span>Export Excel</span> </a> <a href="dashboard.php" class="menu-link"> <i class="bi bi-bar-chart-fill"></i> <span>Reports</span> </a> <div class="menu-title"> Account </div> <a href="logout.php" class="menu-link"> <i class="bi bi-box-arrow-right"></i> <span>Logout</span> </a> </div> <div class="sidebar-footer"> <div class="admin-box"> <div class="admin-avatar"> <i class="bi bi-person-fill"></i> </div> <div class="admin-info"> <strong> <?= e($_SESSION['user_name'] ?? 'Administrator') ?> </strong> <span> Logged In </span> </div> </div> </div> </aside> <div class="sidebar-overlay" id="sidebarOverlay" onclick="closeSidebar()" ></div> <!-- ===================================================== MAIN ===================================================== --> <main class="main-content"> <!-- MOBILE HEADER --> <div class="mobile-header"> <div class="mobile-brand"> <i class="bi bi-globe2"></i> CAPAPP Domain Manager </div> <button type="button" class="mobile-menu-btn" onclick="openSidebar()" > <i class="bi bi-list"></i> </button> </div> <div class="dashboard-wrapper"> <!-- HEADER --> <div class="top-header"> <div class="header-left"> <div class="header-icon"> <i class="bi bi-globe2"></i> </div> <div> <h1> Domain Management </h1> <p> Manage domains, hosting, expiry and client information </p> </div> </div> <div class="header-actions"> <a href="export-excel.php" class="header-btn btn-excel" > <i class="bi bi-file-earmark-excel-fill"></i> Excel </a> <a href="add-domain.php" class="header-btn btn-add" > <i class="bi bi-plus-circle-fill"></i> Add Domain </a> <a href="dashboard.php" class="header-btn btn-dashboard" > <i class="bi bi-house-fill"></i> Dashboard </a> </div> </div> <?= $deleteMessage ?> <!-- STATISTICS --> <div class="stats-row"> <div class="stat-card stat-blue"> <div class="stat-icon"> <i class="bi bi-globe"></i> </div> <div class="stat-number"> <?= $totalDomains ?> </div> <div class="stat-label"> Total Domains </div> </div> <div class="stat-card stat-green"> <div class="stat-icon"> <i class="bi bi-calendar-check"></i> </div> <div class="stat-number"> <?= $next30 ?> </div> <div class="stat-label"> Expiring Within 30 Days </div> </div> <div class="stat-card stat-orange"> <div class="stat-icon"> <i class="bi bi-alarm"></i> </div> <div class="stat-number"> <?= $last5 ?> </div> <div class="stat-label"> Expiring Within 5 Days </div> </div> <div class="stat-card stat-red"> <div class="stat-icon"> <i class="bi bi-x-circle"></i> </div> <div class="stat-number"> <?= $expired ?> </div> <div class="stat-label"> Expired Domains </div> </div> </div> <!-- ALERTS --> <div class="alert-grid"> <div class="notice notice-danger"> <i class="bi bi-x-octagon-fill"></i> <span> <?= $expired ?> domain(s) already expired </span> </div> <div class="notice notice-warning"> <i class="bi bi-exclamation-triangle-fill"></i> <span> <?= $last5 ?> domain(s) need urgent renewal </span> </div> <div class="notice notice-info"> <i class="bi bi-info-circle-fill"></i> <span> <?= $next30 ?> domain(s) expire within 30 days </span> </div> </div> <!-- SEARCH --> <div class="search-card"> <form method="GET" class="search-form" > <div class="search-wrap"> <i class="bi bi-search search-icon"></i> <input type="text" name="search" class="search-input" placeholder="Search domain, client, mobile, hosting, email or user..." value="<?= e($search) ?>" > </div> <button type="submit" class="search-btn" > <i class="bi bi-search"></i> Search </button> <?php if ($search !== '') { ?> <a href="index.php" class="clear-btn" > <i class="bi bi-x-lg"></i> Clear </a> <?php } ?> </form> </div> <!-- TABLE --> <div class="table-card"> <div class="table-title"> <h3> <i class="bi bi-list-ul text-primary"></i> Domain Records </h3> <span class="total-badge"> <?= $total ?> Records </span> </div> <div class="table-responsive"> <table class="domain-table"> <thead> <tr> <th>ID</th> <th>Domain</th> <th>Hosting</th> <th>Password</th> <th>Expiry</th> <th>Client</th> <th>Mobile</th> <th>Status</th> <th>Server User</th> <th>Action</th> </tr> </thead> <tbody> <?php if (mysqli_num_rows($result) > 0) { ?> <?php while ($row = mysqli_fetch_assoc($result)) { ?> <?php $days = (int)$row['days_left']; $rowClass = ''; $status = ''; $statusClass = ''; if ($days > 30) { $status = 'Active'; $statusClass = 'status-active'; } elseif ($days > 5) { $status = 'Expiring Soon'; $statusClass = 'status-warning'; $rowClass = 'row-warning'; } elseif ($days >= 0) { $status = 'Last ' . $days . ' Days'; $statusClass = 'status-warning'; $rowClass = 'row-critical'; } else { $status = 'Expired'; $statusClass = 'status-danger'; $rowClass = 'row-expired'; } ?> <tr class="<?= e($rowClass) ?>"> <td> <span class="id-badge"> <?= (int)$row['id'] ?> </span> </td> <td> <div class="domain-name"> <div class="domain-icon"> <i class="bi bi-globe2"></i> </div> <span class="domain-text"> <?= e($row['domain_name']) ?> </span> </div> </td> <td> <span class="hosting-text"> <i class="bi bi-hdd-network"></i> <?= e( $row['server_name'] ?: '-' ) ?> </span> </td> <td> <div class="password-cell"> <input type="password" class="pass-input" value="<?= e( $row['server_password'] ?? '' ) ?>" readonly > <button type="button" class="copy-btn" title="Show Password" onclick="togglePassword(this)" > <i class="bi bi-eye"></i> </button> </div> </td> <td> <span class="expiry"> <i class="bi bi-calendar-event"></i> <?= e( $row['expiry_date'] ) ?> </span> </td> <td> <span class="client-name"> <?= e( $row['client_name'] ?: '-' ) ?> </span> </td> <td> <?php if (!empty($row['client_mobile'])) { ?> <a href="tel:<?= e( $row['client_mobile'] ) ?>" class="mobile-link" > <i class="bi bi-telephone-fill"></i> <?= e( $row['client_mobile'] ) ?> </a> <?php } else { ?> <span class="text-muted"> - </span> <?php } ?> </td> <td> <span class="status <?= e($statusClass) ?>" > <?= e($status) ?> </span> </td> <td> <span class="server-text"> <i class="bi bi-person-circle"></i> <?= e( $row['user_id'] ?: '-' ) ?> </span> </td> <td> <div class="actions"> <a href="bill.php?id=<?= (int)$row['id'] ?>" class="action-btn action-bill" title="Generate Bill" > <i class="bi bi-receipt"></i> </a> <a href="edit-domain.php?id=<?= (int)$row['id'] ?>" class="action-btn action-edit" title="Edit Domain" > <i class="bi bi-pencil-square"></i> </a> <button type="button" class="action-btn action-delete" title="Delete Domain" onclick="openDeleteModal(<?= (int)$row['id'] ?>)" > <i class="bi bi-trash3-fill"></i> </button> </div> </td> </tr> <?php } ?> <?php } else { ?> <tr> <td colspan="10"> <div class="empty-state"> <div class="empty-icon"> <i class="bi bi-search"></i> </div> <h4> No Domains Found </h4> <p> No domain matched your search. </p> </div> </td> </tr> <?php } ?> </tbody> </table> </div> <!-- PAGINATION --> <?php if ($total > 0) { ?> <div class="pagination-wrap"> <div class="pagination-info"> Showing <?= $start + 1 ?> - <?= min($start + $limit, $total) ?> of <?= $total ?> records </div> <nav> <ul class="pagination"> <!-- PREVIOUS --> <?php if ($page > 1) { ?> <li class="page-item"> <a class="page-link" href="?page=<?= $page - 1 ?>&search=<?= urlencode($search) ?>" title="Previous" > <i class="bi bi-chevron-left"></i> </a> </li> <?php } else { ?> <li class="page-item disabled"> <span class="page-link"> <i class="bi bi-chevron-left"></i> </span> </li> <?php } ?> <?php /* * Pagination window */ $startPage = max(1, $page - 2); $endPage = min( $totalPages, $page + 2 ); /* First page */ if ($startPage > 1) { ?> <li class="page-item"> <a class="page-link" href="?page=1&search=<?= urlencode($search) ?>" > 1 </a> </li> <?php if ($startPage > 2) { ?> <li class="page-item disabled"> <span class="page-link"> ... </span> </li> <?php } ?> <?php } ?> <?php for ( $i = $startPage; $i <= $endPage; $i++ ) { ?> <li class="page-item <?= $i == $page ? 'active' : '' ?>" > <a class="page-link" href="?page=<?= $i ?>&search=<?= urlencode($search) ?>" > <?= $i ?> </a> </li> <?php } ?> <?php if ($endPage < $totalPages) { ?> <?php if ($endPage < $totalPages - 1) { ?> <li class="page-item disabled"> <span class="page-link"> ... </span> </li> <?php } ?> <li class="page-item"> <a class="page-link" href="?page=<?= $totalPages ?>&search=<?= urlencode($search) ?>" > <?= $totalPages ?> </a> </li> <?php } ?> <!-- NEXT --> <?php if ($page < $totalPages) { ?> <li class="page-item"> <a class="page-link" href="?page=<?= $page + 1 ?>&search=<?= urlencode($search) ?>" title="Next" > <i class="bi bi-chevron-right"></i> </a> </li> <?php } else { ?> <li class="page-item disabled"> <span class="page-link"> <i class="bi bi-chevron-right"></i> </span> </li> <?php } ?> </ul> </nav> </div> <?php } ?> </div> </div> </main> <!-- ===================================================== DELETE MODAL ===================================================== --> <div class="delete-modal-overlay" id="deleteModal" > <div class="delete-modal"> <div class="delete-icon"> <i class="bi bi-trash3-fill"></i> </div> <h3> Delete Domain? </h3> <p> This domain record will be permanently deleted from the database. This action cannot be undone. </p> <form method="POST" action="delete-domain.php" id="deleteForm" > <input type="hidden" name="id" id="deleteDomainId" value="" > <div class="modal-actions"> <button type="button" class="modal-btn cancel-delete" onclick="closeDeleteModal()" > <i class="bi bi-x-lg"></i> Cancel </button> <button type="submit" class="modal-btn confirm-delete" > <i class="bi bi-trash3-fill"></i> Delete Domain </button> </div> </form> </div> </div> <script> /* ========================================================= SIDEBAR ========================================================= */ function openSidebar(){ document .getElementById('sidebar') .classList.add('open'); document .getElementById('sidebarOverlay') .classList.add('show'); } function closeSidebar(){ document .getElementById('sidebar') .classList.remove('open'); document .getElementById('sidebarOverlay') .classList.remove('show'); } /* ========================================================= DELETE MODAL ========================================================= */ function openDeleteModal(id){ document.getElementById( 'deleteDomainId' ).value = id; document.getElementById( 'deleteModal' ).classList.add('show'); } function closeDeleteModal(){ document.getElementById( 'deleteModal' ).classList.remove('show'); } document .getElementById('deleteModal') .addEventListener( 'click', function(e){ if(e.target === this){ closeDeleteModal(); } } ); document.addEventListener( 'keydown', function(e){ if(e.key === 'Escape'){ closeDeleteModal(); } } ); /* ========================================================= PASSWORD SHOW/HIDE ========================================================= */ function togglePassword(button){ const input = button.parentElement .querySelector('.pass-input'); const icon = button.querySelector('i'); if(input.type === 'password'){ input.type = 'text'; icon.classList.remove( 'bi-eye' ); icon.classList.add( 'bi-eye-slash' ); } else{ input.type = 'password'; icon.classList.remove( 'bi-eye-slash' ); icon.classList.add( 'bi-eye' ); } } </script> </body> </html>
Save
Cancel