📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/emply/medical.php
<?php session_start(); include "dbconnect.php"; // Database Connection if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) { $_SESSION['submitted'] = true; $applicant_id = $_POST['applicant_id']; $medical_date = $_POST['medical_date']; $medical_exp_date = $_POST['medical_exp_date']; $sleep = $_POST['sleep']; // Handle file upload if (isset($_FILES['medical_upload']) && $_FILES['medical_upload']['error'] == 0) { $file_name = $_FILES['medical_upload']['name']; $file_tmp_name = $_FILES['medical_upload']['tmp_name']; $file_ext = pathinfo($file_name, PATHINFO_EXTENSION); $allowed_extensions = ['jpg', 'jpeg', 'png', 'pdf']; if (in_array(strtolower($file_ext), $allowed_extensions)) { $upload_dir = 'uploads/'; $file_path = $upload_dir . uniqid() . '_' . basename($file_name); move_uploaded_file($file_tmp_name, $file_path); } else { echo "<script>alert('Invalid file type. Only JPG, PNG, and PDF files are allowed.');</script>"; exit; } } else { $file_path = null; } // Check if the record already exists $sql_check = "SELECT * FROM medical_records WHERE applicant_id = '$applicant_id' AND medical_date = '$medical_date'"; $result_check = $con->query($sql_check); if ($result_check->num_rows > 0) { echo "<script>alert('Record already exists for this applicant with the same medical date.');</script>"; } else { $sql = "INSERT INTO medical_records (applicant_id, medical_date, medical_exp_date, medical_upload, sleep) VALUES ('$applicant_id', '$medical_date', '$medical_exp_date', '$file_path', '$sleep')"; if ($con->query($sql) === TRUE) { echo "<script>alert('Medical Record Added Successfully');</script>"; } else { echo "<script>alert('Error: " . $con->error . "');</script>"; } } } elseif (isset($_SESSION['submitted'])) { echo "<script>alert('You have already submitted the form.');</script>"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Medical Registration</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Bootstrap CDN --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <!-- jQuery CDN --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!-- Bootstrap Bundle (for dismissible alert) --> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> <style> body { background: linear-gradient(to right, #4facfe, #00f2fe); font-family: 'Segoe UI', sans-serif; margin: 0; padding: 0; } .container { padding-top: 40px; padding-bottom: 60px; } .form-container { background: #ffffff; padding: 35px 30px; border-radius: 12px; box-shadow: 0 12px 25px rgba(0, 0, 0, 0.15); max-width: 750px; margin: auto; transition: all 0.3s ease-in-out; } h3 { font-size: 26px; color: #333; font-weight: 600; margin-bottom: 25px; } .form-control { border-radius: 10px; padding: 14px; font-size: 16px; border: 1px solid #ccc; transition: 0.3s ease-in-out; } .form-control:focus { border-color: #00c6ff; box-shadow: 0 0 5px rgba(0, 198, 255, 0.5); } .btn-primary { padding: 14px; font-size: 16px; border-radius: 10px; width: 100%; background-color: #007bff; border-color: #007bff; box-shadow: 0 4px 10px rgba(0, 123, 255, 0.3); transition: all 0.3s ease-in-out; } .btn-primary:hover { background-color: #0056b3; border-color: #004085; box-shadow: 0 6px 15px rgba(0, 86, 179, 0.4); } .alert { font-size: 15px; font-weight: 500; } .logout-btn { position: fixed; top: 15px; right: 15px; background-color: #dc3545; color: white; padding: 10px 20px; border-radius: 6px; font-size: 14px; text-decoration: none; transition: 0.3s ease; z-index: 1000; } .logout-btn:hover { background-color: #c82333; } @media (max-width: 768px) { .form-container { padding: 20px 15px; } h3 { font-size: 22px; } .btn-primary { padding: 12px; font-size: 15px; } .logout-btn { font-size: 13px; padding: 8px 14px; } } </style> </head> <body> <!-- Logout Button --> <a href="logout.php" class="logout-btn">Logout</a> <div class="container"> <div class="form-container"> <h3 class="text-center text-primary">Medical Registration Form</h3> <?php if (isset($_SESSION['submitted'])): ?> <div class="alert alert-success alert-dismissible fade show text-center" role="alert"> ✅ Thank you! Your submission has been received. <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php endif; ?> <!-- Passport Search --> <div class="mb-4"> <div class="input-group"> <input type="text" id="passport_search" class="form-control" placeholder="Enter Passport No"> <button type="button" id="search_btn" class="btn btn-primary">Search</button> </div> </div> <!-- Medical Form --> <form method="POST" enctype="multipart/form-data"> <div class="mb-3"> <label for="applicant_id" class="form-label">Select Applicant</label> <select name="applicant_id" id="applicant_id" class="form-control" required> <option value="">-- Select Applicant --</option> <?php $sql = "SELECT * FROM job_applicants"; $result = $con->query($sql); while ($row = $result->fetch_assoc()) { ?> <option value="<?= $row['id'] ?>" data-passport="<?= $row['passport_no'] ?>" data-reference="<?= $row['reference'] ?>"> <?= $row['name'] ?> (<?= $row['passport_no'] ?>) </option> <?php } ?> </select> </div> <div class="row"> <div class="col-md-6 mb-3"> <label for="medical_date" class="form-label">Medical Date</label> <input type="date" name="medical_date" class="form-control" required> </div> <div class="col-md-6 mb-3"> <label for="medical_exp_date" class="form-label">Medical Expiry Date</label> <input type="date" name="medical_exp_date" class="form-control" required> </div> </div> <div class="mb-3"> <label for="medical_upload" class="form-label">Upload Medical Document</label> <input type="file" name="medical_upload" class="form-control" accept=".jpg,.jpeg,.png,.pdf" required> </div> <div class="mb-4"> <label for="sleep" class="form-label">Sleep Details</label> <textarea name="sleep" class="form-control" rows="3" required></textarea> </div> <div class="d-grid"> <button type="submit" class="btn btn-primary">Save Medical Record</button> </div> </form> </div> </div> <!-- Passport Search Script --> <script> $(document).ready(function () { $("#search_btn").click(function () { let passportNo = $("#passport_search").val().trim(); let found = false; if (passportNo !== "") { $("#applicant_id option").each(function () { if ($(this).data("passport") == passportNo) { $(this).prop("selected", true); found = true; return false; } }); if (!found) { alert("❌ No Applicant Found with this Passport No!"); } } else { alert("⚠️ Please enter a Passport Number."); } }); }); </script> </body> </html>
Save
Cancel