I need a php script that will get a 1.9MB file from an outside url. The XML feed contains approximately 1,200 items. We need you to convert the data and populate a MySQl table with all data.
This script will be run daily in CRON so no user intervention is needed. 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.