/** * Convert CSV to database table. * * @param string $table * @param boolean $table_already_exists * @param boolean $clear_existing_records * @return void */ public function to_database($table = null, $table_already_exists = false, $clear_existing_records = false) { // if no pre-existing table defined... if (!$table_already_exists) { $t = new \Table($table); $t->create(); foreach ($this->columns as $column) { // create column; default length is 200 $t->string($column); } \Schema::execute($t); } else { // if clear existing records... \DB::query(sprintf("TRUNCATE TABLE `%s`", $table)); } // foreach row... foreach ($this->rows as $value) { // add to table \DB::table($table)->insert($value); } }