合并标题文件
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_."/";
$dirDb="db/";
$inputFileName=$FileName;
$outputFileNameHead=$filelist[$from][1];
$bookId=$filelist[$from][2];
$vriParNum=0;
$wordOrder=1;
$dirXmlBase="xml/";
$dirXml=$outputFileNameHead."/";
$xmlfile = $inputFileName;
echo "doing:".$xmlfile."
";
$log=$log."$from,$FileName,open\r\n";
$arrInserString=array();
$db_file = $dirDb.'toc.db3';
$row=0;
if(($fp_toc=fopen($dirDb."toc.csv", "a"))===FALSE){
$error= "can not open csv file. filename=".$dirXmlBase.$dirXml.$outputFileNameHead.".csv";
echo $error;
$log=$log."$from,$FileName,error, $error \r\n";
}
// 打开文件并读取数据
if(($fp=fopen($dirXmlBase.$dirXml.$outputFileNameHead."_toc.csv", "r"))!==FALSE){
while(($data=fgetcsv($fp,0,','))!==FALSE){
if($row>0){
fputcsv($fp_toc,$data);
}
$row++;
}
fclose($fp);
fclose($fp_toc);
echo "Toc导出到：".$dirDb."toc.csv
";
echo "toc load：".$dirXmlBase.$dirXml.$outputFileNameHead."_toc.csv
";
}
else{
$error= "can not open csv file. filename=".$dirXmlBase.$dirXml.$outputFileNameHead."_toc.csv";
echo $error;
$log=$log."$from,$FileName,error, $error \r\n";
}
/* 开始一个事务，关闭自动提交 */
/*
$PDO->beginTransaction();
$query="INSERT INTO toc ('id','book','par_num','level','class','language','title','author','editor','modify','edition','sub_ver') VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?)";
$stmt = $PDO->prepare($query);
foreach($arrInserString as $oneParam){
$stmt->execute($oneParam);
}
*/
/* 提交更改 */
/*
$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{
$count=count($arrInserString);
echo "updata $count recorders.";
}
*/
$myLogFile = fopen($dirLog."insert_db_toc.log", "a");
fwrite($myLogFile, $log);
fclose($myLogFile);
?>
齐活！功德无量！all done!";
}
else{
echo "";
echo "正在载入:".($from+1)."——".$filelist[$from+1][0];
}
?>