/** * Modifica los datos del usuario * @param Player $player */ public function updateUser(Player $player) { $query = $this->getConnection()->prepare("UPDATE \ttch_player \r\n\t\t\t\t\t\t\t\t\t\t\t\t SET \t\temail=:email, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tid_position=:id_position,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tid_player_zone=:id_player_zone,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tid_category=:id_category,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tid_image=:id_image,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfree=:free\r\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE \tid_player=:id_player"); $query->bindValue(":email", $player->getEmail()); $query->bindValue(":id_position", $player->getPosition()->getIdPosition()); $query->bindValue(":id_player_zone", $player->getRegion()->getIdRegion()); $query->bindValue(":id_category", $player->getGameCategory()->getIdGameCategory()); $query->bindValue(":id_image", $player->getImagePlayer()->getIdImagePlayer()); $query->bindValue(":free", $player->isFree()); $query->bindValue(":id_player", $player->getIdPlayer()); $query->execute(); $updatedRows = $query->rowCount(); return $updatedRows == 1; }
public function getUser() { try { $this->checkPostRequest(); $header = $this->datosPeticion[Rest::HEADER]; $body = $this->datosPeticion[Rest::BODY]; $countryCode = $header[Rest::COUNTRY]; $player = new Player(); if ($player->jsonUnserialize($body)) { $data = $this->playerDAO->getPlayer($player->getIdPlayer()); if ($data != NULL) { $this->processSuccessResponse($countryCode, $data); } else { $this->processErrorResponse($countryCode, Rest::STATUS_ERROR, IPlayerService::PLAYER_NOT_EXIST); } } } catch (DAOException $e) { $this->processErrorResponse('', Rest::STATUS_ERROR, $e->getMessage()); } catch (Exception $e) { $this->processErrorResponse('', Rest::STATUS_ERROR, Rest::SERVER_ERROR); } }