Automatically Upload Excel Raw Data with PHP and SQL

[zephyrgard]

I'm not really sure if i'm posting this on the correct board.

 

Is there a way that I can have the data from an EXCEL(.csv) file be uploaded to the MYSQL database automatically and not doing it manually

(Clicking on an upload button). I want to have an excel file saved on my local folder to be the DUMP file and then have a code run automatically (Intervals of an hour or so...) to upload the updated file..

 

Hope for your response,

Thanks 

[aabid]

You have posted this in wrong section i guess. BTW,

Yes you can use fgetcsv() function to read the data of a csv and then store it in database with sql commands.

for more about fgetcsv() check out this here http://php.net/manual/en/function.fgetcsv.php