Convert CSV into Array

Question

I have a csv file that looks like this:

Did,status
"123","Active"
"456","Not-Active"
"789","Active"
....and so on

I would like to be able to convert it into an array that looks like this:

$DidStatus = array("123"=>"Active", "456"=>"Not-Active", "789"=>"Active");

I tried this but it's not what I'm looking for:

$file = file_get_contents("test.csv");
$data = array_map("str_getcsv", preg_split('/\r*\n+|\r+/', $file));
print_r($data);

but the output is not the one I'm looking for:

Array
(
    [0] => Array
        (
            [0] => Did
            [1] => status
        )

    [1] => Array
        (
            [0] => 123
            [1] => Active
        )

    [2] => Array
        (
            [0] => 456
            [1] => Not-Active
        )

    [3] => Array
        (
            [0] => 789
            [1] => Active
        )

    [4] => Array
        (
            [0] => 
        )

)

Possible duplicate of [How to create an array from a CSV file using PHP and the fgetcsv function](https://stackoverflow.com/questions/1269562/how-to-create-an-array-from-a-csv-file-using-php-and-the-fgetcsv-function) — B001ᛦ, Oct 13 '17 at 14:57
Have you looked at http://php.net/manual/en/function.fgetcsv.php — IncredibleHat, Oct 13 '17 at 14:57
have you even tried using google? https://stackoverflow.com/questions/1269562/how-to-create-an-array-from-a-csv-file-using-php-and-the-fgetcsv-function — Odyssey1111, Oct 13 '17 at 14:58
@MagnusEriksson See edited code. I added what I tried. Thanks — compcobalt, Oct 13 '17 at 15:00
You don't have the most efficient logic to read as a csv; but take the next step and use `$data = array_column($data, 1, 0);` — Mark Baker, Oct 13 '17 at 15:00
Using `file()` would be better than `file_get_content()` and that `preg_split()` — Mark Baker, Oct 13 '17 at 15:02

Manav · Accepted Answer · 2017-10-13T15:10:57.710

3

Look into fgetcsv()

<?php

    $handle = fopen("test.csv", "r");
    $result = Array();
    fgetcsv($handle); //Removes the first line of headings in the csv
    while($data = fgetcsv($handle)) {
        $result[$data[0]] = $data[1];
    }
    print_r($result); //the result
?>

edited Oct 13 '17 at 15:10

answered Oct 13 '17 at 15:01

Manav

1,357
10
17

Perfect! Thank you :) – compcobalt Oct 13 '17 at 15:03

AbraCadaver · Answer 2 · 2023-09-01T18:50:31.283

3

There are other ways to do it, but given your current code, just extract an array of the 1 values and index it by the 0 values.

unset($data[0]); //If needed to remove the header row

$data = array_column($data, 1, 0);

You may consider this as an alternate for the first step (not sure if FILE_IGNORE_NEW_LINES is absolutely necessary):

$data = array_map('str_getcsv', file('test.csv', FILE_IGNORE_NEW_LINES));

edited Sep 01 '23 at 18:50

answered Oct 13 '17 at 15:14

AbraCadaver

78,200
7
66
87

score 0 · Answer 3 · answered Oct 13 '17 at 15:12

0

Look into fgetcsv. That is meant to be used for something like this.

$arr = array();
$file = fopen('test.csv', 'r');
while (($result = fgetcsv($file)) !== FALSE)
{
    $arr[] = $result;
}
fclose($file);

answered Oct 13 '17 at 15:12

LostCause

151
1
11

score -2 · Answer 4 · answered Oct 13 '17 at 14:59

-2

You can use this package league/csv and you can find instructions on how to use it here - one of the first examples shows how to convert csv to array

answered Oct 13 '17 at 14:59

Sebastian Sulinski

5,815
7
39
61

Convert CSV into Array

4 Answers4