<?php
require_once __DIR__ . '/../config.php';

function get_ingredients_by_recipe($recipe_id) {
    $conn = db_connect();
    $sql = "SELECT * FROM Ingredients WHERE RecipeId = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $recipe_id);
    $stmt->execute();

    $result = $stmt->get_result();
    $ingredients = [];
    while ($row = $result->fetch_assoc()) {
        $ingredients[] = $row;
    }

    $stmt->close();
    $conn->close();
    return json_encode($ingredients);
}
?>