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; }
//Test des elements utilisés dans le frontend $gamesList = Game::getGames(); $countGames = Game::countGames(); $tourList = Tournament::getTournaments(); $countTour = Tournament::countTournaments(); //Autres test du moteur, non implanté dans le frontend $me = new User(); $me->setName('Karl'); $me->setSurname('Woditsch'); $me->setMail('*****@*****.**'); $me->setLogin(uniqid()); $me->setPassword('1234'); User::saveUser($me); $userList = User::getUsers(); $countUsers = User::countUsers(); $team = new Team(); $team->setName('Les winneurs'); $team->setDescription('Equipe de test'); $team->addPlayer($me); $team->addTournament($bf3Tour); $team->addTournament($l4dTour); //Team::saveTeam($team); $teamList = Team::getTeams(); $countTeams = Team::countTeams(); $myTeams = Team::getTeamsFromUser($me->getId()); echo 'Succes'; echo 'INIT TEST'; var_dump($bf3); var_dump($gw2); var_dump($l4d); var_dump($bf3Tour);