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 vote239 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP Laravel
1 vote326 views1 answer
How to stop laravel server
PHP Laravel
7 votes313 views3 answers
Class 'App\Models\Auth' not found
PHP
0 vote258 views1 answer
Php interview questions for experience
PHP
1 vote221 views1 answer
Get the category wp
PHP
0 vote259 views1 answer
Install php extensions for magento 2
PHP
0 vote245 views1 answer
How to get attribute value in xml using php
PHP
1 vote280 views1 answer
Wordpress acf get checkbox options
PHP Wordpress
0 vote247 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
0 vote270 views1 answer
Laravel blade get array count in Blade
PHP Laravel