CSV as Associative Array

Question

I have a CSV file I would like to use as an array in a script.

The CSV is simple:

key1,val1
key2,val2
...

I want to be able to reference the array created like this:

$value = my_csv['key'];

I currently cannot do that because my script shows the index as undefined.

$myArray = array();
$file = fopen('myCSV.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE) {
  array_push($myArray, array($line[0] => $line[1]));
}
fclose($file);
var_dump($myArray['key']);
exit;

I believe this is because I would need to use the numerical index first but I would ideally be able to reference the array in the way I am above.

RiggsFolly · Accepted Answer · 2020-03-02 18:08:39Z

1

The array needs to be created with the key set then, like this

$myArray = array();
$file = fopen('myCSV.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE) {
  $myArray[$line[0]] = $line[1];
}
fclose($file);
var_dump($myArray['key']);

This does assume that there are no duplicates in the key

edited Mar 2, 2020 at 18:08

answered Mar 2, 2020 at 18:03

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

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

Collectives™ on Stack Overflow

CSV as Associative Array

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related