public static function listDrinkIngredients($drink_id)
{
$query = DB::connection()->prepare('SELECT * FROM DrinkIngredient WHERE drink_id = :drink_id');
$query->execute(array($drink_id));
$rows = $query->fetchAll(PDO::FETCH_OBJ);
$ingredients = array();
foreach ($rows as $row) {
$ingredient = new DrinkIngredient();
$ingredient->setAmount($row->amount);
$ingredient->setUnit($row->unit);
$ingredient->setIngredient_id($row->ingredient_id);
$ingredient->setDrink_id($row->drink_id);
$ingredient->setIngredientName($row->ingredient_id);
$ingredients[] = $ingredient;
}
return $ingredients;
}
