";
$query = "select word,count from wordindex where \"word_en\" like ".$PDO->quote($searching.'%')." OR \"word\" like ".$PDO->quote($searching.'%')." limit 0,50";
echo $query;
$Fetch = PDO_FetchAll($query);
$queryTime=(microtime_float()-$time_start)*1000;
echo "
搜索时间：$queryTime
";
$iFetch=count($Fetch);
if($iFetch>0){
for($i=0;$i<$iFetch;$i++){
$word=$Fetch[$i]["word"];
$count=$Fetch[$i]["count"];
echo "
";
}
}
echo "
";
//主显示区开始
echo "
";
//主显示区左侧开始
echo "
";
echo "
筛选 ";
echo "
共{$countWord}单词符合
";
//显示单词列表
echo "
";
echo "
全选
";
arsort($aShowWordList);
$i=0;
foreach($aShowWordList as $x=>$x_value) {
$wordid=$aShowWordIdList[$x];
echo "
";
echo "
";
echo $x.":".$x_value." ";
$i++;
}
echo "
";
echo "
";
//查找这些词出现在哪些书中
echo "
";
$booklist=render_book_list($strQueryWordId);
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();
$dictFileName=_FILE_DB_PALI_INDEX_;
PDO_Connect("sqlite:$dictFileName");
$query = "SELECT book,paragraph, wordindex FROM word WHERE \"wordindex\" in $strQueryWordId and book in $strFirstBookList group by book,paragraph LIMIT 0,20";
$Fetch = PDO_FetchAll($query);
//echo "
$query
";
$queryTime=(microtime_float()-$time_start)*1000;
$iFetch=count($Fetch);
if($iFetch>0){
$dictFileName=_FILE_DB_PALITEXT_;
PDO_Connect("sqlite:$dictFileName");
for($i=0;$i<$iFetch;$i++){
$paliwordid=$Fetch[$i]["wordindex"];
$paliword=$aQueryWordList["{$paliwordid}"];
$book=$Fetch[$i]["book"];
$paragraph=$Fetch[$i]["paragraph"];
$bookInfo = _get_book_info($book);
$bookname=$bookInfo->title;
$c1=$bookInfo->c1;
$c2=$bookInfo->c2;
$c3=$bookInfo->c3;
echo "
";
echo "
$paliword
";
//echo "
";
$path_1 = $c1.">";
if($c2 !== ""){
$path_1=$path_1.$c2.">";
}
if($c3 !== ""){
$path_1=$path_1.$c3.">";
}
$path_1=$path_1."《{$bookname}》>";
$query = "select * from pali_text where \"book\" = '{$book}' and \"paragraph\" = '{$paragraph}' limit 0,1";
$FetchPaliText = PDO_FetchAll($query);
$countPaliText=count($FetchPaliText);
if($countPaliText>0){
$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);
$path="{$FetParent[0]["toc"]}>{$path}";
if($sFirstParentTitle==""){
$sFirstParentTitle = $FetParent[0]["toc"];
}
$parent = $FetParent[0]["parent"];
$deep++;
if($deep>5){
break;
}
}
$path=$path_1.$path."para. ".$paragraph;
echo "
";
for($iPali=0;$iPali<$countPaliText;$iPali++){
if(substr($paliword,-1)=="n"){
$paliword=substr($paliword,0,-1);
}
$htmltext=$FetchPaliText[0]["html"];
$light_text=str_replace($paliword,"
{$paliword} ",$htmltext);
echo "
{$light_text}
";
}
//echo "
{$light_text}
";
echo "
Edit
";
}
echo "
";
}
}
$queryTime=(microtime_float()-$time_start)*1000;
echo "
搜索时间：$queryTime
";
echo "
";
//黑体字主显示区右侧结束
echo "
";
echo "haha";
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_WORD_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 "
Edit
";
}
}
echo "
";
}
}
break;
}
break;
}
?>