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 — B001ᛦ
– B001ᛦ, Commented Oct 13, 2017 at 14:57
have you even tried using google? stackoverflow.com/questions/1269562/… — Odyssey1111
– Odyssey1111, Commented Oct 13, 2017 at 14:58
@MagnusEriksson See edited code. I added what I tried. Thanks — compcobalt
– compcobalt, Commented Oct 13, 2017 at 15:00

Manav · Accepted Answer · 2017-10-13 15:10:57Z

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, 2017 at 15:10

answered Oct 13, 2017 at 15:01

Manav

1,36710 silver badges17 bronze badges

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

1 Comment

compcobalt Over a year ago

Perfect! Thank you :)

AbraCadaver · Accepted Answer · 2023-09-01 18:50:31Z

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 1, 2023 at 18:50

answered Oct 13, 2017 at 15:14

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Comments

LostCause · Accepted Answer · 2017-10-13 15:12:42Z

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, 2017 at 15:12

LostCause

1511 silver badge11 bronze badges

Comments

Sebastian Sulinski · Accepted Answer · 2017-10-13 14:59:57Z

-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, 2017 at 14:59

Sebastian Sulinski

6,0857 gold badges45 silver badges68 bronze badges

Collectives™ on Stack Overflow

Convert CSV into Array

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related