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 vote219 views2 answers
Check empty laravel blade
PHP Laravel
0 vote170 views1 answer
Check custom post type post exists
PHP
11 votes257 views6 answers
Convert object to array php
PHP
0 vote233 views1 answer
Display wp shortcode by php
PHP
0 vote267 views1 answer
Array helper array_push laravel
PHP Laravel
1 vote250 views1 answer
Laravel 6 make http request
PHP Laravel
6 votes230 views4 answers
Return message in laravel
PHP Laravel
0 vote230 views1 answer
Rename matomo php
PHP
2 votes230 views1 answer
Check if value is not null in db laravel
PHP
0 vote237 views1 answer
Create model for existing table in laravel
PHP Laravel