Create admin screen pages (two) to upload data to two tables, client table and employee table.
The client screen is basically a short form that is fill in and a logo image that is uploaded.
The employee admin page uploads an excel spreadsheet (you create the excel spreadsheet that they download and fill in). The completed excel spreadsheet is uploaded and the data is validated for security (sql injection etc) and for standard validation e.g. emails. The data is also checked to make sure employee id numbers are not duplicated for different people etc - more details are in attached document.
Your admin screen will present
* a 'Datatable' listing new employees
* a 'Datatable' listing updated employees
* a 'Datatable' listing employees who are not changes
* a 'Datatable' listing employees who will be deleted because they are in the mysql table but not in the excel spreadsheet...
Only after the user clicks confirm are the tables updated....
See [login to view URL] for the simple look and feel that must be replicated in the admin pages
See other images for more information
Technology used must be codeigniter 3