user_list.php

<?php
    include "header.php";
    include "navigation.php";
?>

    <div class="container-fluid mt-3">
        <div class="row">
            <div class="col-12">
                <table class="table table-md table-bordered bg-light">
                    <thead class="bg-dark text-light">
                        <tr>
                            <th>First Name</th>
                            <th>Last Name</th>
                            <th>Email</th>
                        </tr>
                    </thead>
                    <tbody>

                    <?php

                    require "connection.php";
                    $sql = "SELECT * FROM users";
                    $fire = $conn->prepare($sql);
                    $fire->execute();
                    if ($fire->rowCount() > 0) {
                        $results = $fire->fetchAll(PDO::FETCH_ASSOC);
                        foreach ($results as $result) {
                            echo '<tr>';
                                echo '<td>'. $result['first_name'] .'</td>';
                                echo '<td>'. $result['last_name'] .'</td>';
                                echo '<td>'. $result['email'] .'</td>';
                            echo '</tr>';
                        }

                    } else {
                        echo '<tr>';
                            echo '<td> No Data Found. </td>';
                        echo '</tr>';
                    }
                    ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>


    
<?php include "footer.php"; ?>