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

6 votes152 views1 answer
Php contruct parent
PHP
8 votes129 views1 answer
Laravel command to create symlink storage
PHP
1 vote133 views1 answer
How to mantain text in form after error php
PHP
0 vote117 views1 answer
Php array extract value
PHP
1 vote152 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
0 vote145 views1 answer
Laravel make trait command
PHP Laravel
7 votes164 views2 answers
Reset wordpress password in database
PHP Wordpress
0 vote161 views1 answer
Laravel how to address to git repo for develop packages
PHP Laravel
2 votes137 views1 answer
Get user ip laravel
PHP
-1 vote90 views1 answer
Pagination align right side in laravel
PHP