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 votes318 views6 answers
Laravel Pagination
PHP Laravel
26 votes314 views6 answers
Laravel validation integer
PHP
4 votes300 views3 answers
Laravel cmd command to watch logs
PHP
6 votes312 views5 answers
Phpinfo file
PHP
2 votes294 views3 answers
Get current date from year input php
PHP
92 votes379 views6 answers
Php replace
PHP
0 vote287 views1 answer
Twig get array key name
PHP
0 vote304 views1 answer
How to read laravel query string with dash
PHP
49 votes359 views6 answers
Laravel when
PHP Laravel
7 votes333 views2 answers
How to start composer in laravel project on localhost
PHP Laravel