Using PHP and MYSQL: Lab submission details: The issues is with the code but mainly in the transitions between the pieces.

Using PHP and MYSQL:

Lab submission details: For your lab for this week, I need help designing an application. The issues is with the code but mainly in the transitions between the pieces. The application should satisfy the following requirements:

a. Allows a user to register and login to a Game application

b. When registering the user should provide a unique username, password, and 3 security questions. The password should be at least 8 characters in length and should include at least one upper case letter, one number and one special character. The three security questions should be from one of 10 prepared security questions that you design. For example, have them select from a list of 10 questions and provide their answers to 3 they select.

c. When logging into the Game application, if the username and password are correct, the application should ask one of the 3 security questions. The question should be randomly selected.

d. Access to the Game is granted if both the username and password are correct and the random security question was answered correctly.

e. The game shall be a simple mathematical formula in the form of a question from randomly generated numbers. For example, the game could be as simple as What is 102 * 203? You should select the formula used and the range of random numbers for each variable.

f. A scoring mechanism should be available that stores the high score of each user. You should design a points system for scoring the game.

g. The user with the highest score and their score should be displayed on the application after logging into the system.

h. The application should allow the user to submit the answer and provide feedback as to whether the answer was correct or not.

i. The user can quit the game at any time.

j. The user can logout of the game application at any time.

k. The application should allow the user to update their username, password and security questions at any time.

l. The application should allow the user to delete their account at any time.

Design requirements include the following:

a. Data must be stored and organized in MySQL tables. The required data should be the User data (username, password, security questions and answers), and high scores for each user. The mathematical formulas do not need to be stored in the database. Your database design should be relational with no redundant data in the tables and consist and primary and foreign keys as needed. (Hint: You should not put all of the data in one table)

b. Your design should be secure and at a minimum ensure no SQL injection is possible, passwords are encrypted in the database, passwords are encrypted in parameter tables, and security questions are encrypted in the database and only the least amount of privileges are given to database and web users for them to perform their functions.

c. Take the time to design the flow of your forms, such that they flow logically within your application and are presented in an attractive easy-to-use Web interface. 20

d. Create screen captures showing the successful running of your application from registering a user to playing the game to updating and deleting user accounts. Each screen capture should be fully described.