I've been working on a payroll management system and this assignment I need help doing the following listed below. What I have done is attached. Thank you

Make the following additions to the e-commerce system you have been developing for your project. The updated e-commerce system should allow your target audience do the followings:

The users should be able to modify records. After the modifications are done, the users should be able to see the changed records on the Web Browser.

The users should be able to delete record(s), which should be accomplished by deleting all related records which may exist in multiple tables

Use the transactions when deleting records from multiple tables, and if at least one of the queries within the same transaction is unsuccessful for some reason, do not execute any of the queries within the same transaction, and if all of the queries in the same transaction are successful, the execute them all

When the records are being shown to the users, sort them using a column or combinatons of more than one column

addEmployee.php x employeeld.php lastinsertedld.php x validateData.php 1 k?php 2 $con mysqu connect ("localhost password"); UserName' 3 if (!$con) die ('Could not connect: mysql error()); 7 mysq select db("databaseName", $con); 9 if (empty POSTI first name])) H 10 echo "Please enter first Name!'; 11 13 if (isset POST[lastnamel)) H echo "Please enter Last Name! 14 15 16 17 $squ INSERT INTO BMPLOYEE(FIRST NAME, LAST NAME, GENDER) VALUES(' POSTlfirstnamel', 's POST [last name] POSTlgender] 18 19 if (!mysqu query ($sql,$con)) 20 ('Error: mysqu error()): die 21 22 23 echo "1 record added": 24 25 mysqu close ($con); 26 27