Question
Please help me with this HTML program. We are using PHP and AJAX. You don't need to copy the rubric into the program, just make
Please help me with this HTML program. We are using PHP and AJAX. You don't need to copy the rubric into the program, just make sure that the tasks 1-7 in the rubric are complete. Please post all files that contain code. Thank You!
These are the SQL statements to create the table:
CREATE TABLE IF NOT EXISTS `fe_login` ( `studentId` int(5) NOT NULL, `username` varchar(20) DEFAULT NULL, `password` varchar(40) DEFAULT NULL, `failedAttempts` tinyint(1) DEFAULT NULL, `daysLeftPwdChange` tinyint(4) NOT NULL, PRIMARY KEY (`studentId`) );
INSERT INTO `fe_login` (`studentId`, `username`, `password`, `failedAttempts`, `daysLeftPwdChange`) VALUES (11, 'jdoe', 'd35514736146439b7277437016cdb40d7fb65497', 0, 0), (12, 'bdeer', '82cf79eb10c01b34b89f78597527304826a70adb', 0, 15), (13, 'jlopez', '00f8d68f7ddbbc78deb6ebdda3f67b6c2b68d9ff', 3, 0), (14, 'mgriffin', 'd6a197c390faea348178062ca4b52136880bffdb', 3, 0), (15, 'bob', '48181acd22b3edaebc8a447868a7df7ce629920a', 1, 20), (16, 'sue', '1eac7bdcbb6c569f15ecbf5cd873a2c477888e56', 2, 20);
-1 Program 1: Login Page (42 pts) 1. Open your PhpMyAdmin interface. In your "final_exam" database, copy the queries included in this file. The queries should create and populate the table fe_login 2. Within your "final" folder, create a file called "program1.php" and add a login form. 3. Upon typing the username: a. Make an AJAX call to check the value of the "daysLeftPwdChange" field. This field indicates the number of days left to force users to change their password b. If the value of "daysLeftPwdChange" is lower than 16 but higher than 0, display this message in orange You have x days to change your password", where "x" is the value of "daysLeftPwdChange" c. If the value of "daysLeftPwdChange" is 0: Display this message in red: "You must change your password. Go to http://id.xyz.edu" d. The AJAX call should also check the value of the "failedAttempts" field. This field indicates the number of failed attempts. e. If the value of "failedAttempts" is 3: Display this message in red: "Your account is locked. Go to http://id.xyz.edu to reset your password" f. In either case a message in red is displayed: Prevent that the user logs in by disabling or hiding the submit button Enable or show the submit button once more after the user starts retyping the username 4. Increase the value of "failedAttempts" for a specific username when submitting the wrong password Once you finish, come back here and click on the "Copy Rubric" button below. Then press CTRL+C to copy the rubric HTML code into the clipboard. Paste it at the bottom of your program and update the background color of the items you've completed. If you're unsure about an item, use white background. Cony Ruhric
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