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