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

2 votes148 views3 answers
Wordpress is home page
PHP Wordpress
6 votes154 views6 answers
Composer memory limit
PHP
0 vote152 views1 answer
Check if the link is image or url php
PHP
13 votes155 views3 answers
Mysqldump php
PHP
1 vote127 views1 answer
How to create a bot in telegram in php
PHP
1 vote180 views1 answer
Static function model laravel
PHP Laravel
0 vote135 views1 answer
PHP 2-Dimentional array
PHP
0 vote151 views1 answer
Laravel select only some columns relationship
PHP Laravel
0 vote101 views1 answer
Laravel return view with multiple data
PHP
0 vote172 views1 answer
Laravel on cascade set null
PHP Laravel