📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/emply/approvallistedit.php
<?php session_start(); include "dbconnect.php"; // Get the applicant_id from URL if (!isset($_GET['id'])) { echo "<script>alert('No applicant selected.'); window.location.href='approvallistedit.php';</script>"; exit; } $applicant_id = intval($_GET['id']); // Fetch existing data $sql = "SELECT * FROM work_permit_approval WHERE applicant_id = ?"; $stmt = $con->prepare($sql); $stmt->bind_param("i", $applicant_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows == 0) { echo "<script>alert('No work permit approval record found for this applicant.'); window.location.href='approvallistedit.php';</script>"; exit; } $data = $result->fetch_assoc(); // Update form submission if ($_SERVER["REQUEST_METHOD"] == "POST") { $work_permit_received = $_POST['work_permit_received']; $approval_date = $_POST['approval_date']; $file_path = $data['file_upload']; // default to old path // Handle new file upload if (isset($_FILES['work_permit_upload']) && $_FILES['work_permit_upload']['error'] == 0) { $file_name = $_FILES['work_permit_upload']['name']; $file_tmp = $_FILES['work_permit_upload']['tmp_name']; $ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION)); $allowed = ['jpg', 'jpeg', 'png', 'pdf']; if (in_array($ext, $allowed)) { $upload_dir = 'uploads/'; $file_path = $upload_dir . uniqid() . '_' . basename($file_name); move_uploaded_file($file_tmp, $file_path); } else { echo "<script>alert('Invalid file type.');</script>"; exit; } } // Update record $update = "UPDATE work_permit_approval SET work_permit_received = ?, approval_date = ?, file_upload = ? WHERE applicant_id = ?"; $stmt = $con->prepare($update); $stmt->bind_param("sssi", $work_permit_received, $approval_date, $file_path, $applicant_id); if ($stmt->execute()) { echo "<script>alert('Record updated successfully'); window.location.href='approvallistedit.php';</script>"; } else { echo "<script>alert('Update failed');</script>"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Edit Work Permit Approval</title> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Bootstrap 5 --> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> <!-- FontAwesome 6 --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css" integrity="sha512-yO3jOi0U0yD1YcsC+4uwsUwGqQn8PjbwLUuIzbFFTSiQ7M/yGxC7XPjfhKyLxOa6sPlUYzmhO3cb1od4wUB92g==" crossorigin="anonymous" referrerpolicy="no-referrer" /> <style> body { background: linear-gradient(135deg, #2980b9, #6dd5fa, #ffffff); font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; min-height: 100vh; padding-top: 60px; } .form-container { background-color: #ffffff; padding: 35px; border-radius: 12px; box-shadow: 0 10px 25px rgba(0, 0, 0, 0.15); max-width: 600px; margin: auto; } h3 { text-align: center; color: #2c3e50; margin-bottom: 30px; font-weight: 700; } .logout-btn { position: fixed; top: 20px; right: 20px; background-color: #dc3545; border: none; padding: 10px 20px; color: #fff; font-weight: bold; border-radius: 30px; box-shadow: 0 4px 10px rgba(220, 53, 69, 0.5); transition: background-color 0.3s ease; z-index: 1000; } .logout-btn:hover { background-color: #a71d2a; } .form-label i { margin-right: 8px; color: #2980b9; } .btn-primary { background-color: #2980b9; border: none; padding: 10px 25px; border-radius: 30px; font-weight: 600; } .btn-primary:hover { background-color: #21618c; } .btn-secondary { padding: 10px 25px; border-radius: 30px; } @media (max-width: 576px) { .form-container { padding: 25px 20px; } .logout-btn { padding: 8px 16px; font-size: 14px; } } </style> </head> <body> <!-- Logout Button --> <a href="logout.php" class="logout-btn"><i class="fas fa-sign-out-alt"></i> Logout</a> <div class="container"> <div class="form-container"> <h3><i class="fas fa-file-signature"></i> Edit Work Permit Approval</h3> <form method="POST" enctype="multipart/form-data"> <!-- Applicant ID (readonly) --> <div class="mb-3"> <label class="form-label"><i class="fas fa-id-badge"></i> Applicant ID</label> <input type="text" class="form-control" value="<?= $applicant_id ?>" readonly> </div> <!-- Work Permit Received --> <div class="mb-3"> <label class="form-label"><i class="fas fa-check-circle"></i> Work Permit Received</label> <select name="work_permit_received" class="form-control" required> <option value="Yes" <?= $data['work_permit_received'] == 'Yes' ? 'selected' : '' ?>>Yes</option> <option value="No" <?= $data['work_permit_received'] == 'No' ? 'selected' : '' ?>>No</option> </select> </div> <!-- Approval Date --> <div class="mb-3"> <label class="form-label"><i class="fas fa-calendar-alt"></i> Approval Date</label> <input type="date" name="approval_date" class="form-control" value="<?= $data['approval_date'] ?>" required> </div> <!-- Current File --> <div class="mb-3"> <label class="form-label"><i class="fas fa-file-alt"></i> Current Uploaded File</label><br> <?php if (!empty($data['file_upload'])): ?> <a href="<?= htmlspecialchars($data['file_upload']) ?>" target="_blank" class="btn btn-sm btn-outline-primary"> <i class="fas fa-eye"></i> View File </a> <?php else: ?> <span class="text-muted">No file uploaded.</span> <?php endif; ?> </div> <!-- New Upload --> <div class="mb-3"> <label class="form-label"><i class="fas fa-upload"></i> Upload New Document (Optional)</label> <input type="file" name="work_permit_upload" class="form-control" accept=".jpg,.jpeg,.png,.pdf"> </div> <!-- Buttons --> <div class="text-center mt-4"> <button type="submit" class="btn btn-primary"> <i class="fas fa-save"></i> Update Approval Record </button> <a href="approvallistedit.php" class="btn btn-secondary"> <i class="fas fa-arrow-left"></i> Cancel </a> </div> </form> </div> </div> </body> </html>
Save
Cancel