delete.php

<?php
include('ai.php');

if (isset($_POST['deleteemployee'])) {
    $delete_id = $_POST['delete_id'];

    // Check if ID exists in the database before deleting
    $check_query = "SELECT * FROM employee WHERE Id = '$delete_id'";
    $check_result = mysqli_query($connection, $check_query);

    if (mysqli_num_rows($check_result) == 0) {
        // ID does not exist
        header('Location: name.php?message=ID does not exist');
        exit();
    } else {
        // ID exists, show confirmation dialog using JavaScript
        echo '<script>';
        echo 'if (confirm("Are you sure you want to delete this record?")) {';
        echo '  window.location = "delete_employee.php?delete_id=' . $delete_id . '";'; // Redirect to delete script
        echo '} else {';
        echo '  window.location = "name.php";'; // Redirect back to where you came from
        echo '}';
        echo '</script>';
        exit();
    }
}
?>