📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/admin/visasubmition.php
<?php session_start(); include "dbconnect.php"; // If form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) { $_SESSION['submitted'] = true; $applicant_id = $_POST['applicant_id']; $visa_type = $_POST['visa_type']; $visa_issue_date = $_POST['visa_issue_date']; $visa_expiry_date = $_POST['visa_expiry_date']; $visa_message = $_POST['visa_message']; // Handle file upload if (isset($_FILES['visa_upload']) && $_FILES['visa_upload']['error'] == 0) { $file_name = $_FILES['visa_upload']['name']; $file_tmp = $_FILES['visa_upload']['tmp_name']; $file_ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION)); $allowed_exts = ['jpg', 'jpeg', 'png', 'pdf']; if (in_array($file_ext, $allowed_exts)) { $upload_dir = 'uploads/'; if(!is_dir($upload_dir)){ mkdir($upload_dir, 0755, true); } $file_path = $upload_dir . uniqid() . '_' . basename($file_name); move_uploaded_file($file_tmp, $file_path); } else { echo "<script>alert('Invalid file type. Only JPG, PNG, and PDF allowed.');</script>"; exit; } } else { $file_path = null; } // Check for duplicate visa record $check = $con->query("SELECT * FROM visa_management WHERE applicant_id = '$applicant_id' AND visa_issue_date = '$visa_issue_date'"); if ($check->num_rows > 0) { echo "<script>alert('Visa record already exists for this date.');</script>"; } else { $sql = "INSERT INTO visa_management (applicant_id, visa_type, visa_issue_date, visa_expiry_date, visa_upload, visa_message, visa_status) VALUES ('$applicant_id', '$visa_type', '$visa_issue_date', '$visa_expiry_date', '$file_path', '$visa_message', 'Pending')"; if ($con->query($sql) === TRUE) { echo "<script>alert('Visa Record Added Successfully');</script>"; unset($_SESSION['submitted']); } 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>Visa Registration</title> <meta name="viewport" content="width=device-width, initial-scale=1" /> <!-- Bootstrap CSS + Bootstrap Icons + jQuery --> <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" /> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <style> body { background: linear-gradient(135deg, #6dd5fa, #2980b9); font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; min-height: 100vh; display: flex; flex-direction: column; justify-content: center; padding: 20px; } .logout-btn { position: fixed; top: 20px; right: 20px; z-index: 999; background-color: #e74c3c; color: white; padding: 10px 18px; border: none; border-radius: 8px; font-weight: 600; transition: background-color 0.3s ease; } .logout-btn:hover { background-color: #c0392b; } .form-container { background: #ffffffcc; padding: 35px 30px; border-radius: 15px; box-shadow: 0 10px 30px rgba(0,0,0,0.15); max-width: 700px; margin: auto; width: 100%; } h3 { text-align: center; font-weight: 700; color: #1b4f72; margin-bottom: 30px; } label { font-weight: 600; } .form-control, .form-select { border-radius: 10px; padding-left: 2.75rem; height: 44px; font-size: 1rem; box-shadow: none !important; border: 1.8px solid #2980b9; transition: border-color 0.3s ease; } .form-control:focus, .form-select:focus { border-color: #1b4f72; box-shadow: 0 0 8px rgba(41, 128, 185, 0.6); } .input-icon { position: relative; } .input-icon > i { position: absolute; left: 12px; top: 50%; transform: translateY(-50%); color: #2980b9; font-size: 1.2rem; pointer-events: none; } textarea.form-control { padding-left: 1rem; height: auto; min-height: 90px; resize: vertical; } .btn-primary { background-color: #2980b9; border: none; padding: 14px 0; border-radius: 12px; font-weight: 700; font-size: 1.1rem; width: 100%; transition: background-color 0.3s ease; } .btn-primary:hover { background-color: #1b4f72; } #applicant-details p { margin-bottom: 8px; color: #1b4f72; font-size: 1rem; font-weight: 600; } #applicant-details span { color: #145a86; font-weight: 700; } @media (max-width: 576px) { body { padding: 10px; } .form-container { padding: 25px 20px; } .logout-btn { top: 10px; right: 10px; padding: 8px 14px; font-size: 14px; } .input-icon > i { font-size: 1rem; left: 10px; } } </style> </head> <body> <!-- Logout Button --> <form action="logout.php" method="post" class="position-fixed" style="top:20px; right:20px; z-index:1050;"> <button class="logout-btn" type="submit"><i class="bi bi-box-arrow-right"></i> Logout</button> </form> <div class="form-container shadow-sm"> <h3><i class="bi bi-passport-fill"></i> Visa Registration Form</h3> <form method="POST" enctype="multipart/form-data" novalidate> <!-- Select Applicant --> <div class="mb-3 input-icon"> <label for="applicant_id" class="form-label">Select Applicant</label> <i class="bi bi-person-fill"></i> <select name="applicant_id" id="applicant_id" class="form-select" required> <option value="" disabled selected>-- Select Applicant --</option> <?php $res = $con->query("SELECT id, name, passport_no, position, job_country, reference FROM job_applicants"); while ($row = $res->fetch_assoc()) { echo "<option value='{$row['id']}' data-position='{$row['position']}' data-country='{$row['job_country']}' data-reference='{$row['reference']}'> {$row['name']} ({$row['passport_no']}) </option>"; } ?> </select> <div class="invalid-feedback">Please select an applicant.</div> </div> <!-- Display Additional Applicant Details --> <div class="mb-3" id="applicant-details" style="min-height: 70px;"> <p><strong>Position:</strong> <span id="applicant-position">-</span></p> <p><strong>Job Country:</strong> <span id="applicant-country">-</span></p> <p><strong>Reference:</strong> <span id="applicant-reference">-</span></p> </div> <!-- Visa Type --> <div class="mb-3 input-icon"> <label for="visa_type" class="form-label">Visa Type</label> <i class="bi bi-card-checklist"></i> <select name="visa_type" id="visa_type" class="form-select" required> <option value="" disabled selected>-- Select Visa Type --</option> <option value="Tourist">Tourist</option> <option value="Work">Work</option> <option value="Business">Business</option> <option value="Student">Student</option> </select> <div class="invalid-feedback">Please select visa type.</div> </div> <!-- Visa Issue and Expiry Dates --> <div class="row g-3"> <div class="col-md-6 input-icon"> <label for="visa_issue_date" class="form-label">Visa Issue Date</label> <i class="bi bi-calendar-check"></i> <input type="date" name="visa_issue_date" id="visa_issue_date" class="form-control" required /> <div class="invalid-feedback">Please enter the visa issue date.</div> </div> <div class="col-md-6 input-icon"> <label for="visa_expiry_date" class="form-label">Visa Expiry Date</label> <i class="bi bi-calendar-x"></i> <input type="date" name="visa_expiry_date" id="visa_expiry_date" class="form-control" required /> <div class="invalid-feedback">Please enter the visa expiry date.</div> </div> </div> <!-- Upload --> <div class="mb-3 input-icon mt-3"> <label for="visa_upload" class="form-label">Upload Visa Document</label> <i class="bi bi-file-earmark-arrow-up-fill"></i> <input type="file" name="visa_upload" id="visa_upload" class="form-control" accept=".jpg,.jpeg,.png,.pdf" required /> <div class="form-text">Allowed file types: JPG, PNG, PDF</div> <div class="invalid-feedback">Please upload a visa document.</div> </div> <!-- Message --> <div class="mb-4"> <label for="visa_message" class="form-label">Visa Message</label> <textarea name="visa_message" id="visa_message" class="form-control" rows="3" placeholder="Enter any additional message here..." required></textarea> <div class="invalid-feedback">Please enter a message.</div> </div> <!-- Submit --> <div class="text-center"> <button type="submit" class="btn btn-primary"><i class="bi bi-save2-fill"></i> Save Visa Record</button> </div> </form> </div> <script> $(document).ready(function() { $("#applicant_id").change(function() { let selected = $(this).find(':selected'); $("#applicant-position").text(selected.data("position") || '-'); $("#applicant-country").text(selected.data("country") || '-'); $("#applicant-reference").text(selected.data("reference") || '-'); }); // Bootstrap 5 form validation (function () { 'use strict'; const forms = document.querySelectorAll('form'); Array.from(forms).forEach(function (form) { form.addEventListener('submit', function (event) { if (!form.checkValidity()) { event.preventDefault(); event.stopPropagation(); } form.classList.add('was-validated'); }, false); }); })(); }); </script> <!-- Bootstrap Bundle JS (Popper + Bootstrap JS) --> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> </body> </html>
Save
Cancel