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 vote334 views1 answer
Laravel creating event get data
PHP Laravel
0 vote251 views1 answer
Laravel eloquent pass to next element
PHP
0 vote266 views1 answer
Woocommerce_continue_shopping_redirect
PHP
0 vote247 views1 answer
Small echo php
PHP
7 votes257 views5 answers
Laravel foreach loop index
PHP
0 vote300 views1 answer
Php array access by key
PHP
0 vote249 views1 answer
Remove invalid characters from a string laravel
PHP
0 vote246 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP
0 vote253 views1 answer
Sanitize file name
PHP
0 vote282 views1 answer
Javascript inside php
PHP