<?php
header('Content-Type: application/json; charset=utf-8');
require 'db_config.php';

$id = $_GET['id'] ?? 0;
$stmt = $pdo->prepare("SELECT * FROM cocktails WHERE id = ?");
$stmt->execute([$id]);
$cocktail = $stmt->fetch(PDO::FETCH_ASSOC);

$stmtZutaten = $pdo->prepare("SELECT * FROM zutaten WHERE cocktail_id = ? ORDER BY menge_ml DESC, id");
$stmtZutaten->execute([$id]);
$cocktail['zutaten'] = $stmtZutaten->fetchAll(PDO::FETCH_ASSOC);

echo json_encode($cocktail);