将CSV文件直接导入MySQL

您可以创建一个脚本来解析您的csv文件并将数据放入db。

就像是：

    $path = "yourfile.csv";    $row = 1;    if (($handle = fopen($path, "r")) !== FALSE) {        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $row++; $data_entries[] = $data ;        }        fclose($handle);    }    // this you'll have to expand    foreach($data_entries as $line){        $sql = "INSERT INTO ..."        $db->execute($line);    }