Welcome Guest, Not a member yet? Register   Sign In
Help about importing data from csv to mysql
#2

[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



Theme © iAndrew 2016 - Forum software by © MyBB