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 vote146 views2 answers
DB::raw update query in laravel
PHP
9 votes188 views3 answers
Laravel enum migration example
PHP Laravel
0 vote135 views1 answer
Get count of relationship table laravel
PHP
0 vote153 views2 answers
Foreach limit laravel
PHP Laravel
0 vote148 views2 answers
Implode array keys in php
PHP
0 vote158 views2 answers
Laravel run schedule only on production
PHP Laravel
20 votes158 views5 answers
Php convert string to json
PHP
1 vote144 views2 answers
Add filter in wordpress
PHP
0 vote138 views1 answer
Php read mysql
PHP
0 vote156 views1 answer
Has_post_format wordpress
PHP Wordpress