index.php

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>My Shop</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css">
</head>

<body>
    <div class="container my-5">
        <h2>List Of Clients</h2>
        <a class="btn btn-primary" type="button" href="/myshop/create.php">New Client</a>
        <table class="table">
            <thead>
                <tr>
                    <th>ID</th>
                    <th>Name</th>
                    <th>Email</th>
                    <th>Phone</th>
                    <th>Address</th>
                    <th>Created At</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                <?php
                $servername = "localhost";
                $username = "root";
                $password = "";
                $database = "myshop";

                //connect
                $connection = new mysqli ($servername, $username, $password, $database);

                //check connection
                if ($connection -> connect_error) {
                    die("Connection failed: " . $connection -> connect_error);
                }


                $sql = "SELECT * FROM clients";
                $result = $connection -> query($sql);

                if (!$result) {
                    die("invalid query: " . $connection -> error);
                }

                while ($row = $result -> fetch_assoc()){
                    echo"
                      <tr>
                    <td>$row[id]</td>
                    <td>$row[name]</td>
                    <td>$row[email]</td>
                    <td>$row[phone]</td>
                    <td>$row[address]</td>
                    <td>$row[created_at]</td>
                    <td>
                        <a class='btn btn-primary btn-sm' href='/myshop/edit.php?id=$row[id]'>edit</a>
                        <a class='btn btn-danger btn-sm' href='/myshop/delete.php?id=$row[id]'>delete</a>
                    </td>
                </tr>
                    ";
                }
                ?>

                
            </tbody>
        </table>
    </div>
</body>

</html>