CODEWITHSUNDEEP
phpmysqlarrayscsv
user3430837
user3430837

Reputation: 65

.csv file into mysql

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.

Upvotes: 0

Views: 86

Answers (1)

Trent
Trent

Reputation: 3103

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('/(\r\n|\r|\n)/s',"\n",$contents);

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

Upvotes: 1

Related Questions