Help about importing data from csv to mysql |
[eluser]leonardteo[/eluser]
Never used this function before but you might need quotes around $data. If you see the docs there are single quotes around the filename: http://dev.mysql.com/doc/refman/5.1/en/load-data.html Another way to do this is to read it in using fgetcsv (http://php.net/manual/en/function.fgetcsv.php) then use active record to create each record. Probably less efficient... L. |
Messages In This Thread |
Help about importing data from csv to mysql - by El Forum - 08-11-2011, 09:44 AM
Help about importing data from csv to mysql - by El Forum - 08-11-2011, 10:48 AM
Help about importing data from csv to mysql - by El Forum - 08-11-2011, 11:01 AM
|