init

1 files changed, 14 insertions, 0 deletions

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);