Language Php

Here you are required to implement a university registration portal where university (Admin user)can add staff and students to its database. After adding staff or student in database, system will generate verification email with username and password. The student and staff will verify its email in order to logged in into system. The Students records can insertedby staff members after login whose accounts are verified through email. You need to implement this portal system with ACL control list and ajax will also used here in the search. You will perform CRUD operations (insert, update, delete, view) here other Instructions are given below.

Student table

Student Email (PK)also acts as Fk of user table First name Last name telephone no mobile no country city area gender age address postal code

Staff table

staff Email (PK )also acts as FK of user table first name last name telephone no mobile no country city area gender age address postal code

User

UserEmail (Pk) Sameemail should be given in student and stafftable Password ActiveFlag (initially No, could be Yes after email verification) Rid(FK) Role id of user, primary key in role table

Requirement:

Admin record should be added in database manually On admin page admin can ADD Delete Update And view all Staff members and student In admin dashboard we have different views of both staff and students entries along with its active flags such as which student or staff is active or not. Admin have right to enable or disable activeFlags of all users Only true Flag Users (Activated after email verification) can log in into the system. When staff/student is added in database, systems will automatically generates verification email with their username and password to all users After staff/student verification, he/she can login into system After login every user have its own menu according to his/her privileges Staff dashboard have Options to ADD Delete Update and View all Student Student can view his data information after login at his studentdash board page Session tracking should be added on session racking i.e. no user can bypass login process All pages should have proper JavaScript regular expression implemented Pages Details

Login page

Login page have email field Password field User type dropdown (admin,student staff) Login button It should redirect you to the select user type page dashboard if its valid details Forget password button It should redirect you to change password page Admin dashboard page

We have navigation Bar here On navigation bar we have Home button On home we have 2 html tables that show details of Student and staff Add staff Button This page Contains text fields to add Staff data (all fields of staff table) using his all-data member This page also get user table information (i.e Password,email, activeFlag, roleid) Add Student Button This page Contains text fields to add Student data (all fields of staff table) using his all-data member This page also get user table information (i.e Password, email, activeFlag, roleid) View Button On this page we have two buttons View Student This button redirects you to page where student table is displayed where you can edit student record Here you can also remove student record And button to display one student full record View Staff This button redirects you to page where staff table is displayed where you can edit staff record Here you can also remove staff record And button to display one Staff full record Search Staff On this page AJAX should be implemented to search staff data from table. Search Student On this page AJAX should be implemented to search student data from table. Log out Button Redirected to login screen

Staff Dashboard

Redirected to Home page On home Page we have all details of students We have navigation Bar here On navigation bar we have Home button Redirected to Home View Button This button redirects you to page where student table is displayed where you can edit student record Here you can also remove student record And button to display one student full record Add Student Button This page Contains text fields to register Student data using his all-data member Password and email verification also happening on this page Search Student On this page AJAX should be implemented to search Student data from table. Log out Button Redirected to login screen Student Dashboard We have navigation Bar here On navigation bar we have Home button Student can view his/her Details here who Logged in Log out Button Redirected to login screen