Need a code that imports a CSV file into a MySQL database every time its run.
- Imports the file, and delete it
- File contains
date;shopcounting1;shopcounting2;shopcounting3;shopcounting4 --- (and so on, could variate - expand)
I want the script to take add an sql row with the date, shopname, and the number. In the example above it would look like this:
idfield - date - shopname - counting
Should be an easy project for anyone with knowledge about php and CSV files.