travelkind Posted October 30, 2009 Share Posted October 30, 2009 I have read about the php "file" upload where you can upload a file to a location on your server. What I am trying to accomplish is to have the capability of uploading a csv (or excel if it makes it easier) from a web browser straight to a mysql database table. I use phpmyadmin and realize you can upload this way but I would like to set up a php script that will do this in a web browser. I read a little bit about the "fgetcsv" and "fopen". Is this what I shoud be looking at or what? Can someone give me some direction on this? Again, thanks for your help. Link to comment https://forums.phpfreaks.com/topic/179655-upload-csv-file-directly-to-sql-table-through-php-script/ Share on other sites More sharing options...
Mchl Posted October 30, 2009 Share Posted October 30, 2009 The fastest way to load CSV file into a table is to use LOAD DATA INFILE query. Upload a file using PHP script and then run the query. Link to comment https://forums.phpfreaks.com/topic/179655-upload-csv-file-directly-to-sql-table-through-php-script/#findComment-948041 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.