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

7 votes237 views10 answers
Php .com
PHP
10 votes174 views2 answers
Try and catch laravel
PHP
2 votes203 views1 answer
Php reverse shell oneliner
PHP
3 votes169 views2 answers
How to get category from post id
PHP
0 vote180 views1 answer
Image::make en php
PHP
0 vote178 views1 answer
Mysqli fetch row assoc
PHP
0 vote227 views1 answer
Declaration of App\Exports\TarefasExport::headings() must be compatible with Maatwebsite\Excel\Concerns\WithHeadings::headings(): array
PHP
0 vote197 views1 answer
Check if object has method php
PHP
4 votes175 views2 answers
Get html by ajax
PHP
2 votes184 views5 answers
Maximum execution time of 30 seconds exceeded
PHP