using mysql load data query as a raw laravel query

Either don't use the single quotes around the table name, or use backtick `

$upload = DB::raw("LOAD DATA INFILE '$file' INTO TABLE `$request->table` FIELDS TERMINATED by ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS");

thanks @bryank i just did that before looking at your answer. i thinks there is some progress but now im getting this error .

SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.

:(

I suggest writing a helper function to get around that...something like this:

protected function loadDataFile(string $query)
    {

	if (config(database.default) != 'mysql') return;

        $pdo = DB::connection()->getPdo();
        $pdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, true);
        $statement = $pdo->prepare($query,[\PDO::ATTR_CURSOR=>\PDO::CURSOR_SCROLL]);

        $exec = $statement->execute();
        if (!$exec) return $pdo->errorInfo();

        return $statement;

    }

Then call it ($this assumes method in same class):

$this->loadDataFile("LOAD DATA INFILE '$file' INTO TABLE `$request->table` FIELDS TERMINATED by ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS");

@bryank thanks that worked perfectly. although i used fewer lines which i will show here for anyone else like me .

$file = base_path('public/csv/'.$request->csv);
$pdo = DB::connection()->getPdo();
$sql = "LOAD DATA LOCAL INFILE '$file' INTO TABLE $request->table FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 1 ROWS";
$pdo->exec($sql);
return redirect()->back();

and in config/database.php

'mysql' => [
            'driver' => 'mysql',
            ...
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
                PDO::MYSQL_ATTR_LOCAL_INFILE => true,
            ]) : [],

is there any problem with this way ? other then using $request->table directly in query .

this link was helpful https://laracasts.com/discuss/channels/laravel/load-data-infile

Only problem I can see is always leaving that option enabled instead of setting it when it's actually needed. It's disabled by default for a reason (security).

As far as $request->table, that's fine as long as you let Laravel validate it first.

You could also check:

Schema::hasTable($request->table);

alright thanks i understand now :)