setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Get products with their images
$stmt = $conn->query("
SELECT p.productID, p.pdname, p.preis, p.description, pi.image_path, p.category
FROM products p
LEFT JOIN product_images pi ON p.productID = pi.productID
ORDER BY p.productID
");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$imagePath = !empty($row['image_path']) ? 'images/' . $row['image_path'] : 'placeholder.jpg';
?>
![<?php echo htmlspecialchars($row['pdname']); ?>](<?php echo htmlspecialchars($imagePath); ?>)
Error loading products: " . $e->getMessage() . "
";
}
?>
€