Insert to DB
Home
$from";
if (($handle = fopen("filelist.csv", 'r')) !== false) {
while (($filelist[$fileNums] = fgetcsv($handle, 0, ',')) !== false) {
$fileNums++;
}
}
if ($to == 0 || $to >= $fileNums) {
$to = $fileNums - 1;
}
$FileName = $filelist[$from][1] . ".htm";
$fileId = $filelist[$from][0];
$fileId = $filelist[$from][0];
$dirLog = _DIR_LOG_;
$inputFileName = $FileName;
$outputFileNameHead = $filelist[$from][1];
$bookId = $filelist[$from][2];
$vriParNum = 0;
$wordOrder = 1;
$dirXmlBase = _DIR_PALI_CSV_ . "/";
$dirXml = $outputFileNameHead . "/";
$currChapter = "";
$currParNum = "";
$arrAllWords[0] = array("id", "wid", "book", "paragraph", "word", "real", "type", "gramma", "mean", "note", "part", "partmean", "bmc", "bmt", "un", "style", "vri", "sya", "si", "ka", "pi", "pa", "kam");
$g_wordCounter = 0;
$arrUnWords[0] = array("id", "word", "type", "gramma", "parent", "mean", "note", "part", "partmean", "cf", "state", "delete", "tag", "len");
$g_unWordCounter = 0;
$arrUnPart[0] = "word";
$g_unPartCounter = -1;
/*去掉标点符号的统计*/
$arrAllPaliWordsCount = array();
$g_paliWordCounter = 0;
$g_wordCounterInSutta = 0;
$g_paliWordCountCounter = 0;
$xmlfile = $inputFileName;
echo "doing:" . $xmlfile . "
";
$log = $log . "$from,$FileName,open\r\n";
PDO_Connect(_FILE_DB_PALICANON_TEMPLET_);
$row=0;
// 开始一个事务，关闭自动提交
$PDO->beginTransaction();
$query = "INSERT INTO "._TABLE_PALICANON_TEMPLET_." ( book , paragraph, wid , word , real , type , gramma , part , style ) VALUES (?,?,?,?,?,?,?,?,?)";
$stmt = $PDO->prepare($query);
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
echo "error - $error[2]
";
$log = $log . "$from, $FileName, error, $error[2] \r\n";
exit;
} else {
// 打开文件并读取数据
if (($fp = fopen($dirXmlBase . $dirXml . $outputFileNameHead . ".csv", "r")) !== false) {
while (($data = fgetcsv($fp, 0, ',')) !== false) {
if($row>0){
$params = array(
mb_substr($data[2], 1),
$data[3],
$data[16],
$data[4],
$data[5],
$data[6],
$data[7],
$data[10],
$data[15]);
$stmt->execute($params);
}
$row++;
}
fclose($fp);
echo "单词表load：" . $dirXmlBase . $dirXml . $outputFileNameHead . ".csv
";
} else {
echo "can not open csv file. filename=" . $dirXmlBase . $dirXml . $outputFileNameHead . ".csv";
}
}
// 提交更改
$PDO->commit();
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
echo "error - $error[2]
";
$log = $log . "$from, $FileName, error, $error[2] \r\n";
} else {
echo "updata $row recorders.";
}
$myLogFile = fopen($dirLog . "insert_db.log", "a");
fwrite($myLogFile, $log);
fclose($myLogFile);
?>
齐活！功德无量！all done!";
} else {
echo "";
echo "正在载入:" . ($from + 1) . "——" . $filelist[$from + 1][0];
}
?>