我正在尝试将一个csv文件导入到一个 mysql表中,我目前有一个逐行运行的脚本,因为我需要将一个id与另一个id结合使用以及格式化MysqL格式的日期.

csv文件的列数多于我当前导入的列数.是否更容易导入所有列？

我正在阅读LOAD DATA INFILE(http://dev.MysqL.COM/doc/refman/5.1/en/load-data.htML),但我想知道如何使用它并散列id并格式化日期没有逐行执行.我当前的脚本占用时间太长,导致运行时出现站点性能问题.

这是我有的：

$url = 'http://www.example.com/directory/file.csv';
if (($handle = foPEn($url,"r")) !== FALSE) 
{
fgetcsv($handle,1000,",");
while (($data = fgetcsv($handle,")) !== FALSE) 
{
    $EvID = $data[0];
    $Ev = $data[1];
    $PerID = $data[2];
    $Per = $data[3];
    $VName = $data[4];
    $VID = $data[5];
    $VSA = $data[6];
    $DateTime = $data[7];
    $PCatID = $data[8];
    $PCat = $data[9];
    $CCatID = $data[10];
    $CCat = $data[11];
    $GCatID = $data[12];
    $GCat = $data[13];
    $CITy = $data[14];
    $state = $data[15];
    $StateiD = $data[16];
    $Country = $data[17];
    $CountryID = $data[18];
    $Zip = $data[19];
    $TYN = $data[20];
    $IMAGEURL = $data[21];
    $URLLink = $data[22];

        $data[7] = strtotime($data[7]);
        $data[7] = date("Y-m-d H:i:s",$data[7]);

    if((($PCatID == '2') && (($CountryID == '217') or ($CountryID == '38'))) || (($GCatID == '16') or ($GCatID == '19') or ($GCatID == '30') or ($GCatID == '32'))) 
    {
            if(!MysqL_query("INSERT IGNORE INTO TNDB_CSV2 
                (id,EvID,Event,PerID,Per,VName,VID,VSA,DateTime,PCatID,PCat,CCatID,CCat,GCatID,GCat,City,State,StateID,Country,CountryID,Zip,TYN,IMAGEURL) VALUES
                ('".md5($EventID.$PerformerID)."','".addslashes($data[0])."','".addslashes($data[1])."','".addslashes($data[2])."','".addslashes($data[3])."','".addslashes($data[4])."','".addslashes($data[5])."','".addslashes($data[6])."','".addslashes($data[7])."','".addslashes($data[8])."','".addslashes($data[9])."','".addslashes($data[10])."','".addslashes($data[11])."','".addslashes($data[12])."','".addslashes($data[13])."','".addslashes($data[14])."','".addslashes($data[15])."','".addslashes($data[16])."','".addslashes($data[17])."','".addslashes($data[18])."','".addslashes($data[19])."','".addslashes($data[20])."','".addslashes($data[21])."')"))
            {                    
                exit("<br>" . MysqL_error());
            }
    }
}
fclose($handle);
}

任何帮助总是非常感谢.提前致谢.

$url = 'http://www.example.com/directory/file.csv';
if (($handle = fopen($url,");

$imports = array();

while (($data = fgetcsv($handle,$data[7]);

    if((($PCatID == '2') && (($CountryID == '217') or ($CountryID == '38'))) || (($GCatID == '16') or ($GCatID == '19') or ($GCatID == '30') or ($GCatID == '32'))) 
    {

    $imports[] = "('".md5($EventID.$PerformerID)."','".addslashes($data[21])."')";



    }
}

$importarrays = array_chunk($imports,100);
foreach($importarrays as $arr) {

 if(!MysqL_query("INSERT IGNORE INTO TNDB_CSV2 
                (id,IMAGEURL) VALUES ".implode(',',$arr)){

     die("error: ".MysqL_error());

 }

 }

fclose($handle);
}