/**
* @param $fileName
* @param string $delimiter
* @return array
*/
static function csvToArray($fileName, $delimiter = ",")
{
$handle = fopen($fileName, "r");
$rows = array();
$header = fgetcsv($handle, null, $delimiter);
while (($data = fgetcsv($handle, null, $delimiter)) !== FALSE) {
$row = array();
foreach ($header as $key => $heading) {
$heading = trim($heading);
$row[$heading] = isset($data[$key]) ? YdEncoding::toUTF8($data[$key]) : '';
}
$rows[] = $row;
}
fclose($handle);
return $rows;
}
/**
* @param $fileName
* @param string $delimiter
* @param int $headerRow
* @return array
*/
static function csvToArray($fileName, $delimiter = ',', $headerRow = 1)
{
$handle = fopen($fileName, 'r');
$rows = array();
while ($headerRow > 1) {
$headerRow--;
fgetcsv($handle, null, $delimiter);
}
$header = $headerRow ? fgetcsv($handle, null, $delimiter) : false;
while (($data = fgetcsv($handle, null, $delimiter)) !== FALSE) {
$row = array();
if ($header) {
foreach ($header as $key => $heading) {
$heading = trim($heading);
$row[$heading] = isset($data[$key]) ? YdEncoding::toUTF8($data[$key]) : '';
}
$rows[] = $row;
} else {
$rows[] = $data;
}
}
fclose($handle);
return $rows;
}
