📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/admin/embassy_submitted.php
<?php session_start(); include "dbconnect.php"; // Database Connection // If form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) { $_SESSION['submitted'] = true; // Set session to prevent further submissions $applicant_id = $_POST['applicant_id']; $embassy_submission = $_POST['embassy_submission']; $file_no = $_POST['file_no']; $submission_date = $_POST['submission_date']; $message = $_POST['message']; // Check if the record already exists $sql_check = "SELECT * FROM embassy_submitted WHERE applicant_id = '$applicant_id' AND file_no = '$file_no'"; $result_check = $con->query($sql_check); if ($result_check->num_rows > 0) { echo "<script>alert('Record already exists for this applicant with the same file number.');</script>"; } else { // Insert new record if it doesn't exist $sql = "INSERT INTO embassy_submitted (applicant_id, embassy_submission, file_no, submission_date, message) VALUES ('$applicant_id', '$embassy_submission', '$file_no', '$submission_date', '$message')"; if ($con->query($sql) === TRUE) { echo "<script>alert('Embassy Submission Added Successfully');</script>"; } else { echo "<script>alert('Error: " . $con->error . "');</script>"; } } } elseif (isset($_SESSION['submitted'])) { // If form was already submitted, prevent further submissions echo "<script>alert('You have already submitted the form.');</script>"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Embassy Submission Form</title> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <style> body { background-color: #f0f2f5; font-family: 'Arial', sans-serif; } .container { padding-top: 30px; padding-bottom: 50px; } .form-container { background: #ffffff; padding: 30px; border-radius: 12px; box-shadow: 0 8px 16px rgba(0, 0, 0, 0.1); max-width: 700px; margin: auto; } h3 { font-size: 24px; color: #333; margin-bottom: 20px; } .form-control { border-radius: 8px; padding: 14px; font-size: 16px; margin-bottom: 15px; } .btn-primary { padding: 14px; font-size: 16px; border-radius: 8px; width: 100%; background-color: #007bff; border-color: #007bff; } .btn-primary:hover { background-color: #0056b3; border-color: #004085; } .input-group .btn { border-radius: 8px; } .form-group { margin-bottom: 1.5rem; } label { font-weight: bold; color: #555; } </style> </head> <body> <div class="container"> <div class="form-container"> <h3 class="text-center text-primary mb-4">Embassy Submission Form</h3> <?php if (isset($_SESSION['submitted'])): ?> <div class="alert alert-success text-center" role="alert"> Thank you! Your submission has been received. </div> <?php endif; ?> <!-- Search Section --> <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> <!-- Form --> <form method="POST" enctype="multipart/form-data"> <div class="form-group"> <label for="applicant_id">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'] ?>"> <?= $row['name'] ?> (<?= $row['passport_no'] ?>) </option> <?php } ?> </select> </div> <div class="form-group"> <label for="embassy_submission">Embassy Submission Status</label> <input type="text" name="embassy_submission" class="form-control" required> </div> <div class="form-group"> <label for="file_no">File Number</label> <input type="text" name="file_no" class="form-control" required> </div> <div class="form-group"> <label for="submission_date">Submission Date</label> <input type="date" name="submission_date" class="form-control" required> </div> <div class="form-group"> <label for="message">Message</label> <textarea name="message" class="form-control" rows="4" required></textarea> </div> <div class="form-group text-center"> <button type="submit" class="btn btn-primary">Save Embassy Submission</button> </div> </form> </div> </div> <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