COMP2020 - Technologies for Web Applications Assignment

Assignment Task

Background information and description

The aim of this project is to develop a simplified Exercise Tracker website that enables tracking of exercise workouts. Users can create an account, log their workouts, track their progress over time, and view basic statistics to check their progress. The details for the users and their workouts are stored in a MySQL database named Fitness. The Exercise Tracker website connects to this database to dynamically create the web page content. Additionally, the Exercise Tracker website will allow administrators to manage user accounts. The website will use PHP for server-side scripting and MySQLi for database interaction.

Functional Requirements

• Your Web Application must
• Be coded using HTML 5, CSS, JavaScript, and PHP as necessary. Note: any files described below that require any type of server-side functionality must be PHP files to achieve the functionality,
• Use MySQLi to utilise the Fitness database,
• Provide consistent and easy-to-use navigation for all user types as appropriate. For example, navigation to a members-only page should not be present when the authenticated user is an administrator. Likewise, navigation to administrator-only pages should not be present when the authenticated user is a member.
• Be designed for a 1366-pixel wide screen and be accessible,
• Provide the following page content and functionality as described. Note: php pages other than those listed below may be needed for a full solution.

Database Description

1. Tables in the Fitness database are outlined in the Data Dictionary in appendix.

2. You have been provided with your own copy of the Fitness database on the TWA server. To access this database, you need to use a username and password. Details on how to connect to your copy of the database are in appendix.

3. The tables within the Fitness database have already been populated with some data. Use the ViewAllTables.php script to view the data (make sure you use the connection information as indicated above). This script is found in the project zip file.

4. A list of usernames and plain text decrypted passwords can be found in User Credentials in appendix.

This COMP2020 – IT and Computer Science has been solved by our PHD Experts at My Uni Paper.