I need a PHP script to perform the following task:
- scan a server directory for all *.zip files inside
- extract the zips and mysql insert the tab delimited data contained in a text file inside the zips
please see the attached zip file for the example
- after the insert clean up the folder and delete the zips
that's all. you must create a mysql table with the first field called 'id' and the others for the data as in the txt file.