Fut_Stats : A Football Statistics Website

Website which displays football statistics of top 5 leagues for the season 2022-2023.

Technology stack:

• MySQL
• ReactJS
• ExpressJs
• Python sql.connector

To understand how the application was built , please refer to the Manual.pdf.

The frontend Interface screenshots are in page 29 onwards in Manual.pdf.

Credits

Data for the football statistics is sourced from:

• www.fbref.com
• UEFA
• FIFA

Running the Application

1. Creating Database

1. Open your terminal.

2. Navigate to the csv_to_database directory of your project using the cd command:

   cd csv_to_database

3. Change the database configuration settings in main.py file of the football statistics website to match your database settings. Locate the db_config variable and update it as follows:

   db_config = {
       "host": "your_host",  # Update with your database host
       "user": "your_username",  # Update with your database username
       "password": "your_password",  # Update with your database password
       "database": "Football_Stats"  # Update with your database name
   }

4. Run main.py

   python main.py

2. Backend:

1. Open another terminal window or tab.

2. Navigate to the backend directory of your project using the cd command:

   cd backend

3. Start the backend server using npm:

   npm start

4. After starting, you should see a message indicating that the server is running on a specific port (port 8081) and that it's connected to the database.
   

2. Frontend:

1. Open another terminal window or tab.

2. Navigate to the frontend directory of your project using the cd command:
   

   cd frontend

3. Start the frontend server using npm:

   npm start

4. After starting, you should see a message indicating that the frontend has been compiled successfully, and you can now view it in the browser.

   • Local: http://localhost:3000
   • On Your Network: http://192.168.0.101:3000 (if you want to access it from other devices in the same network)