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

2 votes341 views2 answers
Allowed memory size of 1610612736 bytes exhausted 4096
PHP
0 vote368 views1 answer
Laravel price database
PHP Laravel
0 vote343 views1 answer
Php check valid time format
PHP
3 votes423 views1 answer
Laravel eloquent get column
PHP Laravel
6 votes358 views2 answers
Check nulls in php 8
PHP
0 vote276 views1 answer
Array to strng sepreated by comma
PHP
0 vote333 views1 answer
How to pass parameters to relationships laravel
PHP
0 vote411 views1 answer
Laravel return redirect by stuckOverFlow
PHP Laravel
1 vote354 views3 answers
Laravel eloquent to array key value
PHP
2 votes399 views1 answer
Carbon time ago laravel
PHP