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 vote275 views1 answer
Area of a circle segment in php
PHP
0 vote352 views1 answer
Updating a row from databse using php
PHP
9 votes367 views3 answers
Pass variable to blade laravel
PHP Laravel
0 vote295 views1 answer
Xampp downgrade php
PHP
0 vote290 views1 answer
Laravel vreeze
PHP
0 vote340 views1 answer
Cloudinary laravel
PHP Laravel
0 vote306 views1 answer
Pure Intersection Types - PHP 8.1
PHP
0 vote298 views1 answer
Get random post laravel
PHP Laravel
0 vote316 views1 answer
Acf wordpress loop through and display blog posts order by date and type
PHP
0 vote290 views3 answers
Cpanel email to email send with php
PHP