dropdown.php

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

<?php

if (isset($_POST['department']) && !empty($_POST['department'])) {
    $department = mysqli_real_escape_string($connection, $_POST['department']);
    $query = "SELECT * FROM employee WHERE Department = '$department'";
    $result = mysqli_query($connection, $query);

    if (!$result) {
        die("QUERY FAILED... " . mysqli_error($connection));
    }
} else {
    $query = "SELECT * FROM employee";
    $result = mysqli_query($connection, $query);

    if (!$result) {
        die("QUERY FAILED... " . mysqli_error($connection));
    }
}
?>

<a href="name.php" class="btn btn-secondary mt-2" style="background-color: blue">Back</a>


<table class="table table-hover table-bordered table-striped">
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Department</th>
            <th>Salary</th>
        </tr>
    </thead>
    <tbody>
        <?php
        while ($row = mysqli_fetch_assoc($result)) {
            ?>
            <tr>
                <td><?php echo htmlspecialchars($row['Id']); ?></td>
                <td><?php echo htmlspecialchars($row['Name']); ?></td>
                <td><?php echo htmlspecialchars($row['Department']); ?></td>
                <td><?php echo htmlspecialchars($row['Salary']); ?></td>
            </tr>
            <?php
        }
        ?>
    </tbody>
</table>

<?php include('foot.php'); ?>