Database and Web Application for Football Competitions

U sklopu završnog rada razvijen je sustav za praćenje rezultata nogometnih natjecanja koji omogućava pregled rezultata i tablica nogometnih natjecanja i prikaz raznih statistika na temelju njih. Sustav se sastoji od dva dijela: baze podataka i aplikacije. U bazi podataka se čuvaju svi podaci koji se putem aplikacije prikazuju na korisniku prilagođen način. Aplikacija podržava i rad administratora koji putem nje mogu unositi, mijenjati i brisati podatke iz baze podataka bez potrebe za poznavanjem organizacije same baze. Korisnici mogu pregledavati razne podatke o klubovima, poput odigranih utakmica i brojnih statistika, kao i podatke o pojedinačnim igračima i njihovim statistikama. Za implementaciju baze podataka korišten je MySQL, dok je aplikacija implementirana jezicima HTML, CSS, JavaScript i PHP.In this thesis a system for keeping track of football competition results was developed which allows the view of results and tables of football competitions and display of various statistics based on that data. The system is made of two parts: database and a web application. The database stores all the data which are displayed via application in a user friendly way. The application supports an administrator mode, which can be used to insert, update or delete the data from the database without knowing its internal organization. Users can view various info on clubs, such as games played and numerous statistics, as well as info about individual players and their stats. The database was implemented using MySQL and the application was implemented using languages such as HTML, CSS, JavaScript and PHP