CSV file to multidimensional array

Question

I want to convert a csv file with data like this in a multidimensional array.

1;name1;date1
2;name2;date2

The name of the file is vervangingen.csv. And I want the array to be like this:

Array (   

 [0] => Array
        (
            [0] => 1
            [1] => name1
            [2] => date1
        )

[1] => Array
    (
        [0] => 2
        [1] => name2
        [2] => date1

    )

)

Currently I have this:

    $csv = array();
    $file = fopen('vervangingen.csv', 'r');

    while (($result = fgetcsv($file)) !== false)
    {
        $csv[] = $result;
    }

    fclose($file);

    echo '<pre>';
    print_r($csv);
    echo '</pre>';

But this makes the array look like this. I know there exists something like explode, but I don't know how exactly I would use it here. Could anyone help me maybe?

Array
(
    [0] => Array
        (
            [0] => 1;name1;date1
        )

    [1] => Array
        (
            [0] => 2;name2;date2
        )

)

Mark Baker · Accepted Answer · 2014-03-22 11:09:12Z

4

You should set correct delimiter:

fgetcsv($file, 0, ';')

as described in the PHP docs

edited Mar 22, 2014 at 11:09

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

answered Mar 22, 2014 at 11:07

ziollek

1,9831 gold badge13 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

CSV file to multidimensional array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related