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 vote76 views2 answers
Typeahead bootstrap 4 add multiple values
PHP
2 votes113 views1 answer
Laravel generate env
PHP
49 votes115 views6 answers
Add new column in laravel migration
PHP
2 votes130 views3 answers
Twig first letter uppercase
PHP
0 vote112 views1 answer
I can't chage post_max_size
PHP
15 votes90 views3 answers
Php strtoupper
PHP
0 vote185 views1 answer
WordPress Convert Object To Array
PHP Wordpress
0 vote127 views1 answer
Rule for radio button in laravel
PHP
1 vote135 views2 answers
Php showing code in browser
PHP
2 votes127 views3 answers
Laravel get input from request
PHP