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

8 votes192 views6 answers
Laravel composer
PHP
0 vote196 views1 answer
Simple_form_for id
PHP
0 vote226 views1 answer
Current URL without url site laravel
PHP Laravel
1 vote210 views1 answer
Boot method laravel life cycle
PHP
0 vote203 views1 answer
Laravel factory counter
PHP Laravel
15 votes192 views6 answers
Blade if
PHP
14 votes223 views6 answers
Get the Last Character of a String in PHP
PHP
1 vote178 views2 answers
Install php 5.6 mac
PHP
9 votes212 views4 answers
Composer laravel ui
PHP Laravel
0 vote237 views2 answers
Search string inside array of objects php
PHP