Read Records

<?php
final class ProductRepository
{
    public function __construct(private PDO $pdo) {}

    /** @return array<int, array<string, mixed>> */
    public function all(): array
    {
        return $this->pdo
            ->query("SELECT id, name, price, stock, category FROM products ORDER BY id")
            ->fetchAll();
    }

    public function find(int $id): ?array
    {
        $statement = $this->pdo->prepare("SELECT id, name, price, stock, category FROM products WHERE id = :id");
        $statement->execute(["id" => $id]);

        return $statement->fetch() ?: null;
    }
}

$repo = new ProductRepository(require __DIR__ . "/db.php");

foreach ($repo->all() as $p) {
    echo $p["id"] . " " . $p["name"] . "\n";
}

var_dump($repo->find(999));

1 Notebook
2 Pen
3 Bag
4 Marker
5 Diary
NULL

<?php
declare(strict_types=1);

require __DIR__ . "/ProductRepository.php";
require __DIR__ . "/functions.php";

$repo = new ProductRepository(require __DIR__ . "/db.php");
$products = $repo->all();
?>
<!DOCTYPE html>
<html lang="en">
<head><meta charset="utf-8"><title>Products</title></head>
<body>
  <h1>Products</h1>
  <p><a href="product-new.php">Add a product</a></p>

  <?php if ($products === []): ?>
    <p>No products yet.</p>
  <?php else: ?>
    <table>
      <thead>
        <tr><th>Name</th><th>Price</th><th>Stock</th><th></th></tr>
      </thead>
      <tbody>
        <?php foreach ($products as $p): ?>
          <tr>
            <td><a href="product.php?id=<?= (int) $p["id"] ?>"><?= h($p["name"]) ?></a></td>
            <td><?= number_format((float) $p["price"], 2) ?></td>
            <td><?= (int) $p["stock"] ?></td>
            <td><a href="product-edit.php?id=<?= (int) $p["id"] ?>">Edit</a></td>
          </tr>
        <?php endforeach; ?>
      </tbody>
    </table>
  <?php endif; ?>
</body>
</html>

<?php
declare(strict_types=1);

require __DIR__ . "/ProductRepository.php";
require __DIR__ . "/functions.php";

$id = filter_var($_GET["id"] ?? null, FILTER_VALIDATE_INT);
$repo = new ProductRepository(require __DIR__ . "/db.php");

$product = $id === false ? null : $repo->find($id);

if ($product === null) {
    http_response_code(404);
    exit("Product not found.");
}
?>
<!DOCTYPE html>
<html lang="en">
<head><meta charset="utf-8"><title><?= h($product["name"]) ?></title></head>
<body>
  <h1><?= h($product["name"]) ?></h1>
  <p>Price: <?= number_format((float) $product["price"], 2) ?></p>
  <p>In stock: <?= (int) $product["stock"] ?></p>
  <p><a href="index.php">Back to the list</a></p>
</body>
</html>