This repository contains all the project files and necessary details about applications required to run the project on your local machine.

NOTE: Please read the installation and execution steps provided below before downloading. Thank you.

Project demo: Project demo video link

FIFA 18 Player management system is a player management software for monitoring and accessing players based on their FIFA 18 PC/XBOX game ratings. HTML, CSS, and JavaScript were used for front-end development, and PHP and MySQL were used for back-end development. The system mainly focuses on basic operation like adding a new player, new statistics, searching players with detailed information and edit as they grow their skills. It is a web-based application designed and developed to help users access players and organize their teams. It’s easy to use, and it features a familiar and attractive user interface combined with strong searching, insertion, and deletion with procedure capabilities.

One of the most difficult tasks is the selection of correct version of software. Once the system requirements are known the next step is to determine whether the software package fits the requirements. After initial selection further security is needed to determine the desirability of software compared with other candidates. This section first summarizes the application requirement question and then suggests more detailed comparisons.

1. 32/64-bit processor
2. i3 or greater intel processor chip
3. 1.7 or more GHz processor

1. Windows 7 or higher version OS
2. Google chrome v70.0.3538 or greater
3. WAMPP web server
4. Brackets web editor

This project consists of player details which include the likes of player’s age and nationality. It also consists of player statistics which include players technical skills. It also consists of tables containing information such as player earnings, club, and preferred position to play. It also provides a strong search, update, delete, and insert operations delivered with a user-friendly web-based UI. The project also helps the users to keep track of the player details in a computerized way without any trouble. The project contains 7 stored procedures and 3 triggers per table. Stored procedures are used in search engine. Every time the user searches through the database, a procedure is called, and the results is collected and displayed for the user in a structured manner. It also has 3 triggers namely “Insert, Delete and Update” triggers assigned separately to each table. Whenever operations such as insert or delete or update is performed on any table, these triggers are automatically called, and the logs are captured into 3 separate tables, individually for each trigger. Hence use of triggers provides users to trace back all the latest as well as the oldest changes into any table at any point of time.

1. Install wamp Download wamp from here 299Mb and update google chrome download latest chrome from here.

2. After installing wamp (Default directory : c:/wamp64/) , download the project and paste it in directory : (c:/wamp64/www/).

3. Set your wamp username to root and no password. Instructions to change username and password

4. Start wampServer64 from the desktop icon and open google chrome and type the following url without quotes: "http://localhost/phpmyadmin/" and enter root as username and press Go.

5. Now first you have to Load the database in your local server and then you can run the project.

   To load the database :

    - Click on +New on the left hand column
    - Give database name as "fifa" (without quotes and small case) and set character encoding to "utf8mb4_unicode_ci"
    - After creating the database successfully, on the upper main menu panel, click on Import and then click "choose file" from file to import menu. Now browse to directory where you saved the project (expected directory: c://wamp/www/your_project_name/db/fifa.sql) and click on fifa.sql and then go down and click Go (Do not change any other settings).
    - After importing successfully, loading the database is complete.
   

   Run the project :

      - Open a new tab in chrome
      - type the following url : http://localhost/your_project_name_inside_www_directory/index.html
      - enjoy.
   

1. JSLint

For further queries : Drop me mail at [email protected]