Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please do option 1 rather than 2. Only need the code for the 3 files. aplement a web based application that valudates user logons. Your
Please do option 1 rather than 2. Only need the code for the 3 files. aplement a web based application that valudates user logons. Your application must inelude: 1. A MySQL database with a table for valid users. This table at minimum must include each users name, E-mail, and password.In addition, each user must be a member of a department table, of which multiple users can be members of the same department, Use your ER diagram skills to make sure to develop properly implemented tables for this. User IDs and usemames are optional if as a design decision you decide that e-mail addresses must be unique among users and can be used as the user ID. The password should be hashed 2. AS AN ALTERATTVE: use the existing employee database. Nore that employees have neither E-mail, nor pasawords, For the key, use the emp_no column as an altemative for E-mail. Then pick one of the other fields in the table (such as birthdate or hire date) to use as the password. Note that because you do not have nrite access to this database, no password hashing is necessary. Finally the tabie that relates empolyees and departments is named dept_emp. This table has additional fields indicating the time of service of an employee in a department. Fer thay project, the department for the employee to match is the department they are currently working for, which at the entry with a to_date of 99990101. 3. A HTML web form page that requests the user to login with a valid username e-mail enp no and a pasword In addition, the page must populate either a menu, of a collection of radio buttens, with a list of all of the departments in the system. Note that this activisy requires accessing the database in order to get that list of departments. 4. A successful login page that welcomes the user by name. It is aceeptable to display all ether user information except for the pasword on this ruceeis page. 5. An error page for ussuccessful logins. This page must incorporate a link that routes the user back to the login page. 6. A PHP script using PDO that validates the login information submitted on the login page against the MySQL database. All of the username E-mail, password, and department given by the user must match in the user database. This seript directs (or generates) to the suceessful error page based on validity of the incoming login information. Note this script must be implemented to resist SQL injection attacks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started