Parsing a CSV file into a two dimensional array

Question

my goal of this is to put the first index (first value of each line in the csv) into a dropdown html select list.

test.csv

mark, blue, tall,
mike, black, short

index.php

<?php
$handle = fopen("csv/food.csv", "r");

while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
    echo "<pre>";
    print_r($data);
    echo "<pre>";
}
?>

output

Array
(
    [0] => mark
    [1] => blue
    [2] => tall
    [3] => mike
    [4] => black
    [5] => short
)

output if I remove comma after tall

Array
(
    [0] => mark
    [1] => blue
    [2] => tall
mike
    [3] => black
    [4] => short
)

desired output

Array
(
    [0][0] => mark
    [0][1] => blue
    [0][2] => tall
    [1][0] => mike
    [1][1] => black
    [1][2] => short
)

thats mean there is no actual new lines in your csv file. try to remove comma after "Tall," in the first line. — Mohammad Ahmad, Jan 02 '13 at 12:34
I tried that, but then it just puts `tall mike` into `[2]`. I'll update OP with output from what you suggested. — eveo, Jan 02 '13 at 12:35
possible duplicate of [how to extract data from csv file in php](http://stackoverflow.com/questions/2805427/how-to-extract-data-from-csv-file-in-php) — Gordon, Jan 02 '13 at 12:37

score 2 · Accepted Answer · edited Feb 05 '14 at 13:41

2

Got it working:

<select name="list" > 
<?php 
$file = fopen("food.csv", "r"); 

while (!feof($file) ) { 
    $lines = fgetcsv($file, 1024);?> 
    <option value="<?php print $lines[0] ?>"> <?php print $lines[0] ?> </option> 
<?php } ?>
</select>
<?php 
fclose($file); 
?>

edited Feb 05 '14 at 13:41

lordvlad

5,200
1
24
44

answered Jan 02 '13 at 12:55

eveo

2,797
15
61
95

Parsing a CSV file into a two dimensional array

1 Answers1