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 vote195 views1 answer
Php get json objects by key without indez
PHP
10 votes185 views3 answers
Remove package in laravel
PHP
3 votes244 views1 answer
Laravel e commerce full project
PHP Laravel
0 vote216 views1 answer
Use id as key in co;lection laravel
PHP Laravel
0 vote180 views1 answer
PHP (WordPress) - Increase Maximum Upload File Size
PHP
32 votes226 views6 answers
Php get ip address
PHP
3 votes187 views1 answer
Php location
PHP
59 votes217 views6 answers
Laravel seeder
PHP
0 vote209 views1 answer
Return only one column data from table in codeigniter
PHP
0 vote191 views1 answer
Generate press viewport
PHP