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 vote108 views1 answer
Get today date magento 2 object manager
PHP
7 votes118 views3 answers
Laravel 8 – Remove Public from URL
PHP
0 vote120 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
1 vote130 views1 answer
Insert data using model in laravel 8
PHP Laravel
0 vote106 views2 answers
Uninstall php 8.0 ubuntu
PHP
0 vote102 views2 answers
Wordpress profile queries
PHP
2 votes104 views4 answers
Laravel where in array
PHP
0 vote114 views1 answer
Javatpoint php
PHP
0 vote108 views1 answer
How to check my server use cgi, fcgi or fpm.
PHP
1 vote157 views1 answer
Symfony call another controller
PHP Symfony