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 vote181 views1 answer
Laravel include files
PHP
0 vote261 views1 answer
Script to create AdminLTE in a Laravel project
PHP Laravel
9 votes193 views1 answer
Get data in orderby in laravel
PHP
0 vote236 views1 answer
Laravel stack script
PHP Laravel
7 votes228 views5 answers
Laravel model update table
PHP Laravel
0 vote201 views1 answer
Php mysql if exists
PHP
4 votes292 views6 answers
Jwt for Laravel
PHP Laravel
0 vote194 views1 answer
7 reasons why Lee is an idiot
PHP
0 vote204 views3 answers
Lookup token information in vault
PHP
3 votes173 views1 answer
How to install all php extensions ubuntu
PHP