blob: 2a75754825195bab10c41dc7743dde3c9ff1626d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
<?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);
|
