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 vote271 views1 answer
Check if host is local in php
PHP
2 votes267 views1 answer
Fetch value from json link in php
PHP
0 vote349 views1 answer
Laravel import data from csv
PHP Laravel
0 vote269 views1 answer
Laravel count distance lat/longtidue
PHP
37 votes276 views3 answers
Php unset array element
PHP
2 votes270 views1 answer
Merubah judul menjadi slug codeigniter
PHP
0 vote274 views1 answer
Wp cpt dashicon
PHP
3 votes276 views3 answers
PHP time limit (max_execution_time):
PHP
1 vote284 views2 answers
Do_action( 'wp_head' );
PHP
0 vote269 views1 answer
Laravel move/rename file ftp
PHP