Learning outcomes: The student demonstrates PHP and MySQL Database operations skills You will write a .php program for each query and upload the .zip file of it on slate. (The zip file will contain 5.php files and one main file) Requirements: Assume we have a database "company' and it contains a table employee (emp_id primary key INT, emp_Name TEXT, emp_email TEXT, emp_dept TEXT ' and emp_salary DOUBLE). At the beginning, you will create at least 5 records for this table (like the way we did in the class). You will write.php program that performs following actions: You will create main.php file that contains 5 html forms (one for each query). 5 Marks 1. Add an employee record to existing table. (If an employee with the same email address already exists, it should display appropriate error message. The emp_id should be auto increment integer value) add.php 5 Marks 2. Modify an employee record (Assume that employee changes his/her department. If the new department is same as the employee currently working in, it should display an appropriate message (Should not make any change to the table). modify.php 5 Marks 3. Delete a record from table. The deletion should be done based on first emp_name and emp_dept. If no such employee exists, it should display the appropriate message otherwise it should update the table. delete.php 5 Marks 4. Display the employee table by grouping the employee based on employee department. delete.php 2 Marks 5. Filter the table based on employee department and salary range. For example, you want to see those employees whose salary lie in the range of $6000-$8000 per month and do belong to FAST department filter.php 3 Marks After the execution of each query, it should display the resultant table. Web Programming SYST10199- Assignment 5:(Basics of PHP) MM: 25 Weight:10% Learning outcomes: The student demonstrates PHP and MySQL Database operations skills You will write a .php program for each query and upload the .zip file of it on slate. (The zip file will contain 5.php files and one main file) Requirements: Assume we have a database company' and it contains a table 'employee (emp_id primary key INT, emp_Name TEXT, emp_email TEXT, emp_dept TEXT 'and emp_salary DOUBLE). At the beginning, you will create at least 5 records for this table (like the way we did in the class). You will write.php program that performs following actions: You will create main.php file that contains 5 html forms (one for each query). 5 Marks 1. Add an employee record to existing table. (If an employee with the same email address already exists, it should display appropriate error message. The emp_id should be auto increment integer value) add.php 5 Marks 2. Modify an employee record (Assume that employee changes his/her department. If the new department is same as the employee currently working in, it should display an appropriate message (Should not make any change to the table). modify.php 5 Marks 3. Delete a record from table. The deletion should be done based on first emp_name and emp_dept. If no such employee exists, it should display the appropriate message otherwise it should update the table. delete.php 5 Marks 4. Display the employee table by grouping the employee based on employee department. delete.php 2 Marks 5. Filter the table based on employee department and salary range. For example, you want to see those employees whose salary lie in the range of $6000-$8000 per month and do belong to FAST department filter.php 3 Marks After the execution of each query, it should display the resultant table
