zephyrgard Posted March 18, 2011 Share Posted March 18, 2011 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 Link to comment https://forums.phpfreaks.com/topic/231042-automatically-upload-excel-raw-data-with-php-and-sql/ Share on other sites More sharing options...
aabid Posted March 19, 2011 Share Posted March 19, 2011 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 Link to comment https://forums.phpfreaks.com/topic/231042-automatically-upload-excel-raw-data-with-php-and-sql/#findComment-1189407 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.