Please see the task in the Assignment 5 pdf file. Need to add php code. Optional question at the end is not required.
ASSIGNMENT 5 | SESSIONs + User Management ASSIGNMENT 5 | SESSIONS + USER MANAGEMENT PRAVIIN M | IS 667 | 71749 | ONLINE 1 We have discussed sessions in class. Now, it is time to put sessions to use. Do the following: • We already have a database (UserManager attached in assignment files) and we also have a table that manages users. These users come with a user id! • Create a table to hold roles, which will contain a column for userid and then the role they have been granted. (you will need to join the user and the roles tables for fetching the information during login) • You should have different roles for performing the following operations o Admin (role): Should be able to do everything on the application; which is, create, update, delete a record. o Record Manager: This role should be able to create, edit, delete and view the users that they have created. Let`s say there are two record managers, FrodoBaggins and Gollum. Frodo should be able to edit and delete the records Frodo has created. They should not be able to touch Gollum`s records. On the other hand. Admin (Gandalf) should be able to edit. Delete both Frodo’s and Gollum’s records. o General User: This user role will NOT be able to create, delete, edit records. They should only be able to see all the records in the system. – Marked with who created the records! • If you are feeling adventurous, you can create a page to reassign roles instead of hardcoding them in the database. Which means, and admin can make P1, P2 and other users of the system into admins or general users. In short be able to manage roles through a GUI. (This question is totally optional) Copy your functions (code) to a file along with screenshots of your output and what not and upload to blackboard.