0){ $booktypesum["vinaya"]=array(0,0); $booktypesum["sutta"]=array(0,0); $booktypesum["abhidhamma"]=array(0,0); $booktypesum["anna"]=array(0,0); $booktypesum["mula"]=array(0,0); $booktypesum["atthakattha"]=array(0,0); $booktypesum["tika"]=array(0,0); $booktypesum["anna2"]=array(0,0); for($i=0;$i<$iFetch;$i++){ $book=$Fetch[$i]["book"]; $sum=$Fetch[$i]["co"]; array_push($newBookList,array($book,$sum)); $t1=$arrBookType[$book-1]->c1; $t2=$arrBookType[$book-1]->c2; if(isset($booktypesum[$t1])){ $booktypesum[$t1][0]++; $booktypesum[$t1][1]+=$sum; } else{ $booktypesum[$t1][0]=1; $booktypesum[$t1][1]=$sum; } if(isset($booktypesum[$t2])){ $booktypesum[$t2][0]++; $booktypesum[$t2][1]+=$sum; } else{ $booktypesum[$t2][0]=1; $booktypesum[$t2][1]=$sum; } } echo "
"; echo "出现在{$iFetch}本书中:
"; echo "全选
"; echo "律藏-{$booktypesum["vinaya"][0]}-{$booktypesum["vinaya"][1]}
"; echo "经藏-{$booktypesum["sutta"][0]}-{$booktypesum["sutta"][1]}
"; echo "阿毗达摩藏-{$booktypesum["abhidhamma"][0]}-{$booktypesum["abhidhamma"][1]}
"; echo "其他-{$booktypesum["anna"][0]}-{$booktypesum["anna"][1]}

"; echo "根本-{$booktypesum["mula"][0]}-{$booktypesum["mula"][1]}
"; echo "义注-{$booktypesum["atthakattha"][0]}-{$booktypesum["atthakattha"][1]}
"; echo "复注-{$booktypesum["tika"][0]}-{$booktypesum["tika"][1]}
"; echo "其他-{$booktypesum["anna2"][0]}-{$booktypesum["anna2"][1]}

"; echo "
"; for($i=0;$i<$iFetch;$i++){ $book=$Fetch[$i]["book"]; $bookname=_get_book_info($book)->title; if(isset($booklist)){ if(isset($aInputBook["{$book}"])){ $bookcheck="checked"; } else{ $bookcheck=""; } } else{ $bookcheck="checked"; } $t1=$arrBookType[$book-1]->c1; $t2=$arrBookType[$book-1]->c2; echo "
"; echo "
"; } echo ""; echo "
"; } return($newBookList); //查找这些词出现在哪些书中结束 } switch($op){ case "pre"://预查询 { $time_start = microtime_float(); $searching=$arrWordList[count($arrWordList)-1]; PDO_Connect("sqlite:"._FILE_DB_RESRES_INDEX_); if(count($arrWordList)>1){ echo "
"; foreach($arrWordList as $oneword){ echo $oneword."+"; } echo "
"; } $query = "select title from 'index' where \"title_en\" like ".$PDO->quote("%".$searching.'%')." OR \"title\" like ".$PDO->quote("%".$searching.'%')." group by title limit 0,20"; $Fetch = PDO_FetchAll($query); $queryTime=(microtime_float()-$time_start)*1000; $iFetch=count($Fetch); if($iFetch>0){ for($i=0;$i<$iFetch;$i++){ $word=$Fetch[$i]["title"]; echo "$word"; } } break; } case "search": { $time_start = microtime_float(); echo "
"; //主显示区开始 echo "
"; //主显示区左侧开始 echo "
"; echo ""; $queryTime=(microtime_float()-$time_start)*1000; echo "
"; //查找这些词出现在哪些书中 echo "
"; $booklist=render_book_list($_GET["word"]); echo "
"; $wordInBookCounter=0; $strFirstBookList="("; foreach($booklist as $onebook){ $wordInBookCounter+=$onebook[1]; $strFirstBookList.="'".$onebook[0]."',"; if($wordInBookCounter>=20){ break; } } $strFirstBookList=mb_substr($strFirstBookList, 0,mb_strlen($strFirstBookList,"UTF-8")-1,"UTF-8"); $strFirstBookList.=")"; echo "
"; //黑体字主显示区左侧结束 //黑体字主显示区右侧开始 echo "
"; //前20条记录 $time_start=microtime_float(); PDO_Connect("sqlite:"._FILE_DB_RESRES_INDEX_); if(isset($_GET["booklist"])){ $query = "select * from 'index' where (\"title_en\" like ".$PDO->quote("%".$_GET["word"].'%')." OR \"title\" like ".$PDO->quote("%".$_GET["word"].'%').") and book in {$_GET["booklist"]} limit 0,50"; } else{ $query = "select * from 'index' where \"title_en\" like ".$PDO->quote("%".$_GET["word"].'%')." OR \"title\" like ".$PDO->quote("%".$_GET["word"].'%')." limit 0,50"; } $Fetch = PDO_FetchAll($query); $queryTime=(microtime_float()-$time_start)*1000; $iFetch=count($Fetch); if($iFetch>0){ PDO_Connect("sqlite:"._FILE_DB_PALITEXT_); for($i=0;$i<$iFetch;$i++){ $title=$Fetch[$i]["title"]; $book=$Fetch[$i]["book"]; $paragraph=$Fetch[$i]["paragraph"]; echo "
"; echo "
$title
"; $bookInfo = _get_book_info($book); $bookname=$bookInfo->title; $c1=$bookInfo->c1; $c2=$bookInfo->c2; $c3=$bookInfo->c3; $path_1 = $c1.">"; if($c2 !== ""){ $path_1=$path_1.$c2.">"; } if($c3 !== ""){ $path_1=$path_1.$c3.">"; } $path_1=$path_1."《{$bookname}》>"; $path = _get_para_path($book,$paragraph); echo $path_1.$path; $query = "select chapter_len from pali_text where \"book\" = '{$book}' and \"paragraph\" = '{$paragraph}' limit 0,1"; $chapter_len = PDO_FetchAll($query); $chapter_len = $chapter_len[0]["chapter_len"]; $query = "select text from pali_text where \"book\" = '{$book}' and (\"paragraph\" > '{$paragraph}' and \"paragraph\" <= '".($paragraph+$chapter_len)."') limit 0,3"; $FetchPaliText = PDO_FetchAll($query); $paliContent = ""; foreach($FetchPaliText as $text){ $paliContent .= $text["text"]; } $paliContent = mb_substr($paliContent,0,200,"UTF-8"); echo "
{$paliContent}
"; echo "
"; echo "
"; } } $queryTime=(microtime_float()-$time_start)*1000; echo "
搜索时间:$queryTime
"; echo "
"; //黑体字主显示区右侧结束 echo "
"; echo "
"; echo "
"; //黑体字主显示区结束 echo "
"; //查黑体字结束 echo "
"; break; } case "update": $target=$_GET["target"]; switch($target){ case "bold"; $wordlist=$_GET["wordlist"]; $booklist=$_GET["booklist"]; $aBookList=ltrim($booklist,"("); $aBookList=rtrim($aBookList,")"); $aBookList=str_replace("'","",$aBookList); $aBookList=str_getcsv($aBookList); $arrBookType=json_decode(file_get_contents("../public/book_name/booktype.json")); //查找这些词出现在哪些书中 $newBookList=render_book_list($wordlist,$aBookList); //前20条记录 $time_start=microtime_float(); $dictFileName=_FILE_DB_PALI_INDEX_; PDO_Connect("sqlite:$dictFileName"); $query = "select * from word where \"wordindex\" in $wordlist and \"book\" in $booklist group by book,paragraph limit 0,20"; $Fetch = PDO_FetchAll($query); //echo "
$query
"; $queryTime=(microtime_float()-$time_start)*1000; echo "
搜索时间:$queryTime
"; $iFetch=count($Fetch); if($iFetch>0){ $dictFileName=_FILE_DB_PALITEXT_; PDO_Connect("sqlite:$dictFileName"); for($i=0;$i<$iFetch;$i++){ $paliword=$Fetch[$i]["wordindex"]; //$paliword=$wordlist["{$paliwordid}"]; $book=$Fetch[$i]["book"]; $bookInfo = _get_book_info($book); $bookname=$bookInfo->title; $c1=$bookInfo->c1; $c2=$bookInfo->c2; $c3=$bookInfo->c3; $paragraph=$Fetch[$i]["paragraph"]; $path_1 = $c1.">"; if($c2 !== ""){ $path_1=$path_1.$c2.">"; } if($c3 !== ""){ $path_1=$path_1.$c3.">"; } $path_1=$path_1."《{$bookname}》>"; echo "
"; echo "
《{$bookname}》 $c1 $c2
"; echo "
$paliword
"; $query = "select * from pali_text where \"book\" = '{$book}' and \"paragraph\" = '{$paragraph}' limit 0,20"; $FetchPaliText = PDO_FetchAll($query); $countPaliText=count($FetchPaliText); if($countPaliText>0){ for($iPali=0;$iPali<$countPaliText;$iPali++){ $path=""; $parent = $FetchPaliText[0]["parent"]; $deep=0; $sFirstParentTitle=""; while($parent>-1){ $query = "select * from pali_text where \"book\" = '{$book}' and \"paragraph\" = '{$parent}' limit 0,1"; $FetParent = PDO_FetchAll($query); if($sFirstParentTitle==""){ $sFirstParentTitle = $FetParent[0]["toc"]; } $path="{$FetParent[0]["toc"]}>{$path}"; $parent = $FetParent[0]["parent"]; $deep++; if($deep>5){ break; } } $path=$path_1.$path."No. ".$paragraph; echo "
$path
"; //echo "
$paliword
"; if(substr($paliword,-1)=="n"){ $paliword=substr($paliword,0,-1); } $light_text=str_replace($paliword,"{$paliword}",$FetchPaliText[$iPali]["html"]); echo "
{$light_text}
"; echo "
"; } } echo "
"; } } break; } break; } ?>