Import CSV files into dB, Laravel 5.7

http://php.net/manual/en/function.str-getcsv.php

Handy one liner to parse a CSV file into an array

<?php

$csv = array_map('str_getcsv', file('data.csv'));

?>

There are plenty of examples of how to import csv files. From what you describe, I would recommend using the Laravel-Excel package - you'll be up and running in minutes.

https://github.com/Maatwebsite/Laravel-Excel

Laravel provides Storage option, could be public or private location. I assume that, file you need to import is private, you can follow the steps.

Step1: From controller get file uploaded via front end & store in private folder named 'upload_private'

    $fileOriginalName = $request->file->getClientOriginalName();
        $filename = $request->file->storeAs('upload_private', $originalName);

Now file is stored, you can parse it

        $rows= explode(PHP_EOL, Storage::get($filename));
       foreach ($rows as $row)
        {
            $record = str_getcsv($row);
        // and do your processing here...

    }

$file = $request->file('file');

     if (($handle = fopen ( $file->getPathname(), 'r' )) !== FALSE) {

    while ( ($data = fgetcsv ( $handle,1000, delimiter/separator )) !== FALSE ) {

     
        
       //Do something with data here

    }
    fclose ( $handle );
}

Thank you all for your replies!

@talinon thanks for your tip! I managed to make it work using Laravel-Excel but I had to install some of the required libraries first.

So finally the csv file is imported like so:

The table schema

 Schema::create('speed_tests', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('server_id');
            $table->text('sponsor');
            $table->text('server_name');
            $table->text('timestamp');
            $table->decimal('distance');
            $table->integer('ping');
            $table->bigInteger('download');
            $table->bigInteger('upload');
            $table->text('share')->nullable();
            $table->ipAddress('ip_address');
            $table->timestamps();

The Laravel-Excel import class

<?php

namespace App\Imports;
use App\SpeedTest;
use Maatwebsite\Excel\Imports\HeadingRowFormatter;
use Maatwebsite\Excel\Concerns\ToModel;

class SpeedTestsImport implements ToModel
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new SpeedTest([
            'server_id'     => $row[0],
            'sponsor'       => $row[1], 
            'server_name'   => $row[2],
            'timestamp'     => $row[3],
            'distance'      => $row[4], 
            'ping'          => $row[5],
            'download'      => $row[6],
            'upload'        => $row[7],
            'share'         => $row[8],
            'ip_address'    => $row[9]
        ]);
    }
}

Inside the controller:

    public function import() 
    {
        Excel::import(new SpeedTestsImport, 'test.csv');

        return redirect('/')->with('success', 'All good!');
    }

And tested in my routes file

Route::get('/import', 'SpeedTestController@import');

How i would solve this, loading a CSV directly into the database, works like a charm

$query = sprintf("LOAD DATA INFILE '%s'
        IGNORE INTO TABLE {$this->table_name()}
        CHARACTER SET utf8
        FIELDS TERMINATED BY '{$this->terminated_by()}'
        ENCLOSED BY '\"'
        ESCAPED BY ''
        LINES TERMINATED BY '\n'
        IGNORE 1 ROWS", addslashes($this->importfile_path));
        \DB::connection()->getpdo()->exec($query);