prepare("SELECT * FROM product WHERE id = ?");
$product_stmt->execute([$product_id]);
$product = $product_stmt->fetch(PDO::FETCH_ASSOC);
if (!$product) {
die("Product not found");
}
// Fetch all details for this product
$details_stmt = $pdo->prepare("SELECT * FROM product_detail WHERE product_id = ?");
$details_stmt->execute([$product_id]);
$details = $details_stmt->fetchAll(PDO::FETCH_ASSOC);
?>