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 vote195 views1 answer
Laravel profile migration tool
PHP Laravel
0 vote157 views2 answers
Display category name wordpress
PHP Wordpress
12 votes282 views3 answers
Wordpress embed shortcode in php
PHP Wordpress
4 votes163 views2 answers
Laravel carbon get month name español
PHP Laravel
1 vote145 views3 answers
Create services in laravel with command line
PHP
2 votes153 views2 answers
Get users other than specific role laravel role spatie
PHP
0 vote164 views1 answer
Laravel use variable inside callback function
PHP
22 votes135 views9 answers
Php convert string to date
PHP
2 votes205 views4 answers
Laravel run schedule locally
PHP Laravel
0 vote133 views1 answer
How to check if a user is logged in in a non middleware controller in laravel
PHP