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

18 votes250 views5 answers
Create model, controller and migration in single command laravel
PHP
1 vote311 views1 answer
Laravel routing controller get and post method
PHP Laravel
1 vote334 views2 answers
Pass image path in laravel blade
PHP Laravel
0 vote305 views1 answer
Laravel get image extension
PHP Laravel
1 vote269 views1 answer
Oci_execute(): ORA-01810: format code appears twice in
PHP
7 votes318 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP Laravel
14 votes248 views6 answers
Install php 8 ubuntu
PHP
0 vote372 views1 answer
Update php version in laravel
PHP Laravel
13 votes337 views6 answers
Laravel api routes
PHP Laravel
1 vote263 views1 answer
Php sql sever connection code
PHP