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 vote310 views1 answer
Wp tax_query in
PHP
0 vote375 views1 answer
Find curren monday in laravel carbon
PHP Laravel
0 vote461 views1 answer
Drupal 8 / 9 entityTypeManager get multiple comments by cid
PHP Drupal
0 vote331 views1 answer
Symfony functional test clear session and cookies
PHP
0 vote313 views3 answers
Php find multiple value in array
PHP
11 votes340 views4 answers
Php str starts with
PHP
0 vote310 views1 answer
Php preplace
PHP
0 vote387 views1 answer
Configuration laravel dompdf
PHP Laravel
8 votes350 views3 answers
Laravel model::query
PHP Laravel
0 vote327 views2 answers
Check empty laravel blade
PHP Laravel