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
– Mohammad Ahmad, Commented Jan 2, 2013 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
– eveo, Commented Jan 2, 2013 at 12:35
possible duplicate of how to extract data from csv file in php — Gordon
– Gordon, Commented Jan 2, 2013 at 12:37

lordvlad · Accepted Answer · 2014-02-05 13:41:55Z

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 5, 2014 at 13:41

lordvlad

5,3872 gold badges28 silver badges44 bronze badges

answered Jan 2, 2013 at 12:55

eveo

2,86315 gold badges65 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

Parsing a CSV file into a two dimensional array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related