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 vote190 views1 answer
Push key and value in laravel
PHP
0 vote229 views1 answer
Taxonomy_get_children drupal 8
PHP Drupal
17 votes169 views6 answers
Laravel Routing
PHP Laravel
0 vote163 views1 answer
Wordpress get page number
PHP
1 vote200 views1 answer
Laravel set field unique
PHP Laravel
0 vote167 views1 answer
Example of valid php variables
PHP
1 vote213 views1 answer
Php mysql prepare query
PHP
21 votes167 views3 answers
Php delete array item by value
PHP
1 vote186 views2 answers
Redrectnh to https n laravel
PHP Laravel
0 vote157 views1 answer
Advantages of php
PHP