Last Program

1. Review the customer requirements

Customer Requirements: The customer realized that they would like to run additional reports, and wants to begin using this tool to record their timesheets. They need a landing page with a menu for each task and two pages that allow them to record timesheets and get a report for a specific employee id. They also want you to link the previous report you made for them in Lab 13.

When the customer asks for a timesheet report, they want to enter the employee ID and receive a total number of hours recorded for that employee, as well as the employee’s name for confirmation.

They want all their pages to have a consistent banner, menu, and color scheme that is high contrast.

2. Review the example IPO below.

3. Create 3 HTML files:

a. A Landing Page

· The landing page must contain links to the other html forms, a banner with a headline with a descriptive headline

b. Time Entry Form

· An html file that contains a banner with descriptive headline

· Form allowing the user to enter an employee ID and hours worked

· Instructions for using the form

c. Timesheet Search

· An html file that contains a banner with descriptive headline

· Form allowing the user to enter an employee ID

· Instructions for using the form

4. Create 2 PHP files

a. Using Lab 13 as a guide, create two PHP files that handle the forms mentioned above

b. Time Entry PHP

· Puts _POST responses from user into variables

· Stores user input into timesheet using SQL INSERT

· Prints confirmation message on success

c. Timesheet Search PHP

· Puts _POST responses from user into variables

· Search database for timesheet entries based on provided Employee ID

· Prints table containing

d. PHP files NEED LINKS back to form entry html pages

5. Style HTML and PHP in a new style.css

a. Create a stylesheet and apply the same stylesheet to all pages using external css

b. Apply a color scheme that uses dark text on a light colored background. For headlines, reverse this color scheme, including table headings.

c. Apply padding to table data to make table more readable

6. Zip files together and submit to Blackboard after testing:

a. 3 HTML files (Landing Page, Two Forms)

b. 3 PHP files (Time Entry, Timesheet Search, Lesson 13 report)

c. CSS style sheet

Input, Processing and Output:

AY2022