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 vote344 views1 answer
Cart laravel
PHP Laravel
0 vote318 views1 answer
Woocommerce subscriptions custom user rolde
PHP
11 votes357 views2 answers
Select distinct laravel
PHP Laravel
0 vote362 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel
0 vote325 views1 answer
Bool value of blank string inp php
PHP
21 votes308 views2 answers
Php index of last element in array
PHP
1 vote327 views1 answer
Laravel @canany
PHP Laravel
4 votes339 views1 answer
413 error laravel
PHP
80 votes432 views6 answers
Php to int
PHP
0 vote308 views1 answer
Php triple quotes
PHP