Upload CSV file to MySQL using Laravel

Question

I'm trying to upload a csv file to the table users in Laravel.

This is my php script:

private function _import_csv($path, $filename)
    {

        $csv = $path . $filename;
        $query = sprintf("LOAD DATA local INFILE '%s' INTO TABLE users FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\"' LINES TERMINATED BY '\\n' IGNORE 0 LINES (`firstname`, `lastname`, `username`, `gender`, `email`, `country`, `ethnicity`, `education`  )", addslashes($csv));
    return DB::connection()->getpdo()->exec($query);

}



public function uploadUsers(){


    if (Input::hasFile('fileInput')){

        $file = Input::file('fileInput');
        $name = time() . '-' . $file->getClientOriginalName();

        $path = 'public/uploads/'.date('Y/m/');

        $file->move($path, $name);
        $this->_import_csv($path, $name);

    }

    return Response::json(["success"=>true]);
}

But I'm getting this error:

{"error":{"type":"ErrorException","message":"PDO::exec(): LOAD DATA LOCAL INFILE forbidden","file":"C:\\wamp\\www\\lc2\\laravel\\app\\controllers\\UsersController.php","line":224}}

I don't know whats wrong. Can anybody please help me?

Jay Dhameliya · Accepted Answer · 2015-03-01 09:03:20Z

25

Please try it

Set PDO Connection options

Set attribute PDO::MYSQL_ATTR_LOCAL_INFILE in database.php

'mysql' => array(
            ....
            'options'    => [PDO::MYSQL_ATTR_LOCAL_INFILE=>true],
        ),

answered Mar 1, 2015 at 9:03

Jay Dhameliya

1,70912 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Usama Noman · Accepted Answer · 2015-02-28 05:03:22Z

-3

Try to clean the query string before the sprintf function.

answered Feb 28, 2015 at 5:03

Usama Noman

5031 gold badge4 silver badges11 bronze badges

Collectives™ on Stack Overflow

Upload CSV file to MySQL using Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related