/** * @return University[] */ public function getAll() { $query = "SELECT id, name, player_id, money, lectures\n FROM universities"; $this->db->query($query); $result = $this->db->fetchAll(); $collection = []; foreach ($result as $row) { $player = PlayerRepository::create()->getOne($row['player_id']); $collection[] = new University($row['id'], $row['name'], $player, $row['money'], $row['lectures']); } return $collection; }
/** * @return Player[] */ public function getAll() { $query = "SELECT id, username, password\n FROM players"; $this->db->query($query); $result = $this->db->fetchAll(); $collection = []; foreach ($result as $row) { $collection[] = new Player($row['username'], $row['password'], $row['id']); } return $collection; }