From 746bd05d648780cff2dc476b0522619b3f9d89aa Mon Sep 17 00:00:00 2001
From: horus
Date: Thu, 1 Jan 2026 23:19:05 +0100
Subject: init

---
 api_cocktail.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 api_cocktail.php

(limited to 'api_cocktail.php')

diff --git a/api_cocktail.php b/api_cocktail.php
new file mode 100644
index 0000000..2a75754
--- /dev/null
+++ b/api_cocktail.php
@@ -0,0 +1,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);
-- 
cgit v1.2.3