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

61 votes538 views6 answers
Cache clear in laravel
PHP Laravel
28 votes169 views12 answers
Laravel middleware
PHP Laravel
0 vote175 views2 answers
Notice: Trying to get property 'NAME' of non-object in
PHP
5 votes209 views6 answers
Sync laravel
PHP Laravel
1 vote199 views2 answers
Fillable vs guarded laravel
PHP Laravel
0 vote207 views2 answers
How to back the page laravel where the scorll is
PHP Laravel
0 vote176 views2 answers
Uninstall php 8.0 ubuntu
PHP
8 votes170 views5 answers
Redirect in codeigniter
PHP
1 vote168 views1 answer
Php get current datetime mysql format
PHP
0 vote204 views1 answer
What is forelse in laravel
PHP