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

5 votes220 views1 answer
Laravel get random row
PHP Laravel
6 votes152 views6 answers
Laravel collection pluck
PHP
0 vote186 views1 answer
Laravel imap - Get message attachments
PHP Laravel
0 vote169 views2 answers
Comment split une chaine de caratere en php
PHP
2 votes202 views1 answer
Path of app directory in controller laravel
PHP Laravel
6 votes251 views2 answers
How to add extra days from a date php
PHP
3 votes168 views2 answers
Function exists
PHP
0 vote207 views1 answer
Codeigniter crud generator
PHP
0 vote196 views1 answer
Laravel get image extension
PHP Laravel
4 votes319 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter