Skip to content

Instantly share code, notes, and snippets.

@KarelWintersky
Forked from jaywilliams/csv_to_array.php
Created October 11, 2015 21:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save KarelWintersky/1a2cb0bbfd0a1fe244f7 to your computer and use it in GitHub Desktop.
Save KarelWintersky/1a2cb0bbfd0a1fe244f7 to your computer and use it in GitHub Desktop.
Convert a comma separated file into an associated array.
/**
* Convert a comma separated file into an associated array.
* The first row must contain the array keys.
* Return something like this:
* Array
(
[0] => Array
(
[name] => Lorem
[number] => 11
)
[1] => Array
(
[name] => ipsum
[number] => 22
)
)
*
*
* @param string $filename Path to the CSV file
* @param string $delimiter The separator used in the file (default `,`)
* @param string $enclosure The enclosure used in the file (default `"`)
* @return array|bool
*
* @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=',', $enclosure = '"') {
ini_set('auto_detect_line_endings',TRUE);
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, $enclosure)) !== FALSE)
{
if (!$header) {
$header = $row;
}
else {
if (count($header) > count($row)) {
$difference = count($header) - count($row);
for ($i = 1; $i <= $difference; $i++) {
$row[count($row) + 1] = $delimiter;
}
}
$data[] = array_combine($header, $row);
}
}
fclose($handle);
}
return $data;
}
name number
Lorem 11
ipsum 22
Array
(
[0] => Array
(
[name] => Lorem
[number] => 11
)
[1] => Array
(
[name] => ipsum
[number] => 22
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment