/** * @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; }