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 vote256 views2 answers
Php artisan tinker send email
PHP
2 votes257 views2 answers
How to add data to the request object in laravel
PHP
3 votes288 views1 answer
Date time laravel
PHP Laravel
1 vote238 views1 answer
Laravel unique title except id on edit
PHP
1 vote225 views2 answers
Php session destroy not working
PHP
2 votes250 views1 answer
Multiple routes same controller laravel
PHP
0 vote244 views1 answer
How to add in massive php
PHP
1 vote260 views1 answer
How delete the table in laravel in the commend
PHP Laravel
26 votes243 views4 answers
Where is cache file in laravel
PHP
15 votes259 views2 answers
Check homebrew version
PHP