("View all employees" function) If users click "View all employees" ( call program:
view_employee.php), your program should
(i) Retrieve all employees from TECH3740. EMPLOYEE table and list all employees in HTML
TABLE format
(ii) If the salary is NULL, print it in red color.
(iii) If Gender='M', print it in blue color. If 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) in the database." should be displayed above the
employee table, where # is the number of employees.
Transcribed Image Text:| Fname +- | Jared Jon Justin Brad John Evan Josh Andy Tom Jenny Chris Kim Jeff | Alex | Bonnie Alec Sam Joyce John Nandita Bob Jill Kate Lyle Billie Jon Ray | Gerald Arnold Helga Naveen Carl Sammy Red Ramesh James Jennifer Ahmad | Minit | Lname James Jones Mark Knight | Smith | | Wallis Zell Vile | Brand | F | A | C | н Franklin | T | D | S | C | Alicia D | C NULL | C | В E | U с G S | A | C | к B | J W G | A | H D | A | с | B | E G A | K | E | S | V | J | Ssn | 111111100 | 111111101 111111102 | 111111103 123456789 | 222222200 222222201 222222202 222222203 | 222222204 222222205 333333300 333333301 | 333445555 444444400 444444401 | 444444402 | Snedden | 444444403 | English | 453453453 James Ball 555555500 555555501 666666600 | 666666601 666666602 666666603 666666604 666666605 666666606 | 666666607 666666608 666666609 666666610 666666611 666666612 666666613 | Narayan | 666884444 Borg Bacher | 888665555 | Wallace | 987654321 987987987 | Jabbar | Zelaya | 999887777 Vos Carter Grace | Chase Wong Freed Bays | Best | Bender Jarvis King | Leslie | King | Kramer King Small | Head | Pataki Drew Reedy Hall | Bdate | Sex | M IM | Address 1966-10-10 | 123 Peachtree, Atlanta, GA 1967-11-14 | 111 Allgood, Atlanta, GA 1966-01-12 | 2342 May, Atlanta, GA 1968-02-13 | 176 Main St., Atlanta, GA 1955-01-09 | 731 Fondren, Houston, TX 1958-01-16 | 134 Pelham, Milwaukee, WI 1954-05-22 | 266 McGrady, Milwaukee, WI 1944-06-21 | 1967 Jordan, Milwaukee, WI 1966-12-16 112 Third St, Milwaukee, WI 1967-11-11 | 263 Mayberry, Milwaukee, WI 1960-03-21 | 565 Jordan, Milwaukee, WI 1970-10-23 | 6677 Mills Ave, Sacramento, CA 1970-01-07 145 Bradbury, Sacramento, CA 1945-12-08 | 638 Voss, Houston, TX 1950-10-09 | 4333 Pillsbury, Milwaukee, WI 1956-06-19 | 111 Hollow, Milwaukee, WI 1966-06-18 | 233 Solid, Milwaukee, WI 1977-07-31 | 987 Windy St, Milwaukee, WI 1962-07-31 | 5631 Rice Oak, Houston, TX 1975-06-30 | 7676 Bloomington, Sacramento, CA | M 1969-04-16 | 222 Howard, Sacramento, CA M 1968-04-17 8794 Garfield, Chicago, IL M F F | M F M M M IM 1966-01-14 | 6234 Lincoln, Chicago, IL 1966-04-16 | 1976 Boone Trace, Chicago, IL 1963-06-09 | 417 Hancock Ave, Chicago, IL 1960-01-01 556 Washington, Chicago, IL 1964-08-22 | 1988 Windy Creek, Seattle, WA 1949-08-16 | 213 Delk Road, Seattle, WA 1962-05-15 | 122 Ball Street, Dallas, TX 1967-05-19 | 233 Spring St, Dallas, TX 1969-03-11 101 Holyoke St, Dallas, TX 1970-05-23 | 198 Elm St, Philadelphia, PA 1977-06-21 | 213 Ball St, Philadelphia, PA 1970-01-11 | 433 Main Street, Miami, FL 1980-05-21 | 196 Elm Street, Miami, FL 1952-09-15 | 971 Fire Oak, Humble, TX 1927-11-10 | 450 Stone, Houston, TX 1931-06-20 | 291 Berry, Bellaire, TX 1959-03-29 | 980 Dallas, Houston, TX 1958-07-19 | 3321 Castle, Spring, TX F M | M M | M M M M | M | M M M M F F | F M M | M F M | M F M | F M | F | Salary | 85000.00 | NULL | 45000.00 | 111111100 40000.00 | 111111100 | Super_ssn | Dno | 44000.00 | 111111100 | 30000.00 | 333445555 | | 92000.00 | NULL | 56000.00 | 222222200 | 53000.00 | 222222200 | 62500.00 | 222222200 | 61000.00 | 222222201 43000.00 | 222222201 |79000.00 | NULL | 44000.00 333333300 | 40000.00 | 888665555 | |89000.00 | NULL 70000.00 | 444444400 | 60000.00 | 444444400 | 48000.00 | 444444400 | 25000.00 | 333445555 | 81000.00 | NULL | 62000.00 | 555555500 | 96000.00 | NULL | 36000.00 | 666666600 | 44000.00 | 666666600 | 41000.00 | 666666601 | 38000.00 | 666666603 | 41500.00 | 666666603 44500.00 666666604 | 29000.00 | 666666602 | 33000.00 | 666666602 | 32000.00 | 666666602 | 34000.00 | 666666607 | 32000.00 | 666666610 | 37000.00 | 666666611 | 33500.00 | 666666612 | 38000.00 | 333445555 | 55000.00 | NULL | 43000.00 | 888665555 | 25000.00 | 987654321 | 25000.00 987654321 | 666NNAN LONN ∞ ∞ ∞ ∞ ∞0 00 00 00 00 00 00 00 00 00 L 6 | 6 | 6 5 7 | 7 7 7 7 7 6 6 | 5 7 | 7 7 7 5 6 | 6 | 8 8 8 8 | 8 | 8 8 8 8 8 8 8 8 8 5 1 4 | 4 | 4
Transcribed Image Text:There are 6 employee(s) in the database. ID Login Password Name Role Gender Salary Address 1 tiger xyz123 Victor Smith S M 2500 1000 Morris Ave., Union, NJ 07083 John Lee 5000 133 Main St., Austin, TX E M |Austin test S F New test M 6000 71 Central Ave., Newark, NJ 07188 NULL 460 4th Ave., New York, N 101 1000 100 Texas Rd, Edison, NJ 07711 1000 100 Main Rd, Edison, NJ 07711 Tester 2019 E F my Test M 2 panda xyz333 5 Austin 613d3b9c91 6 fish ||111 7 bear 8 lion 1234 abc123 Average salary: 3,100.0 EES E

