I need a php script that will get a 3.5MB .ZIP file from an outside url at [login to view URL] containing a 10 MB XML feed with approximately 10,000 items, unzip the file contents (1 .xml file and 1 .dtd file) and convert the data to and populate a MySQl table with all data.
This script will be run daily in CRON so no user intervention is allowed. It has to be fully automatic.
Please make sure to have error-checking in the script, so if something goes wrong, the database is not emptied, but an e-mail is sent warning something went wrong.
The database will be repopulated entirely each time the script is run.
Find the clickbank xml feed zip file at [login to view URL]