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

1 vote163 views1 answer
Php single quote vs double quote
PHP
1 vote206 views1 answer
Select sum in laravel
PHP
0 vote160 views1 answer
Laravel collection pipe
PHP
1 vote189 views1 answer
Get random posts wordpress
PHP Wordpress
0 vote228 views1 answer
Converting php to codeigniter
PHP CodeIgniter
0 vote198 views1 answer
Where to add browscap php
PHP
0 vote127 views1 answer
Non utf-8 characters in php
PHP
0 vote182 views1 answer
Laravel datatable columnDefs
PHP Laravel
1 vote170 views3 answers
PHPMailer
PHP
20 votes170 views4 answers
Change php version in ubuntu
PHP