1. Class exercises: Main page (Figure 1. program name: index.html) & View all employees function.

1.1 If users click View all employees( call program: view_employee.php, Figure 4) , your program should

(i) Retrieve all employees from TECH3740. EMPLOYEE table and list all employees in HTML TABLE format as shown in Figure 4.

(ii) If the salary is NULL, print it in red color.

(iii) If Gender=M, print it in blue color, Gender=F, print it in red color.

(iv) Display the average salary of listed employees at the bottom of the employee table.

(v) A statement There are # employee(s) are in the database. should be displayed above the employee table.

Average salary: 3,100.0 Average salary: 3,100.0