putting csv column into an array

Question

I've got a csv with column headers: description, stock, mfgid (and some other headers I don't need).

I need to get the data from the column headers stock and mfgid in an array.

I was using fgetcsv() but it was putting the entire row into an exclusive key in the array.

found this here at stackoverflow but can't get it to work right:

$file = fopen('inventory.csv', 'r');
while (($line = fgetcsv($file)) !== FALSE) {
  //$line is an array of the csv elements
  print_r($line);
}
fclose($file);

what is the exact problem? what is shown? what's not working? — mauris
– mauris, Commented May 3, 2011 at 14:13

mario · Accepted Answer · 2011-05-03 14:20:24Z

2

For reading in a complete CSV file use this construct:

$csv = array_map("str_getcsv", file("inventory.csv"));
$header = array_shift($csv);

This separates the $header into a separate array from the rest of the $csv data.

If you then (seemingly?) want a map of two fields, try:

$col1 = array_search("stock" $headers);
$col2 = array_search("mfgid", $headers);
foreach ($csv as $row) {
     $map[ $row[$col1] ] = $row[$col2]; }

This would give you a stock -> mfgid array.

answered May 3, 2011 at 14:20

mario

146k20 gold badges243 silver badges293 bronze badges

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

2 Comments

Joe Over a year ago

Well it may work for others, but my server is not using php 5.3 so I think that limits me to not being able to use "str_getcsv"

mario Over a year ago

Ah okay. You can try one of the emulations on php.net/manual/en/function.str-getcsv.php#98088 or use upgradephp.berlios.de to get this PHP5.3 function. But you could use your old loop method and just apply the second code block for separating the columns

Collectives™ on Stack Overflow

putting csv column into an array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related