Laravel CSV to Array

readme.md

Adapted from http://pastebin.com/4FR9ZdHe

CSVSeeder.php

<?php
// ini_set("auto_detect_line_endings", true); // If having issues on iOS
trait CSVSeeder {

	public 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;
	}

}

TableSeeder.php

<?php

class [Model]TableSeeder extends Seeder {
 use CSVSeeder;
	public function run() {

		$csvFile = public_path() . '/[Model]-seeder.csv';
		$data = $this->csv_to_array($csvFile);
		
		DB::table('[Model]')->truncate();
		DB::table('[Model]')->insert($data);
		// or
		//foreach($data as $entry)
		//{		
 		//	[Model]::create($data);
 		//}
	}

}