Error: [$errno] $errstr";
}
//set error handler
set_error_handler("customError");
require_once '../path.php';
require_once "../public/_pdo.php";
require_once "../public/function.php";
function getWordEn($strIn){
$strIn = strtolower($strIn);
$search = array('ā', 'ī', 'ū', 'ṅ', 'ñ' , 'ṭ', 'ḍ', 'ṇ', 'ḷ', 'ṃ');
$replace = array('a', 'i', 'u', 'n', 'n' , 't', 'd', 'n', 'l', 'm');
return(str_replace($search,$replace,$strIn));
}
?>
Update Table of Contence
$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];
}
?>