PLEASE FOLLOW THE GUIDELINE TO YOUR PHP PROJECT: --------------------------------------------------------------------------------------------------- 1. SUBMIT ONE ZIP FILE including: the PHP files , ONE database file(.sql) and a detailed explaination (I know files can't be added, Just Presenting the structure)!!! 2. MAKE sure to include a file called "connection.php" that you should use at EACH time you access the Database. I cannot change the code manually for the database name. Otherwise, I will remove 10 points. 3. Prepare a brief explanation about the project. Each time you perform an action, you should show me the result in the Database to make sure that the code is running properly. 4. YOU SHOULD USE ONLY the explained concepts in the class. ONLY PHP(index, variables, selection, arrays[associative/Multi-dimensional], forms, Database[.sql], Sign in, Sign up, Sessions & Joins, Foreign Key & Join Operation), HTML,CSS ,javascripts, AJAX...

____________________________________________________________________________________________________________________________________________________

>>>QUESTION OR REQUIRED PROJECT:<<<

Start with a login page with at least 2 types of users, for example: role:1 admin role: employee You can start with a simple database such as : - an employee works on projects - a student borrow books - client buy items online - a client order pizza(s), - .... You create the page admin with full control where the admin can CRUD all tables. For example, a client can see the available items or an employee can see the assigned projects. We can easily extend the above by adding features such as , the client can buy items instead of just listing the items