/** * Run the database seeds. * * @return void */ public function run() { 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; } $csvFile = public_path() . '/csvs/categories.csv'; $datas = csv_to_array($csvFile); DB::table('categories')->delete(); foreach ($datas as $data) { Categories::create($data); } }