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()]);
}
