📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/admin/medical.php
<?php session_start(); include "dbconnect.php"; // Prevent duplicate submission 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']; $file_path = null; if (isset($_FILES['medical_upload']) && $_FILES['medical_upload']['error'] == 0) { $file_name = $_FILES['medical_upload']['name']; $file_tmp = $_FILES['medical_upload']['tmp_name']; $file_ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION)); $allowed = ['jpg', 'jpeg', 'png', 'pdf']; if (in_array($file_ext, $allowed)) { $file_path = "uploads/" . uniqid() . "_" . basename($file_name); move_uploaded_file($file_tmp, $file_path); } else { echo "<script>alert('Invalid file type!');</script>"; exit; } } // Check for duplicate $check = $con->query("SELECT * FROM medical_records WHERE applicant_id='$applicant_id' AND medical_date='$medical_date'"); if ($check->num_rows > 0) { echo "<script>alert('Record already exists for this 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)) { echo "<script>alert('Medical Record Added Successfully');</script>"; } else { echo "<script>alert('Database 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"> <!-- Bootstrap + Font Awesome --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" rel="stylesheet"> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <style> body { background: linear-gradient(135deg, #00c9ff, #92fe9d); /* Stylish Gradient */ font-family: 'Segoe UI', sans-serif; margin: 0; padding: 0; } .container { padding-top: 40px; padding-bottom: 60px; } .form-container { background: #ffffff; padding: 30px; border-radius: 15px; box-shadow: 0 8px 18px rgba(0, 0, 0, 0.15); max-width: 720px; margin: auto; } h3 { font-weight: bold; color: #343a40; margin-bottom: 25px; } .form-control, .btn { border-radius: 10px; } .btn-primary { font-size: 16px; padding: 12px; background-color: #007bff; border-color: #007bff; } .btn-primary:hover { background-color: #0056b3; } label { font-weight: 600; margin-bottom: 6px; color: #555; } .input-group-text { background-color: #007bff; color: white; border-radius: 10px 0 0 10px; } .logout-btn { position: fixed; top: 15px; right: 15px; background-color: #dc3545; color: white; border-radius: 25px; padding: 10px 20px; font-size: 14px; text-decoration: none; } .logout-btn:hover { background-color: #c82333; } @media (max-width: 768px) { .form-container { padding: 20px; } .logout-btn { font-size: 12px; padding: 8px 16px; } } </style> </head> <body> <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 class="text-center"><i class="fas fa-user-md text-primary"></i> Medical Registration Form</h3> <!-- Search by Passport --> <div class="mb-4"> <div class="input-group"> <span class="input-group-text"><i class="fas fa-passport"></i></span> <input type="text" id="passport_search" class="form-control" placeholder="Enter Passport No"> <button type="button" id="search_btn" class="btn btn-primary"><i class="fas fa-search"></i> Search</button> </div> </div> <form method="POST" enctype="multipart/form-data"> <!-- Select Applicant --> <div class="mb-3"> <label for="applicant_id"><i class="fas fa-users"></i> Select Applicant</label> <select name="applicant_id" id="applicant_id" class="form-control" required> <option value="">-- Select Applicant --</option> <?php $result = $con->query("SELECT * FROM job_applicants"); while ($row = $result->fetch_assoc()) { ?> <option value="<?= $row['id'] ?>" data-passport="<?= $row['passport_no'] ?>"> <?= $row['name'] ?> (<?= $row['passport_no'] ?>) </option> <?php } ?> </select> </div> <!-- Medical Date & Expiry --> <div class="row"> <div class="col-md-6 mb-3"> <label for="medical_date"><i class="fas fa-calendar-check"></i> 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"><i class="fas fa-calendar-times"></i> Expiry Date</label> <input type="date" name="medical_exp_date" class="form-control" required> </div> </div> <!-- File Upload --> <div class="mb-3"> <label for="medical_upload"><i class="fas fa-file-upload"></i> Upload Medical Document</label> <input type="file" name="medical_upload" class="form-control" accept=".jpg,.jpeg,.png,.pdf" required> </div> <!-- Sleep Details --> <div class="mb-3"> <label for="sleep"><i class="fas fa-bed"></i> Sleep Details</label> <textarea name="sleep" class="form-control" rows="3" placeholder="Enter sleep-related observations..." required></textarea> </div> <!-- Submit Button --> <div class="text-center"> <button type="submit" class="btn btn-primary"> <i class="fas fa-save"></i> Save Medical Record </button> </div> </form> </div> </div> <script> $(document).ready(function () { $('#search_btn').click(function () { let passport = $('#passport_search').val().trim(); if (!passport) { alert('Please enter a Passport Number.'); return; } let found = false; $('#applicant_id option').each(function () { if ($(this).data('passport') == passport) { $(this).prop('selected', true); found = true; return false; } }); if (!found) { alert('No applicant found with this Passport Number.'); } }); }); </script> </body> </html>
Save
Cancel