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

2 votes175 views2 answers
Laravel insert timestamp now
PHP
0 vote172 views1 answer
Laravel move/rename file ftp
PHP
0 vote189 views1 answer
How to index column in laravel
PHP
1 vote179 views1 answer
Php previous site
PHP
3 votes214 views4 answers
Round() laravel
PHP Laravel
6 votes198 views3 answers
Php artisan ui auth
PHP
0 vote200 views1 answer
Hook into admin add order item / product on add/submit
PHP
1 vote189 views2 answers
Laravel collection flatten
PHP
0 vote233 views1 answer
How to get shop page url in wordpress
PHP Wordpress
0 vote197 views1 answer
Php arrow function
PHP