Import data from csv to db php

<?php
$query = <<<eof
    LOAD DATA INFILE '$fileName'
     INTO TABLE tableName
     FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
     LINES TERMINATED BY '\n'
     IGNORE 1 LINES
    (field1,field2,field3,etc)
eof;

$db->query($query);
?>

Source: stackoverflow.com

Similar codes

0 vote327 views1 answer
How to pass token with post request laravel
PHP Laravel
0 vote272 views1 answer
Ver version de php en linux
PHP
0 vote321 views2 answers
Passing values to blade using redirect() and back() functions
PHP
0 vote300 views1 answer
Number_format reverse php
PHP
0 vote393 views3 answers
In packagemanifest.php line 131 undefined index name
PHP
1 vote259 views1 answer
Redirect from laravel controller to another link
PHP Laravel
0 vote282 views1 answer
If else if ternary php
PHP
0 vote294 views1 answer
Laravel routes return view in web.php
PHP
16 votes338 views6 answers
Php string to date
PHP
0 vote265 views1 answer
Laravel exclude field
PHP