function getFileAndSave($dataFile, $prodName, $version, $ts) { $dataHandle = new DataHandle(); if (file_exists($dataFile)) { $handle = fopen($dataFile, "r"); $line = fgets($handle); $sumEadPvNum = 0; $sumEadBidNum = 0; $sumEadImprNum = 0; $sumExchangePvNum = 0; $sumExchangeBidNum = 0; $sumExchangeImprNum = 0; while ($line != "") { //将数据存入数据库 $line = str_replace(";", ",", $line); $lineArray = explode(",", $line); $time = $lineArray[0]; $platform = $lineArray[1]; $type = $lineArray[2]; $pvNum = $lineArray[3]; $bidNum = $lineArray[4]; $imprNum = $lineArray[5]; $id = $dataHandle->insertDataInfo($time, $platform, $type, $pvNum, $bidNum, $imprNum, $prodName, $version, $ts); echo "insert dataInfo: " . $id; if ($type == "ead") { $sumEadPvNum += $pvNum; $sumEadBidNum += $bidNum; $sumEadImprNum += $imprNum; } else { //exchange $sumExchangePvNum += $pvNum; $sumExchangeBidNum += $bidNum; $sumExchangeImprNum += $imprNum; } $line = fgets($handle); } $id1 = $dataHandle->insertSumData($time, "ead", $sumEadPvNum, $sumEadBidNum, $sumEadImprNum, $prodName, $version, $ts); echo "insert ead sumData: " . $id1; $id2 = $dataHandle->insertSumData($time, "exchange", $sumExchangePvNum, $sumExchangeBidNum, $sumExchangeImprNum, $prodName, $version, $ts); echo "insert exchange sumData: " . $id1; echo "insert done.<br/>"; $dataHandle->closeDB(); fclose($handle); } return 0; }