public static function store() { $newDrink = new Drink(); $mockDrink = new Drink(); $drink_types = DrinkType::listDrinkTypes(); $name = $_POST['drink_name']; $ingredients = $_POST['ingredients']; $amounts = $_POST['amounts']; $units = $_POST['units']; $mockDrink->setDrink_name($name); $mockDrink->setDrink_type($_POST['drink_type']); $mockDrink->setInstructions($_POST['instructions']); DrinkController::validateNew($name, $mockDrink, $drink_types, $ingredients, $amounts); $newDrink->setDrink_name($name); $newDrink->setDrink_type($_POST['drink_type']); $newDrink->setInstructions($_POST['instructions']); $newDrink->setAdder_id($_SESSION['user']); $newDrink->save(); DrinkController::addIngredients($ingredients, $newDrink, $amounts, $units); Redirect::to('/drink/' . $newDrink->getDrink_id(), array('message' => 'Drink has been archived.')); }
public function getFavorites($user) { $query = DB::connection()->prepare('SELECT Favorites.drink_id, Drinks.drink_name FROM Favorites INNER JOIN Drinks ON Favorites.drink_id = Drinks.drink_id WHERE user_id = :user'); $query->execute(array($user)); $rows = $query->fetchAll(PDO::FETCH_OBJ); $drinks = array(); foreach ($rows as $row) { $drink = new Drink(); $drink->setDrink_id($row->drink_id); $drink->setDrink_name($row->drink_name); $drinks[] = $drink; } return $drinks; }