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

10 votes162 views3 answers
For loop in laravel
PHP
3 votes142 views6 answers
Laravel find query
PHP
3 votes165 views3 answers
Php keep only numbers in string
PHP
3 votes157 views2 answers
Array_sum in multidimensional array php
PHP
0 vote157 views1 answer
Php remove anchor tag from string
PHP
0 vote153 views1 answer
Regex phpstorm
PHP
0 vote161 views2 answers
PHP CRUD Generator
PHP
0 vote187 views2 answers
How to back the page laravel where the scorll is
PHP Laravel
3 votes140 views1 answer
Debug graphql wordpress
PHP
2 votes215 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP Laravel