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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.