public function existsInBasket(Game $game, User $user) { $sql = "SELECT 1 FROM Basket WHERE game_id= :gameId and user_id= :userId"; $result = $this->getDb()->fetchAll($sql, array('gameId' => $game->getId(), 'userId' => $user->getId())); return !empty($result); }
/** * updates the user params * @param user to update * @params params to update */ public function updateUser(User $user, $params) { $paramsSql = 'UPDATE users SET'; foreach ($params as $key => $param) { $paramsSql .= '`' . $key . '`="' . $param . '"'; if (end($params) !== $param) { $paramsSql .= ','; } } $paramsSql .= 'WHERE user_id = :userId'; $this->getDb()->executeUpdate($paramsSql, ['userId' => $user->getId()]); }