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 vote201 views1 answer
Convert 1 digit to five digits laravel
PHP
0 vote278 views1 answer
How uplpoad video in laravel
PHP
7 votes206 views5 answers
Connect sql server php
PHP
0 vote158 views0 answer
PHP
0 vote253 views1 answer
Edit items in Laravel collection
PHP Laravel
5 votes217 views3 answers
Download npm package
PHP
1 vote222 views2 answers
Check if phone number is valid php
PHP
0 vote204 views1 answer
Set config key dynamic laravel
PHP
0 vote219 views1 answer
Background image in laravel blade
PHP
0 vote206 views2 answers
Php split string in half
PHP