public
Last active — forked from jaywilliams/csv_to_array.php

Convert a comma separated file into an associated array.

  • Download Gist
csv_to_array.php
PHP
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
<?php
/**
* Convert a comma separated file into an associated array.
* The first row should contain the array keys.
*
* Example:
*
* @param string $filename Path to the CSV file
* @param string $delimiter The separator used in the file
* @return array
* @link http://gist.github.com/385876
* @author Jay Williams <http://myd3.com/>
* @copyright Copyright (c) 2010, Jay Williams
* @license http://www.opensource.org/licenses/mit-license.php MIT License
*/
function csv_to_array($filename='', $delimiter=',')
{
if(!file_exists($filename) || !is_readable($filename))
return FALSE;
$header = NULL;
$data = array();
if (($handle = fopen($filename, 'r')) !== FALSE)
{
while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE)
{
if(!$header)
$header = $row;
else
$data[] = array_combine($header, $row);
}
fclose($handle);
}
return $data;
}
 
/**
* Example
*/
 
print_r(csv_to_array('example.csv'));
 
?>
example.csv
1 2 3
"name", "number"
"Lorem", 11
"ipsum", 22
result.txt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Array
(
[0] => Array
(
[name] => Lorem
[number] => 11
)
 
[1] => Array
(
[name] => ipsum
[number] => 22
)
 
)

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.