Import.csv file contents into a mysql database with PHP Use explode on your delimiters and iterate over the contents of the fXiXlXe-- array while building the query yourself. Then execute it (in chunks if you want). The general syntax is this: INSERT INTO table (field1,field2,field3) VALUES (1,2,3), (4,5,6), (7,8,9) I also think that handle is 1000 bytes, and the data looks like more than 1000 bytes. Otherwise I'm not sure, I've never used 'loadfile' because I prefer to validate the data first, so I can't really say if that syntax for the first query is correct. Hints: explode on CRLF (or just LF), and then on comma (CSV heh-). Bernhard Schlink Liebesfluchten Pdf Printer. Eval(BadCode);1137237 wrote: Use explode on your delimiters and iterate over the contents of the fXiXlXe-- array while building the query yourself. Then execute it (in chunks if you want).

I urgently need a script that would read a csv file that i exported from filemaker pro and import it into Mysql using php. I search the web for days and found a few scripts but none of them worked.

Hints: explode on CRLF (or just LF), and then on comma (CSV heh-) hmm. So is Script 2. The way forward? I checked the manual for 'explode' and found: // Example 1 $pizza = 'piece1 piece2 piece3 piece4 piece5 piece6'; $pieces = explode(' ', $pizza); echo $pieces[0]; // piece1 echo $pieces[1]; // piece2 // Example 2 $data = 'foo:*:1023:1000::/home/foo:/bin/sh'; list($user, $pass, $uid, $gid, $gecos, $home, $shell) = explode(':', $data); echo $user; // foo echo $pass; // *?>Trouble is, i can't parse this to fit in with what i want. Could i prod you again. Eval(BadCode);1137289 wrote: Oh right. I looked into LOAD DATA INFILE You're using ' and ' for delimiters.

That is a likely source of your problem. LOAD DATA INFILE is faster. Is that the reason you're using it?[/QUOTE] hi I'm using it primarily for the simplicity of the code. I'd much rather go for Script 1. It's a lot less convoluted and faster as you say.

Ive tried all sorts with this though and my patience is tiring a little.:) In the excel file, values are stored in individual cells. Graphpad Prism 6 Mac here. Hp Laserjet M1522 Mfp Scanner Software For Mac. So, from a MySQL point of view, what exactly is my field delimiter?

I've tried: [code=php] $mysqli->query('LOAD DATA INFILE 'tbl_products.csv' INTO TABLE tbl_products LINES TERMINATED BY '%' FIELDS TERMINATED BY '%' FIELDS ESCAPED BY '%' ( product_id, product_name, product_category, product_description, product_price )', $db) or die('Import Error: '. Mysqli_error($mysqli)); where '%' is any of: ( r n), ( t), (';'), or (,) but still it won't import!! I can import manually through Phpmyadmin, but that's not what i want to achieve. Im getting the following warnings: Import Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY ',' FIELDS ESCAPED BY ' ' ( product_id, pro' at line 4.