public static function getTeamsFromUser($id)
{
$teams = array();
$req = DataBase::getInstance()->prepare('SELECT id, name, description FROM team LEFT JOIN team_player ON team = id WHERE player = :id');
$req->bindvalue('id', $id, PDO::PARAM_INT);
$req->execute();
while ($datas = $req->fetch()) {
$team = new Team();
$team->hydrate($datas);
$team->loadPlayers();
$team->loadTournaments();
$teams[] = $team;
}
$req->closeCursor();
return $teams;
}
