public function getPlayer($idPlayer) { $player = NULL; $query = $this->getConnection()->prepare("SELECT id_player, username, email, free, id_position, id_player_zone, id_category, id_image FROM tch_player WHERE id_player =:id_player"); $query->bindValue(":id_player", $idPlayer); $query->execute(); if ($row = $query->fetch(\PDO::FETCH_ASSOC)) { $player = new Player(); $player->setIdPlayer($row['id_player']); $player->setUserName($row['username']); $player->setEmail($row['email']); $player->setFree($row['free']); $player->getPosition()->setIdPosition($row['id_position']); $player->getRegion()->setIdRegion($row['id_player_zone']); $player->getGameCategory()->setIdGameCategory($row['id_category']); $player->getImagePlayer()->setIdImagePlayer($row['id_image']); } return $player; }