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