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

4 votes325 views2 answers
Codeigniter 3 limit
PHP
0 vote334 views1 answer
Wordpress single post template managwr
PHP Wordpress
0 vote268 views1 answer
Builder Pattern Method Chaining 2
PHP
0 vote269 views1 answer
Get word between two characters php
PHP
0 vote240 views1 answer
Twig superglobal request
PHP
0 vote279 views1 answer
Remove nul value aray php
PHP
1 vote326 views3 answers
Get page title wordpress
PHP Wordpress
7 votes291 views2 answers
Laravel collection isEmpty
PHP
0 vote265 views1 answer
Php curl delete request
PHP
0 vote308 views1 answer
Laravel collection pipe
PHP Laravel