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 vote151 views1 answer
Codeigniter select where
PHP
0 vote169 views1 answer
Php remove slash from string
PHP
6 votes145 views2 answers
WhereHas site:https://laravel.com/docs/
PHP
0 vote192 views1 answer
Laravel role
PHP Laravel
0 vote158 views1 answer
How to declar a variable in php
PHP
0 vote198 views1 answer
Laravel collection max
PHP Laravel
20 votes158 views4 answers
Strupper php
PHP
0 vote166 views10 answers
Laravel relations find
PHP
28 votes187 views3 answers
Seed date laravel
PHP
13 votes170 views6 answers
Laravel array validation
PHP