📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/admin/regitationlist.php
<?php include "dbconnect.php"; // Database Connection $sql = "SELECT * FROM job_applicants ORDER BY id DESC"; $stmt = $con->prepare($sql); $stmt->execute(); $result = $stmt->get_result(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Job Applicants List</title> <!-- CSS Links --> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css"> <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css"> <style> body { background: linear-gradient(to right, #f7f9fc, #e9eff5); font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; } .container { margin-top: 40px; background: #fff; padding: 30px; border-radius: 12px; box-shadow: 0 5px 15px rgba(0,0,0,0.1); } h3 { color: #0056b3; font-weight: 700; margin-bottom: 30px; text-align: center; } .logout-btn { position: absolute; top: 20px; right: 20px; } .btn { border-radius: 50px; font-size: 14px; } .table th { background-color: #0056b3; color: white; font-weight: bold; font-size: 14px; } .table td { vertical-align: middle; font-size: 13px; } .table tbody tr:hover { background-color: #f1f9ff; } .form-control { border-radius: 10px; } .table-responsive { margin-top: 20px; } .name-with-icon::before { content: "\f007"; font-family: "Font Awesome 6 Free"; font-weight: 900; margin-right: 6px; color: #007bff; } @media (max-width: 768px) { .logout-btn { position: static; display: block; margin: 10px auto; width: 100%; } .table th, .table td { font-size: 12px; white-space: nowrap; } .btn-sm { font-size: 11px; padding: 5px 10px; } .row .form-control { margin-bottom: 10px; } h3 { font-size: 20px; } } .action-btn { border-radius: 50%; padding: 6px 10px; font-size: 14px; } </style> </head> <body> <div class="container position-relative"> <a href="logout.php" class="btn btn-danger logout-btn"><i class="fas fa-sign-out-alt"></i> Logout</a> <h3>Job Applicants List</h3> <!-- Filters --> <div class="row mb-3"> <div class="col-md-3"> <input type="text" id="searchBox" class="form-control" placeholder="Search by Passport No or Country"> </div> <div class="col-md-3"> <input type="date" id="fromDate" class="form-control"> </div> <div class="col-md-3"> <input type="date" id="toDate" class="form-control"> </div> <div class="col-md-3"> <button id="filterBtn" class="btn btn-primary w-100"><i class="fas fa-filter"></i> Filter</button> </div> </div> <!-- Table --> <div class="table-responsive"> <table id="applicantsTable" class="table table-bordered table-striped"> <thead> <tr> <th>#</th> <th><i class="fas fa-user"></i> Name</th> <th><i class="fas fa-user-tie"></i> Father</th> <th><i class="fas fa-passport"></i> Passport</th> <th><i class="fas fa-envelope"></i> Email</th> <th><i class="fas fa-phone"></i> Mobile</th> <th><i class="fas fa-briefcase"></i> Position</th> <th><i class="fas fa-globe"></i> Country</th> <th><i class="fas fa-graduation-cap"></i> Qualification</th> <th><i class="fas fa-briefcase"></i> Exp</th> <th><i class="fas fa-file-alt"></i> Document</th> <th><i class="fas fa-cogs"></i></th> </tr> </thead> <tbody> <?php while ($row = $result->fetch_assoc()) { ?> <tr> <td><?= $row['id'] ?></td> <td class="name-with-icon"><?= htmlspecialchars($row['name']) ?></td> <td><i class="fas fa-user-friends text-secondary me-1"></i><?= htmlspecialchars($row['father_name']) ?></td> <td><i class="fas fa-id-card text-secondary me-1"></i><?= htmlspecialchars($row['passport_no']) ?></td> <td><i class="fas fa-envelope text-secondary me-1"></i><?= htmlspecialchars($row['email_id']) ?></td> <td><i class="fas fa-phone text-secondary me-1"></i><?= htmlspecialchars($row['mobile_no']) ?></td> <td><i class="fas fa-briefcase text-secondary me-1"></i><?= htmlspecialchars($row['position']) ?></td> <td><i class="fas fa-flag text-secondary me-1"></i><?= htmlspecialchars($row['job_country']) ?></td> <td><i class="fas fa-graduation-cap text-secondary me-1"></i><?= htmlspecialchars($row['qualification']) ?></td> <td><i class="fas fa-briefcase text-secondary me-1"></i><?= htmlspecialchars($row['experience']) ?></td> <td> <?php if ($row['document_upload']) { ?> <span><?= basename($row['document_upload']) ?></span><br> <a href="uploads/<?= $row['document_upload'] ?>" target="_blank" class="btn btn-sm btn-info mt-1"><i class="fas fa-eye"></i></a> <a href="uploads/<?= $row['document_upload'] ?>" download class="btn btn-sm btn-success mt-1"><i class="fas fa-download"></i></a> <?php } else { echo "N/A"; } ?> </td> <td> <button class="btn btn-sm btn-warning action-btn" onClick="confirmEdit(<?= $row['id'] ?>)"><i class="fas fa-edit"></i></button> <button class="btn btn-sm btn-danger action-btn" onClick="confirmDelete(<?= $row['id'] ?>)"><i class="fas fa-trash-alt"></i></button> </td> </tr> <?php } ?> </tbody> </table> </div> </div> <!-- JS Scripts --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.2.2/js/dataTables.buttons.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.html5.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.print.min.js"></script> <script> $(document).ready(function () { var table = $('#applicantsTable').DataTable({ dom: 'Bfrtip', buttons: ['copy', 'csv', 'excel', 'pdf', 'print'], pageLength: 10 }); // ✅ Search by Passport No or Country $('#searchBox').on('keyup', function () { var searchTerm = this.value.toLowerCase(); table.rows().every(function () { var rowData = this.data(); var passport = rowData[3].toLowerCase(); // Passport column var country = rowData[7].toLowerCase(); // Country column if (passport.includes(searchTerm) || country.includes(searchTerm)) { $(this.node()).show(); } else { $(this.node()).hide(); } }); }); $('#filterBtn').on('click', function () { var fromDate = $('#fromDate').val(); var toDate = $('#toDate').val(); // Note: Date filter requires server-side or custom JS filter table.draw(); }); }); function confirmEdit(id) { window.location.href = "regitationedit.php?id=" + id; } function confirmDelete(id) { if (confirm("Are you sure you want to delete this applicant?")) { window.location.href = "regitationdelete.php?id=" + id; } } </script> </body> </html>
Save
Cancel