<?php
// Database connection
include 'ominterior_db.php';

// Get the job ID to delete
if (isset($_GET['id'])) {
    $id = (int)$_GET['id'];

    // Delete job opening
    $delete_sql = "DELETE FROM current_openings  WHERE id = $id";

    if (mysqli_query($conn, $delete_sql)) {
        echo "<script>alert('Job Opening Deleted Successfully'); window.location.href='career.php';</script>";
    } else {
        echo "Error deleting record: " . mysqli_error($conn);
    }
} else {
    echo "No job ID provided.";
}
?>
