<?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>
