PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
];
try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
die(“Database connection failed: ” . $e->getMessage());
}
?>
// catalog.php
prepare(“SELECT id, name, description, price, image_url FROM catalog_items ORDER BY name”);
$stmt->execute();
$items = $stmt->fetchAll();
?>
Our Catalog