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 vote114 views2 answers
See all the post in one catagory with out pagination
PHP
0 vote161 views1 answer
Laravel toastr option
PHP
0 vote116 views1 answer
Php remove all but numbers
PHP
0 vote108 views1 answer
How we show full name of month in posts
PHP
0 vote132 views1 answer
Php mess detector laravel
PHP
1 vote109 views1 answer
How handle the number with k in laravel balde
PHP
0 vote112 views1 answer
Unable to do sum and getting same value by using while loop php
PHP
0 vote97 views1 answer
Single row in codeigniter
PHP CodeIgniter
3 votes154 views3 answers
How to execute a php script from the command line?
PHP
3 votes111 views6 answers
Convertir datetime a string en php
PHP