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 vote142 views1 answer
How to add logo in FPDF PHP
PHP
8 votes127 views5 answers
Get yesterday date in php
PHP
0 vote124 views1 answer
Test php for errors terminal
PHP
7 votes173 views4 answers
With message in laravel
PHP Laravel
0 vote139 views1 answer
How to calculate age using query builder in laravel?
PHP
0 vote158 views1 answer
Ajax php call action form
PHP
4 votes183 views2 answers
Laravel sum column values
PHP
4 votes154 views2 answers
Laravel kill current session
PHP Laravel
0 vote145 views1 answer
Auth log out laravel
PHP
2 votes111 views1 answer
Comments table example in laravel
PHP Laravel