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 vote305 views1 answer
Increase xampp phpmyadmin import limit
PHP
2 votes313 views1 answer
Laravel mix purge css
PHP
1 vote356 views3 answers
Laravel title dynamic
PHP
3 votes374 views2 answers
How to redirect a particular user role to a page after login laravel
PHP Laravel
6 votes332 views2 answers
Php go to another page
PHP
3 votes332 views2 answers
Acf options repeater
PHP
2 votes338 views2 answers
Wordpress theme The link you followed has expired.
PHP
0 vote301 views1 answer
Php get docblock with reflection
PHP
1 vote332 views1 answer
WP Uploads Media Path
PHP
0 vote280 views1 answer
Get wordpress id
PHP