/PHP/Csv file import to mysqli using php

Csv file import to mysqli using php

<?php

   if(!empty($_FILES['file']['name']))
   {
    $connect = new PDO("mysql:host=localhost;dbname=dn_tcs_project_data;", "root", "", array(
           PDO::MYSQL_ATTR_LOCAL_INFILE => true,
       ));
   $mysqli = new mysqli("localhost","root","","dn_tcs_project_data");
    $total_row = count(file($_FILES['file']['tmp_name']));
   
    $file_location = str_replace("\\", "/", $_FILES['file']['tmp_name']);
   
    $query_1 = '
    LOAD DATA LOCAL INFILE "'.$file_location.'" IGNORE 
    INTO TABLE tcs_raw_task_sheets 
    FIELDS TERMINATED BY "," 
    LINES TERMINATED BY "\r\n" 
    IGNORE 1 LINES 
    (@column1,@column2,@column3,@column4,@column5,@column6,@column7,@column8,@column9) 
    SET MW = @column1, HT_MW = @column2,  D_MW = @column3, C_MW = @column4, QA = @column5, D_QA = @column6, C_QA = @column7, R_QA = @column8, R_EVA = @column9
    ';
   
    $statement = $connect->prepare($query_1);
   
    $statement->execute();
    if ($statement) {
          $output = array(
     'success' => 'Total <b>'.$total_row.'</b> Data imported'
    );
   
    echo json_encode($output);
?>

Similar codes

0 vote122 views1 answer
Wp functions ajax get
PHP Wordpress
4 votes110 views6 answers
Database connection in php
PHP
15 votes126 views6 answers
Confirm password validation in laravel
PHP Laravel
2 votes129 views1 answer
Wordpress get post time
PHP Wordpress
3 votes117 views5 answers
Get current locale laravel
PHP Laravel
2 votes116 views1 answer
Wordpress check user against user roles
PHP Wordpress
0 vote106 views1 answer
Check current pages is a child page wordpress
PHP
18 votes94 views3 answers
Php pop off the first character of string
PHP
11 votes113 views4 answers
Laravel create resource controller
PHP Laravel
20 votes156 views4 answers
Php all date formats
PHP