📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/admin/regitationedit.php
<?php include "dbconnect.php"; // Get the ID from the URL $edit_id = isset($_GET['id']) ? $_GET['id'] : null; $row = []; if ($edit_id) { $sql = "SELECT * FROM job_applicants WHERE id = ?"; $stmt = $con->prepare($sql); $stmt->bind_param("i", $edit_id); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); } // Handle POST request if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['edit_id'])) { $edit_id = $_POST['edit_id']; $name = $_POST['name']; $father_name = $_POST['father_name']; $passport_no = $_POST['passport_no']; $passport_expiry_date = $_POST['passport_expiry_date']; $mobile_no = $_POST['mobile_no']; $email_id = $_POST['email_id']; $address = $_POST['address']; $position = $_POST['position']; $job_country = $_POST['job_country']; $qualification = $_POST['qualification']; $experience = $_POST['experience']; $reference = $_POST['reference']; $message = $_POST['message']; $update_sql = "UPDATE job_applicants SET name = ?, father_name = ?, passport_no = ?, passport_expiry_date = ?, mobile_no = ?, email_id = ?, address = ?, position = ?, job_country = ?, qualification = ?, experience = ?, reference = ?, message = ? WHERE id = ?"; if ($stmt = $con->prepare($update_sql)) { $stmt->bind_param("sssssssssssssi", $name, $father_name, $passport_no, $passport_expiry_date, $mobile_no, $email_id, $address, $position, $job_country, $qualification, $experience, $reference, $message, $edit_id); if ($stmt->execute()) { echo "<script>alert('Record updated successfully!'); window.location.href='regitationlist.php';</script>"; } else { echo "<script>alert('Error: " . $stmt->error . "');</script>"; } $stmt->close(); } else { echo "<script>alert('Error preparing query: " . $con->error . "');</script>"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Edit Job Applicant</title> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Bootstrap CSS & 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.5.0/css/all.min.css" rel="stylesheet"> <style> body { background: linear-gradient(to right, #e0f7fa, #ffffff); font-family: 'Segoe UI', sans-serif; } .container { margin-top: 40px; margin-bottom: 40px; } .card { background-color: #ffffff; border-radius: 15px; padding: 25px; box-shadow: 0 8px 16px rgba(0,0,0,0.1); } .form-label { font-weight: 600; } .btn-primary { background-color: #007bff; border: none; } .btn-primary:hover { background-color: #0056b3; } h3 { color: #007bff; font-weight: bold; margin-bottom: 30px; } .form-icon { margin-right: 8px; color: #007bff; } textarea.form-control { resize: none; } @media (max-width: 576px) { .card { padding: 15px; } } </style> </head> <body> <div class="container"> <h3 class="text-center"><i class="fas fa-user-edit form-icon"></i>Edit Job Applicant</h3> <div class="card"> <form method="POST" action=""> <input type="hidden" name="edit_id" value="<?= $row['id'] ?>"> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-user form-icon"></i>Name</label> <input type="text" class="form-control" name="name" value="<?= $row['name'] ?>" required> </div> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-user-friends form-icon"></i>Father Name</label> <input type="text" class="form-control" name="father_name" value="<?= $row['father_name'] ?>" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-passport form-icon"></i>Passport No</label> <input type="text" class="form-control" name="passport_no" value="<?= $row['passport_no'] ?>" required> </div> <div class="col-md-6 mb-3"> <label class="form-label"><i class="far fa-calendar-alt form-icon"></i>Passport Expiry Date</label> <input type="date" class="form-control" name="passport_expiry_date" value="<?= $row['passport_expiry_date'] ?>" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-phone form-icon"></i>Mobile No</label> <input type="text" class="form-control" name="mobile_no" value="<?= $row['mobile_no'] ?>" required> </div> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-envelope form-icon"></i>Email</label> <input type="email" class="form-control" name="email_id" value="<?= $row['email_id'] ?>" required> </div> </div> <div class="mb-3"> <label class="form-label"><i class="fas fa-map-marker-alt form-icon"></i>Address</label> <textarea class="form-control" name="address" rows="3" required><?= $row['address'] ?></textarea> </div> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-briefcase form-icon"></i>Job Position</label> <input type="text" class="form-control" name="position" value="<?= $row['position'] ?>" required> </div> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-globe form-icon"></i>Job Country</label> <input type="text" class="form-control" name="job_country" value="<?= $row['job_country'] ?>" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-graduation-cap form-icon"></i>Qualification</label> <input type="text" class="form-control" name="qualification" value="<?= $row['qualification'] ?>" required> </div> <div class="col-md-6 mb-3"> <label class="form-label"><i class="fas fa-briefcase form-icon"></i>Experience</label> <input type="text" class="form-control" name="experience" value="<?= $row['experience'] ?>" required> </div> </div> <div class="mb-3"> <label class="form-label"><i class="fas fa-user-check form-icon"></i>Reference</label> <input type="text" class="form-control" name="reference" value="<?= $row['reference'] ?>" required> </div> <div class="mb-3"> <label class="form-label"><i class="fas fa-comment-alt form-icon"></i>Message</label> <textarea class="form-control" name="message" rows="3"><?= $row['message'] ?></textarea> </div> <button type="submit" class="btn btn-primary mt-3"><i class="fas fa-save"></i> Save Changes</button> </form> </div> </div> <!-- Bootstrap JS Bundle --> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> </body> </html>
Save
Cancel