webent Posted August 25, 2008 Share Posted August 25, 2008 Can someone please explain to me how fgetcsv separates columns of data in a csv file, because some of the rows have commas in the column and they get put in the mysql db just fine... The reason I'm asking is because I'm considering switching all of my INSERT statements to LOAD DATA INFILE statements because of it taking several hours to load a single csv file... Well, apparently when using LOAD DATA INFILE, you have to specify FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' ....... I'm just not sure what to put, because if I use comma, then certain rows that have commas in the data will be screwed up... Can someone please help me through this dilemma? Currently using... $handle = fopen($_POST['file_name'], "r"); while (($fields = fgetcsv($handle, 0, ",")) !== FALSE) { Quote Link to comment 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.