.csv文件进入mysql

Question

The server I'm using does not allow me to use LOAD DATA INFILE or even save a file as a .txt file. I have a .csv file that is just one column, with a name in each row. I want to insert this data into the name column of a table named people with name as one column and location as the other… where the locations will be updated at a later time.

It's a weird way to do this. But I need to do it this way and not using those previous commands.

Does anybody have any ideas? This has been giving me a problem for many hours. I can't figure out how to load the csv into my table column without using those previously mentioned methods that I can't use on my server.

Answer 1

Based on your issue and lack of general permissions you will have to do the following:

Replace the DOS carriage returns with unix new lines:

$contents=preg_replace('/(
||
)/s',"
",$contents); 

Save the contents to the file, and then loop through each line, building an INSERT command that you execute to MySQL.