Update Table of Contence

From:
To:
File:
Author:
Language:
$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="/"; $inputFileName=$FileName; $outputFileNameHead=$filelist[$from][1]; $bookId=$filelist[$from][2]; $vriParNum=0; $wordOrder=1; $dirXmlBase=_DIR_PALI_CSV_."/"; $dirPaliTextBase=_DIR_PALI_HTML_."/"; $dirXml=$outputFileNameHead."/"; $xmlfile = $inputFileName; $log=$log.date("Y-m-d h:i:sa").",$from,$FileName,open\r\n"; $arrInserString=array(); // 打开csv文件并读取数据 $inputRow=0; if(($fp=fopen(_DIR_PALI_TITLE_."/".($from+1)."_{$_file}.csv", "r"))!==FALSE){ while(($data=fgetcsv($fp,0,','))!==FALSE){ if($inputRow>0 && $data[3] != 100 && !empty($data[6])){ array_push($arrInserString,$data); } $inputRow++; } fclose($fp); echo "res load:"._DIR_PALI_TITLE_."/".($from+1)."_title.csv
"; } else{ echo "can not open csv "; if($from==$to){ echo "

齐活!功德无量!all done!

"; } else{ echo ""; echo "正在载入:".($from+1); echo ""; exit; } } $book=$from+1; //删除已有标题 PDO_Connect("sqlite:"._FILE_DB_RESRES_INDEX_); $query =" DELETE FROM 'index' WHERE book ='{$book}' AND language = '{$_lang}' "; $PDO->query($query); // 开始一个事务,关闭自动提交 $PDO->beginTransaction(); $query="INSERT INTO 'index' ('id','book','paragraph','title','title_en' ,'level','type','language','author','share','create_time','update_time' ) VALUES ( NULL , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )"; $stmt = $PDO->prepare($query); if($_lang=="1"){ $type=1; } else{ $type=2; } foreach($arrInserString as $title){ $newData=array( $book, $title[2], $title[6], getWordEn($title[6]), $title[3], $type, $_lang, $_author, 1, mTime(), mTime() ); $stmt->execute($newData); } // 提交更改 $PDO->commit(); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; $log=$log."$from, error, $error[2] \r\n"; } else{ $count=count($arrInserString); echo "updata $count title recorders.
"; } //段落信息结束 $myLogFile = fopen(_DIR_LOG_."/db_update_toc.log", "a"); fwrite($myLogFile, $log); fclose($myLogFile); ?> 齐活!功德无量!all done!"; } else{ echo ""; echo "正在载入:".($from+1)."——".$filelist[$from+1][0]; } ?>