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 vote139 views1 answer
Php get docblock with reflection
PHP
16 votes117 views2 answers
Allert in php
PHP
0 vote139 views1 answer
Php loop through months
PHP
2 votes123 views1 answer
Php remove null bytes from string
PHP
1 vote116 views2 answers
Yii1 set flash
PHP
0 vote120 views2 answers
Php get post json data
PHP
1 vote147 views2 answers
Laravel init
PHP Laravel
-1 vote122 views1 answer
Read an email with php
PHP
0 vote145 views1 answer
Show one value after point php
PHP
1 vote127 views1 answer
Increase xampp phpmyadmin import limit
PHP