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

7 votes153 views3 answers
Parsefloat php
PHP
0 vote117 views1 answer
Php explode multiple delimiters
PHP
0 vote150 views1 answer
Wordpress change language of specific text php
PHP Wordpress
0 vote150 views1 answer
Create table laravel give name table
PHP Laravel
1 vote119 views3 answers
Get field object acf
PHP
0 vote112 views1 answer
File upload permission in php
PHP
1 vote91 views3 answers
Fetchall php
PHP
6 votes158 views6 answers
Php return a json response
PHP
0 vote150 views1 answer
Php mysql insert timestamp now
PHP
1 vote124 views1 answer
Carbon two day ago
PHP