Add each line of CSV file into an array using PHP

Question

I am almost embarrassed to ask this, but I've been trying to accomplish this task for a few hours now. Without a thorough grasp of the fopen or fgetcsv functions, I'm a bit lost. Each example I find does not quite work for me.

I'm seeking a way to load each line of a CSV file into one array. For example, if this is my CSV file:

Apple,Banana,Orange
Kiwi,Watermelon,Pineapple
Dog,Cat,Bird

Then this would be my array:

Array
(
    [0] => Apple,Banana,Orange
    [1] => Kiwi,Watermelon,Pineapple
    [2] => Dog,Cat,Bird
)

I'd appreciate any tips. Thanks! :)

Just for reference, this is what I have so far:

$list = '../reports/apples.csv';

$csvfile = fopen($list,'rb');
while(!feof($csvfile)) {
$listofthings[] = fgetcsv($csvfile);
}
fclose($csvfile);

print_r($listofthings);

However, this is producing a multidimensional array as follows, when I'd rather just have one big array.

Array
(
    [0] => Array
        (
            [0] => Apple
            [1] => Banana
            [2] => Orange
        )

    [1] => Array
        (
            [0] => Kiwi
            [1] => Watermelon
            [2] => Pineapple
        )

    [2] => Array
        (
            [0] => Dog
            [1] => Cat
            [2] => Bird
        )
)

Nick Pickering · Accepted Answer · 2013-02-23 04:35:19Z

2

If you want to break the file up by lines, use file.

$newArray = file('/path/to/file.csv');

If you want each comma-delimited value as an element of the array, use file_get_contents and explode by a comma.

$contents = file_get_contents('/path/to/file.csv');
$newArray = explode(',', $contents);

edited Feb 23, 2013 at 4:35

answered Feb 23, 2013 at 4:29

Nick Pickering

3,2053 gold badges32 silver badges50 bronze badges

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

1 Comment

user1881190 Over a year ago

I noticed the same thing when you first answered and Googled the solution. "\n" worked. Then I came and saw you answered with the same thing! Hah. Marking as solution - this worked for me, and I knew it was going to be something extremely simple. Thanks!

prodigitalson · Accepted Answer · 2013-02-23 04:36:41Z

1

You could explode after reading the file as Nicholas suggests or you could hit it all at once with file:

$lines = file('/path/to/file.csv');

answered Feb 23, 2013 at 4:36

prodigitalson

60.6k10 gold badges106 silver badges118 bronze badges

2 Comments

Nick Pickering Over a year ago

Wish, I could vote up again - I think you've changed my life.

prodigitalson Over a year ago

Hahaha... yeah, the other nice thing is it takes the detect line endings setting into account, so you dont have to worry as much about differing line endings.

Dino Babu · Accepted Answer · 2013-02-23 04:38:39Z

0

are looking for this ??

$mytext = "Apple,Banana,Orange
Kiwi,Watermelon,Pineapple
Dog,Cat,Bird";

$line_explode = explode("\n", $mytext);
$comma_explode = array();
foreach ($line_explode as $line) {
  $comma_explode[] = explode(",", $line);
}

print_r($comma_explode);

Output

Array
(
    [0] => Array
        (
            [0] => Apple
            [1] => Banana
            [2] => Orange
        )

    [1] => Array
        (
            [0] => Kiwi
            [1] => Watermelon
            [2] => Pineapple
        )

    [2] => Array
        (
            [0] => Dog
            [1] => Cat
            [2] => Bird
        )

)

answered Feb 23, 2013 at 4:38

Dino Babu

5,8093 gold badges26 silver badges33 bronze badges

Collectives™ on Stack Overflow

Add each line of CSV file into an array using PHP

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related