📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/emply/regitationedit.php
<?php include "dbconnect.php"; // Database Connection // Get the id from the URL query parameter $edit_id = isset($_GET['id']) ? $_GET['id'] : null; // Fetch the applicant data for editing 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(); } // Check if the form is submitted for update 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']; // Prepare the update query $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!');</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"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Edit Job Applicant</title> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> <style> body { background-color: #f4f7fa; font-family: 'Arial', sans-serif; } .container { margin-top: 30px; } .form-label { font-weight: bold; } .btn-primary { width: 100%; } .form-control { border-radius: 10px; box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1); } .card { padding: 20px; border-radius: 10px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1); background-color: white; } h3 { color: #007bff; font-weight: bold; } </style> </head> <body> <div class="container"> <h3 class="text-center">Edit Job Applicant</h3> <div class="card"> <form method="POST" action="regitationlist.php"> <input type="hidden" name="edit_id" value="<?= $row['id'] ?>"> <div class="row"> <div class="col-md-6 mb-3"> <label for="name" class="form-label">Name</label> <input type="text" class="form-control" id="name" name="name" value="<?= $row['name'] ?>" required> </div> <div class="col-md-6 mb-3"> <label for="father_name" class="form-label">Father Name</label> <input type="text" class="form-control" id="father_name" name="father_name" value="<?= $row['father_name'] ?>" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label for="passport_no" class="form-label">Passport No</label> <input type="text" class="form-control" id="passport_no" name="passport_no" value="<?= $row['passport_no'] ?>" required> </div> <div class="col-md-6 mb-3"> <label for="passport_expiry_date" class="form-label">Passport Expiry Date</label> <input type="date" class="form-control" id="passport_expiry_date" name="passport_expiry_date" value="<?= $row['passport_expiry_date'] ?>" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label for="mobile_no" class="form-label">Mobile No</label> <input type="text" class="form-control" id="mobile_no" name="mobile_no" value="<?= $row['mobile_no'] ?>" required> </div> <div class="col-md-6 mb-3"> <label for="email_id" class="form-label">Email</label> <input type="email" class="form-control" id="email_id" name="email_id" value="<?= $row['email_id'] ?>" required> </div> </div> <div class="mb-3"> <label for="address" class="form-label">Address</label> <textarea class="form-control" id="address" name="address" rows="3" required><?= $row['address'] ?></textarea> </div> <div class="row"> <div class="col-md-6 mb-3"> <label for="position" class="form-label">Job Position</label> <input type="text" class="form-control" id="position" name="position" value="<?= $row['position'] ?>" required> </div> <div class="col-md-6 mb-3"> <label for="job_country" class="form-label">Job Country</label> <input type="text" class="form-control" id="job_country" name="job_country" value="<?= $row['job_country'] ?>" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label for="qualification" class="form-label">Qualification</label> <input type="text" class="form-control" id="qualification" name="qualification" value="<?= $row['qualification'] ?>" required> </div> <div class="col-md-6 mb-3"> <label for="experience" class="form-label">Experience</label> <input type="text" class="form-control" id="experience" name="experience" value="<?= $row['experience'] ?>" required> </div> </div> <div class="mb-3"> <label for="reference" class="form-label">Reference</label> <input type="text" class="form-control" id="reference" name="reference" value="<?= $row['reference'] ?>" required> </div> <div class="mb-3"> <label for="message" class="form-label">Message</label> <textarea class="form-control" id="message" name="message" rows="3"><?= $row['message'] ?></textarea> </div> <button type="submit" class="btn btn-primary">Save Changes</button> </form> </div> </div> </body> </html>
Save
Cancel