PHP - Upload, multiple XLS or XLSX files and insert them into the database (single table)
Budget: $10 – $75 USD
Need a PHP script that will
1. Upload multiple XLSX or XLS files (has approx. 50 columns), that I will provide
2. Should insert in a MySQL table (has approx. 50 columns), which I will provide
3. Should show a progress bar of how many records are inserted or in progress
4. Should revert the insert if there are errors
5. Should exception handling in error.log file also send an email if there are issues
6. the inserts should be very fast and the code needs to be commented well.
7. Use PDO for Mysql connections
8. The code should work on our Bluehost shared server.
Please start with the word READ at the beginning of the proposal.
1. Upload multiple XLSX or XLS files (has approx. 50 columns), that I will provide
2. Should insert in a MySQL table (has approx. 50 columns), which I will provide
3. Should show a progress bar of how many records are inserted or in progress
4. Should revert the insert if there are errors
5. Should exception handling in error.log file also send an email if there are issues
6. the inserts should be very fast and the code needs to be commented well.
7. Use PDO for Mysql connections
8. The code should work on our Bluehost shared server.
Please start with the word READ at the beginning of the proposal.