index.php

<?php require 'db.php';
$sql = 'SELECT * FROM people';
$statment = $connection->prepare($sql);
$statment->execute();
$people = $statment->fetchAll(PDO::FETCH_OBJ);




?>

<?php require 'header.php'; ?>
<div class="container">
    <div class="card mt5">
        <div class="card-header">
            <h2>ALL people</h2>
        </div>
        <div class="card-body">
            <table class="table table-bordered">
                <tr>
                    <th>ID</th>
                    <th>Name</th>
                    <th>Email</th>
                    <th>Action</th>
                </tr>
                <?php foreach ($people as $person) : ?>
                    <tr>
                        <td><?= $person->id; ?></td>
                        <td><?= $person->name; ?></td>
                        <td><?= $person->email; ?></td>
                        <td>
                            <a href="edit.php?id=<?= $person->id ?>" class="btn btn-info">Edit</a>
                            <a onclick="return confirm('Are you sure you want to delete this entry?')" href="delete.php?id=<?= $person->id ?>" class='btn btn-danger'>Delete</a>
                        </td>
                    </tr>
                <?php endforeach; ?>
            </table>

        </div>
    </div>
</div>
<?php require 'footer.php'; ?>