将CSV文件数据导入MySQL表 [英] Import CSV file data into MySQL table

问题描述

我将CSV文件中的记录插入到MySQL表中;

I am inserting record from CSV file to MySQL table; if any record already exists update that record and insert other records and if there is no match of the record insert all records.

这里是我的代码

<?php
    $connect = mysql_connect('localhost','root','root');
    if (!$connect) {
     die('Could not connect to MySQL: ' . mysql_error());
    }
    $cid =mysql_select_db('bizin490_devcredit',$connect);
    define('CSV_PATH', '/home/ubc/Documents/');
    $csv_file = CSV_PATH . "test.csv";
    $csvfile  = fopen($csv_file, 'r');
    $theData  = fgets($csvfile);
    $i = 0;
    while (!feof($csvfile)) {

     $csv_data[] = fgets($csvfile, 1024);
     $csv_array  = explode(",", $csv_data[$i]);
     $insert_csv = array();
     $insert_csv['name']  = $csv_array[0];
     $insert_csv['email'] = $csv_array[1];

     $query = mysql_query("select name from test where name='" . $insert_csv['name'] . "'");
     $count = mysql_num_rows($query);

     if ($count == 0) {
      $query = "INSERT INTO test(name,email)VALUES('" . $insert_csv['name'] . "','" .  $insert_csv['email'] . "')";

      $n = mysql_query($query, $connect);

      } else {

        $sql = "update test set email='".$insert_csv['email']."'";
        //echo "<pre>";print_r($sql);
        $qu  = mysql_query($sql);
        echo "<pre>";print_r($_POST);
      }
     $i++;
     //die;
   }
   fclose($csvfile);
   echo "File data successfully imported to database!!";
   mysql_close($connect);
?>

推荐答案

类似：

LOAD DATA INFILE '/home/ubc/Documents/test.csv'
REPLACE
INTO TABLE `test`
(name, email)

这篇关于将CSV文件数据导入MySQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！