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 vote99 views1 answer
Laravel how to address to git repo for develop packages
PHP
0 vote141 views1 answer
Laravel imap - Get message attachments
PHP
105 votes255 views6 answers
Php contains substring
PHP
11 votes133 views4 answers
Get first row of array php
PHP
0 vote98 views1 answer
If is alphabet php
PHP
7 votes152 views4 answers
Laravel is route name
PHP Laravel
0 vote103 views1 answer
Laravel price database
PHP Laravel
2 votes115 views1 answer
Laravel get list of columns in a table
PHP Laravel
3 votes115 views1 answer
Run laravel cron job on cpanel
PHP Laravel
1 vote112 views1 answer
Get user with role laravel
PHP Laravel