Upload csv file in php

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

Upload csv file in php

if (isset($_POST['import'])) {
    if ($_FILES['file']['name']) {
        $filename = explode(".", $_FILES['file']['name']);
        if ($filename[1] == 'csv') {
            $handle = fopen($_FILES['file']['tmp_name'], "r");
           $i = 0;
            while ($getData = fgetcsv($handle)) {
                if($i > 0){
                    $productName   = $getData[0];
                    $productDesc   = $getData[1];
                    $productQty   = $getData[2];
                    $productPrice   = $getData[3];
                    $productTotal   = $getData[4];
                    $sql = "INSERT INTO import (productName,productDesc,productQty,productPrice,productTotal) VALUES('" . $getData[0] . "','" . $getData[1] . "','" . $getData[2] . "','" . $getData[3] . "','" . $getData[4] . "')";
                    $result = mysqli_query($conn, $sql);
                    header("Location:import.php");
                }
                $i++;
            }
            fclose($handle);
        }
    }
}

Check your table name,column name & where you want to redirect using header function.

Similar codes

0 vote166 views1 answer
Phpunit-watcher
PHP
28 votes72 views12 answers
Laravel middleware
PHP
1 vote100 views1 answer
Php check if parameter exists
PHP
1 vote107 views1 answer
Linux nohup write other file
PHP
0 vote136 views2 answers
Laravel undefined index
PHP Laravel
1 vote134 views1 answer
Inrandomorder laravel
PHP Laravel
0 vote108 views1 answer
Remove all items of an array except the last 5 in php
PHP
0 vote110 views1 answer
Cambiare pagina php
PHP
1 vote113 views1 answer
Error: Cannot redeclare composerRequire1d8e02dff94f518b7a14ddcb6710f10d() (previously declared in /Applications/XAMPP/xamppfiles/htdocs/all4learn2/Vendor/composer/autoload_real.php:66)
PHP
0 vote122 views1 answer
Php shell_exec must be connected to a terminal
PHP