Hey all DP'ers!! I have a csv file ( which will be anywhere from 1 to 50 columns ) and I've got the database all setup. I need to, via php - Loop through CSV and count the columns remove first row and load data into database table where columns have data I need another loop through the csv to get the column heads to print out as a table head where the column has data I've tried quite a few techniques that I found through searching and experimenting but can't seem to get this to work properly. I'm out of time and need a solution asap so I'm reaching out to you for help! I have cash in hand and will pay for this function. I don't use paypal anymore so any other payment method - I will setup or if you are US based and have a chase account I'll quickpay the cash right to you upon completion! Thanks!
I have this code for passing various CSVs (usually product feeds) to mysql. First line are actually headlines, so you need them out and then one by one row to process in loop and add specified (or all) fileds into mysql...Drop pm
Everybody trying to strip you off .. funny. However, your solution is simple, as my actual query is: LOAD DATA LOCAL INFILE 'imagesindex.csv' INTO TABLE images FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES (id,Dateline,ImagePath,Imageid) PHP:
Actually it is not so simple, for example you need to take care about duplicated rows, and some other stuffs so you can use just plain import to mysql.