prepare("
SELECT p.*, c.name as category_name,
(SELECT image_url FROM product_images WHERE product_id = p.id AND is_main = 1 LIMIT 1) as main_image,
(SELECT image_url FROM product_images WHERE product_id = p.id ORDER BY sort_order ASC LIMIT 1) as fallback_image,
pl.created_at as liked_at
FROM product_likes pl
JOIN products p ON pl.product_id = p.id
LEFT JOIN categories c ON p.category_id = c.id
WHERE pl.user_id = :user_id AND p.status = 'active'
ORDER BY pl.created_at DESC
");
$stmt->execute([':user_id' => $userId]);
$likedProducts = $stmt->fetchAll();
} catch (PDOException $e) {
$likedProducts = [];
}
// นับจำนวนสินค้าในตะกร้า
$cartCount = 0;
if (isset($_SESSION['cart'])) {
foreach ($_SESSION['cart'] as $item) {
$cartCount += $item['qty'];
}
}
?>
สินค้าที่ถูกใจ - AMARA STUDIO
![<?= htmlspecialchars($prod['name']) ?>](<?= htmlspecialchars($imgUrl) ?>)