📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/emply/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" /> <title>Job Applicants List</title> <!-- CSS Libraries --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet"> <link href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css" rel="stylesheet"> <link href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css" rel="stylesheet"> <style> body { background-color: #f0f8ff; font-family: 'Arial', sans-serif; } .container { margin-top: 30px; background: white; padding: 30px; border-radius: 10px; box-shadow: 0 4px 8px rgba(0,0,0,0.1); } h3 { color: #007bff; font-weight: bold; margin-bottom: 30px; } .table th, .table td { text-align: center; font-size: 14px; vertical-align: middle; } .table th { background-color: #007bff; color: white; } .table tbody tr:hover { background-color: #f1f1f1; cursor: pointer; } .btn-sm { font-size: 12px; } .logout-btn { position: absolute; top: 20px; right: 20px; } .form-control { border-radius: 10px; } @media (max-width: 768px) { .table th, .table td { font-size: 12px; } .btn-sm { font-size: 10px; padding: 4px 6px; } } </style> </head> <body> <div class="container"> <h3 class="text-center"><i class="bi bi-people-fill"></i> Job Applicants List</h3> <a href="logout.php" class="btn btn-danger logout-btn"><i class="bi bi-box-arrow-right"></i> Logout</a> <!-- Filter Section --> <div class="row mb-4"> <div class="col-md-3"> <input type="text" id="searchBox" class="form-control" placeholder="🔍 Search Passport No"> </div> <div class="col-md-3"> <input type="date" id="fromDate" class="form-control" placeholder="From Date"> </div> <div class="col-md-3"> <input type="date" id="toDate" class="form-control" placeholder="To Date"> </div> <div class="col-md-3"> <button id="filterBtn" class="btn btn-primary w-100"><i class="bi bi-funnel-fill"></i> Filter</button> </div> </div> <div class="table-responsive"> <table id="applicantsTable" class="table table-bordered table-striped"> <thead> <tr> <th><i class="bi bi-hash"></i> ID</th> <th><i class="bi bi-person-fill"></i> Name</th> <th><i class="bi bi-person-badge-fill"></i> Father</th> <th><i class="bi bi-passport-fill"></i> Passport</th> <th><i class="bi bi-envelope-fill"></i> Email</th> <th><i class="bi bi-telephone-fill"></i> Mobile</th> <th><i class="bi bi-briefcase-fill"></i> Position</th> <th><i class="bi bi-globe2"></i> Country</th> <th><i class="bi bi-mortarboard-fill"></i> Qualification</th> <th><i class="bi bi-clock-fill"></i> Experience</th> <th><i class="bi bi-paperclip"></i> Document</th> <th><i class="bi bi-gear-fill"></i> Actions</th> </tr> </thead> <tbody> <?php while ($row = $result->fetch_assoc()) { ?> <tr> <td><?= $row['id'] ?></td> <td><?= $row['name'] ?></td> <td><?= $row['father_name'] ?></td> <td><?= $row['passport_no'] ?></td> <td><?= $row['email_id'] ?></td> <td><?= $row['mobile_no'] ?></td> <td><?= $row['position'] ?></td> <td><?= $row['job_country'] ?></td> <td><?= $row['qualification'] ?></td> <td><?= $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"><i class="bi bi-eye-fill"></i></a> <a href="uploads/<?= $row['document_upload'] ?>" download class="btn btn-sm btn-success"><i class="bi bi-download"></i></a> <?php } else { echo "N/A"; } ?> </td> <td> <button class="btn btn-sm btn-warning" onClick="confirmEdit(<?= $row['id'] ?>)"><i class="bi bi-pencil-square"></i></button> </td> </tr> <?php } ?> </tbody> </table> </div> </div> <!-- JS Libraries --> <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 }); $('#searchBox').on('keyup', function () { table.columns(3).search(this.value).draw(); // Search passport_no }); $('#filterBtn').on('click', function () { var fromDate = $('#fromDate').val(); var toDate = $('#toDate').val(); table.columns(10).search(fromDate + '|' + toDate, true, false).draw(); // Date filter placeholder }); }); function confirmEdit(id) { let code = prompt("Enter Security Code to Edit:"); if (code === "1234") { window.location.href = "regitationedit.php?id=" + id; } else { alert("Invalid Security Code!"); } } </script> </body> </html>
Save
Cancel