Develop RESTful web service using the following languages: PHP, MySQL. Create an interface for the web service using HTML, CSS, and JS.

What the web service does: provides/ stores information about teams and players of any sports team

Quick Summary -

The web service should provide and maintain information about the teams and players of a team-based sport of your choice. It must be implement using PHP and PHP alone. Underlying the web service must be a MySQL database storing that information. The PHP Data Objects (PDO) extension of PHP must be used to implement the interactions with the database.

1) MAKE THE DATABASE: using MySQL to store the following constraints:

- Information on three teams, team info includes: team name, sports played, average age of team members (at a particular time)

- For each team there is info on 3 players too

- Team member information includes: first name, surname, nationality, and date of birth

- Team and player names should initially only used ASCII characters

2) The database should be able to accommodate an arbitrary number of teams with arbitrarily many team member

3) MAKE THE WEB SERVICE: This can only be functional via REST API, web service must be provided in JSON format and return information in this format

- retrieve information on all the teams (include a link to the collection resource for all player of each team), sorted by team names

- retrieve information on all players of a specific team;

- retrieve information on an existing player of a team;

- add a player / team member to a team;

- delete an existing player / team member from a team;

- update information for an existing player / team member of a team.

4) Web service should react appropriately to requests such as:

- relating to a non-existing resource (deleting a non-existing team member)

- adding a team or updating information on a team

5) INTERFACE - allows user to interact and test the web service. Interface should interact with the web service using Ajax and all operations related to the interface should be implemented using JavaScript.

Interface elements include:

- a drop-down menu that allows to select a HTTP method;

- a text field with a width of 80 characters that allows to enter a resource;

- a text area with a width of 80 characters and a height of 5 characters that allows to enter a request body in JSON;

- a button that triggers a request to be send to the web service based on the information of the three interface elements;

- an area that shows the HTTP status code received in response to a request;

- an area that shows the HTTP response body;

- a button that clears the content of the three areas that the interface uses to display parts of the HTTP response.

Please can anyone help with thisss!!!