Skip to content

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

Notifications You must be signed in to change notification settings

praths71018/Fut_Stats

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:

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.