Question

(&#34;View all employees&#34; function) If users click &#34;View all employees&#34; ( call program:view_employee.php), your program should(i) Retrieve all employees from TECH3740. EMPLOYEE table and list all employees in HTMLTABLE format(ii) If the salary is NULL, print it in red color.(iii) If Gender='M', print it in blue color. If 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 &#34;There are # employee(s) in the database.&#34; should be displayed above theemployee table, where # is the number of employees. | Fname+-| JaredJonJustinBradJohnEvanJoshAndyTomJennyChrisKimJeff|Alex| BonnieAlecSamJoyceJohnNanditaBobJillKateLyleBillieJonRay| GeraldArnoldHelgaNaveenCarlSammyRedRameshJamesJenniferAhmad| Minit | LnameJamesJonesMarkKnight| Smith|| WallisZellVile| Brand| F| A| C| нFranklin | T| D| S| C| AliciaD| CNULL| C|ВE|UсGS| A| C| кB| JWG| A| HD| A| с| B| EGA| K| E| S| V| J| Ssn| 111111100| 111111101111111102| 111111103123456789| 222222200222222201222222202222222203| 222222204222222205333333300333333301| 333445555444444400444444401| 444444402| Snedden | 444444403| English | 453453453JamesBall555555500555555501666666600| 666666601666666602666666603666666604666666605666666606| 666666607666666608666666609666666610666666611666666612666666613| Narayan | 666884444BorgBacher| 888665555| Wallace | 987654321987987987| Jabbar| Zelaya | 999887777VosCarterGrace| ChaseWongFreedBays| Best|BenderJarvisKing| Leslie| King| KramerKingSmall| Head|PatakiDrewReedyHall| Bdate| Sex| MIM| Address1966-10-10 | 123 Peachtree, Atlanta, GA1967-11-14 | 111 Allgood, Atlanta, GA1966-01-12 | 2342 May, Atlanta, GA1968-02-13 | 176 Main St., Atlanta, GA1955-01-09 | 731 Fondren, Houston, TX1958-01-16 | 134 Pelham, Milwaukee, WI1954-05-22 | 266 McGrady, Milwaukee, WI1944-06-21 | 1967 Jordan, Milwaukee, WI1966-12-16 112 Third St, Milwaukee, WI1967-11-11 | 263 Mayberry, Milwaukee, WI1960-03-21 | 565 Jordan, Milwaukee, WI1970-10-23 | 6677 Mills Ave, Sacramento, CA1970-01-07 145 Bradbury, Sacramento, CA1945-12-08 | 638 Voss, Houston, TX1950-10-09 | 4333 Pillsbury, Milwaukee, WI1956-06-19 | 111 Hollow, Milwaukee, WI1966-06-18 | 233 Solid, Milwaukee, WI1977-07-31 | 987 Windy St, Milwaukee, WI1962-07-31 | 5631 Rice Oak, Houston, TX1975-06-30 | 7676 Bloomington, Sacramento, CA | M1969-04-16 | 222 Howard, Sacramento, CAM1968-04-17 8794 Garfield, Chicago, ILMFF| MFMMMIM1966-01-14 | 6234 Lincoln, Chicago, IL1966-04-16 | 1976 Boone Trace, Chicago, IL1963-06-09 | 417 Hancock Ave, Chicago, IL1960-01-01 556 Washington, Chicago, IL1964-08-22 | 1988 Windy Creek, Seattle, WA1949-08-16 | 213 Delk Road, Seattle, WA1962-05-15 | 122 Ball Street, Dallas, TX1967-05-19 | 233 Spring St, Dallas, TX1969-03-11 101 Holyoke St, Dallas, TX1970-05-23 | 198 Elm St, Philadelphia, PA1977-06-21 | 213 Ball St, Philadelphia, PA1970-01-11 | 433 Main Street, Miami, FL1980-05-21 | 196 Elm Street, Miami, FL1952-09-15 | 971 Fire Oak, Humble, TX1927-11-10 | 450 Stone, Houston, TX1931-06-20 | 291 Berry, Bellaire, TX1959-03-29 | 980 Dallas, Houston, TX1958-07-19 | 3321 Castle, Spring, TXFM| MM| MMMM| M| MMMMFF| FMM| MFM| MFM| FM| F| Salary| 85000.00 | NULL| 45000.00 | 11111110040000.00 | 111111100| Super_ssn | Dno| 44000.00 | 111111100| 30000.00 | 333445555 || 92000.00 | NULL| 56000.00 | 222222200| 53000.00 | 222222200| 62500.00 | 222222200| 61000.00 | 22222220143000.00 | 222222201|79000.00 | NULL| 44000.00333333300| 40000.00 | 888665555 ||89000.00 | NULL70000.00 | 444444400| 60000.00 | 444444400| 48000.00 | 444444400| 25000.00 | 333445555| 81000.00 | NULL| 62000.00 | 555555500| 96000.00 | NULL| 36000.00 | 666666600| 44000.00 | 666666600| 41000.00 | 666666601| 38000.00 | 666666603| 41500.00 | 66666660344500.00 666666604| 29000.00 | 666666602| 33000.00 | 666666602| 32000.00 | 666666602| 34000.00 | 666666607| 32000.00 | 666666610| 37000.00 | 666666611| 33500.00 | 666666612| 38000.00 | 333445555| 55000.00 | NULL| 43000.00 | 888665555| 25000.00 | 987654321| 25000.00987654321 |666NNAN LONN ∞ ∞ ∞ ∞ ∞0 00 00 00 00 00 00 00 00 00 L6 |6 |657 |7777766 |57 |77756 |6 |8888 |8 |888888888514 |4 |4 There are 6 employee(s) in the database.ID Login PasswordNameRole Gender Salary Address1 tiger xyz123Victor Smith S M 2500 1000 Morris Ave., Union, NJ 07083John Lee5000 133 Main St., Austin, TXE M|Austin testSFNew testM6000 71 Central Ave., Newark, NJ 07188NULL 460 4th Ave., New York, N 1011000 100 Texas Rd, Edison, NJ 077111000 100 Main Rd, Edison, NJ 07711Tester 2019 EFmy TestM2 panda xyz3335 Austin 613d3b9c916 fish ||1117 bear8 lion 1234abc123Average salary: 3,100.0EESE

Accepted Answer

1-- Table structure for table 'employee'
2
3CREATE TABLE employee (
4  employee_id INT NOT NULL,
5…