Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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);

image text in transcribedimage text in transcribed

-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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 4.5 Databases

Authors: Sandeep Chanda, Damien Foggon

3rd Edition

1430243805, 978-1430243809

More Books

Students also viewed these Databases questions

Question

LO1 Understand human resource management and define human capital.

Answered: 1 week ago