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

1 vote147 views1 answer
Php file get content replacing & with &
PHP
1 vote127 views1 answer
How to save data from api to laravel
PHP
0 vote130 views1 answer
Php-array-delete-by-value-not-key
PHP
0 vote141 views1 answer
Php fix array index
PHP
5 votes130 views4 answers
Php get time in milliseconds
PHP
4 votes148 views1 answer
Remove index.php
PHP
0 vote147 views1 answer
Codeception send text in ckeditor
PHP
0 vote158 views1 answer
Laravel add model to polymorphic relationships
PHP Laravel
0 vote135 views1 answer
Cron job every 5 minutes wordpress
PHP Wordpress
22 votes145 views6 answers
Php foreach
PHP