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

3 votes243 views1 answer
Php sprintf
PHP
5 votes385 views2 answers
Php select option
PHP
0 vote229 views1 answer
Http error code php
PHP
2 votes240 views1 answer
Migration bool type eloquent orm
PHP
51 votes328 views6 answers
Laravel run all seeders
PHP Laravel
4 votes282 views5 answers
Wordpress logout link
PHP Wordpress
0 vote275 views1 answer
Update laravel .env variables dynamically
PHP Laravel
2 votes248 views2 answers
Sum two numbers in php
PHP
0 vote266 views2 answers
Display category name wordpress
PHP Wordpress
7 votes224 views2 answers
How to start composer in laravel project on localhost
PHP