How to Practically Split Values from CSV File into MySQL Database

Question

Let's suppose I have the following line in a CSV file (I removed the header row in this example):

"500,000",2,50,2,90000

I have a PHP script read the CSV file, break the file into individual lines, and store each line in an array called $linearray. Then, I use a foreach loop to look at each line individually.

Within the foreach loop, I break the line into separate variables using the following function:

$line = str_replace("'","\'",$line);

From here, I insert the values into separate columns within a MySQL database. The script works. The values are inserted into a database, but I run into a problem. I want:

"500,000"  |  2  |  50  |  2  |  90000

But I get this:

"500  |  000"  |  2  |  50  |  2  |  90000

The script isn't smart enough to understand it should skip commas within quotation marks. Do you know how I can alter my script to make sure I get the output I'm looking for?

Ilmari Karonen · Accepted Answer · 2012-12-24 23:51:10Z

2

You can use the str_getcsv function

print_r(str_getcsv($line));

Outputs:

Array
(
    [0] => 500,000
    [1] => 2
    [2] => 50
    [3] => 2
    [4] => 90000
)

Similar to fgetcsv() this functions parses a string as its input unlike fgetcsv() which takes a file as its input.

edited Dec 24, 2012 at 23:51

Ilmari Karonen

50.5k9 gold badges96 silver badges156 bronze badges

answered Jun 17, 2010 at 4:43

Russell Dias

73.9k5 gold badges58 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Emil Vikström Over a year ago

Note that str_getcsv only works in PHP 5.3 and above. For earlier versions, "save" the string to the php://memory special file and use fgetcsv to parse it. Not that str_getcsv is really relevant to this question since the OP specifically have a file, so reading it one line at a time probably makes sense.

Russell Dias Over a year ago

@Emil Yeah, I was just showing him an example using the $line variable he already had. At the bottom I stated what he should do for a csv file.

Emil Vikström · Accepted Answer · 2010-06-17 04:41:16Z

1

Try fgetcsv.

answered Jun 17, 2010 at 4:41

Emil Vikström

92.3k17 gold badges144 silver badges178 bronze badges

Collectives™ on Stack Overflow

How to Practically Split Values from CSV File into MySQL Database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related