have csv output as string, have to parse as array in php

Question

I have fetched a csv report which I now have in an string.

eg ->
$report="date,pageview,clicks
2012-07-01,229316,16739
2012-07-02,295238,19582
2012-07-03,278505,17805
2012-07-04,209455,15146
2012-07-05,250756,17206";

Now I want to save this data in mysql database, but not getting any optimized solution because my real $report is very large in size.

How did you fetch the string? What you should ideally do is convert it to an array as you load it with fgetcsv() — DaveRandom
– DaveRandom, Commented Jul 9, 2012 at 8:50

Manse · Accepted Answer · 2012-07-09 08:52:52Z

6

Forget using PHP to import CSV file then sending the data to MySQL- for an optimised solution use LOAD DATA INFILE and load the data straight in, you could use a temporary table if the data isn't exactly what you need

Example :

LOAD DATA INFILE '<yourcsv>' INTO TABLE <yourtable>
FIELDS TERMINATED BY ','
IGNORE 1 LINES;

Caveat - the input file needs to be locally available on the MySQL server

answered Jul 9, 2012 at 8:52

Manse

38.1k11 gold badges88 silver badges112 bronze badges

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

1 Comment

DaveRandom Over a year ago

...assuming that you have access to the local file system of the MySQL server, which is not always the case.

Vinayak Phal · Accepted Answer · 2012-07-09 08:56:11Z

0

Use fgetcsv which read records one by one in an array format. http://php.net/manual/en/function.fgetcsv.php

answered Jul 9, 2012 at 8:56

Vinayak Phal

8,9194 gold badges35 silver badges53 bronze badges

Collectives™ on Stack Overflow

have csv output as string, have to parse as array in php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related