php - 如何读取csv中的数据并上传到Mysql

Question

我有一个 csv 格式的文件，格式如下:

"**Table1"
"*Field1","*Field2","*Field3","*Field4"
"Data1","Data2", "Data3", "Data4"

"**Table2"
"*Field1","*Field2","*Field3","*Field4"
"Data1","Data2", "Data3", "Data4"

我希望程序能够识别表1/2，并将数据上传到mysql预定义的表中。我打算使用 PHP。有没有人试过这样做？我正在寻找一个例子和方法!谢谢。

Answer 1

你可以尝试这样的事情:

$handle = fopen("./myfile.csv", "r");
if ($handle === FALSE) {
  exit();
}
// ignore header
fgetcsv($handle, 1000, ",");

// generate SQL query
$sql = "INSERT INTO `mytable` (col1, col2, ...) VALUES ";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
  $sql .= '("'.$data[0].'", "'.$data[1].'", "'.$data[2].'", ...),';
}
$sql = substr($sql,0,strlen($sql)-1).';';
// then execute your query

已编辑