quote($word.'%')." OR \"word\" like ".$PDO->quote($word.'%')." limit 0,100"; //echo $query; $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); echo ""; if($iFetch>0){ for($i=0;$i<$iFetch;$i++){ $outXml = ""; $word=$Fetch[$i]["word"]; $outXml = $outXml."$word"; $outXml = $outXml."".$Fetch[$i]["co"].""; $outXml = $outXml.""; echo $outXml; } } echo ""; break; case "search": //直接查询 //先查书籍单词总表 获取书号 $word_string="'".str_replace(",","','",$word); $word_string=mb_substr($word_string,0,-2,"UTF-8"); $query = "select word,book,sum(count) as co from word_in_book where \"word\" in (".$word_string.") group by book"; $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); echo "
"; if($iFetch>0){ for($i=0;$i<$iFetch;$i++){ $outXml = "

"; $word=$Fetch[$i]["word"]; //$outXml = $outXml."$word"; $bookid=$Fetch[$i]["book"]; $outXml = $outXml."".$book[$bookid]."-"; $outXml = $outXml."".$Fetch[$i]["co"].""; $outXml = $outXml."

"; echo $outXml; } } echo "
"; echo "
"; if($iFetch>0){ for($i=0;$i<$iFetch;$i++){ //遍历每一本书 获取段落号 $bookid=$Fetch[$i]["book"]; $db_file = "../appdata/palicanon/templet/".$bookid."_tpl.db3"; //open database PDO_Connect("sqlite:$db_file"); echo "
input:$org_word
"; $word_string="\"real\" ='".str_replace(",","' or \"real\" = '",$org_word); //echo $word_string; $word_string=mb_substr($word_string,0,-14,"UTF-8"); $query_pali="SELECT * FROM \"main\" WHERE ".$word_string ." group by paragraph"; echo $query_pali."
"; $Fetch_pali = PDO_FetchAll($query_pali); $iFetch_pali=count($Fetch_pali); echo "book:$bookid paragraph:".$iFetch_pali."
"; //var_dump($Fetch_pali); if($iFetch_pali>0){ $db_file = "../appdata/palicanon/pali_text/".$bookid."_pali.db3"; //open database PDO_Connect("sqlite:$db_file"); for($j=0;$j<$iFetch_pali;$j++){ echo "
par:".$Fetch_pali[$j]['paragraph']."
"; $query_pali_text="SELECT * FROM \"data\" WHERE paragraph=".$Fetch_pali[$j]['paragraph']; $par=$Fetch_pali[$j]['paragraph']; echo $query_pali_text."
"; $Fetch_pali_text = PDO_FetchAll($query_pali_text); $iFetch_pali_text=count($Fetch_pali_text); echo $iFetch_pali_text."
"; //var_dump($Fetch_pali); if($iFetch_pali_text>0){ for($k=0;$k<$iFetch_pali_text;$k++){ echo "
"; echo "
"; echo ""; echo "
".$Fetch_pali_text[$k]['book']."#".$module_gui_str['editor_palicannon']['1014']." ".$Fetch_pali_text[$k]['paragraph']." ".$module_gui_str['editor_project']['1043']."
"; echo "
"; $newText=str_replace($word,"$word",$Fetch_pali_text[$k]['vri_text']); echo "
".$newText."
"; echo "
"; echo "
"; } } //break; } } echo "
"; /* //获取段落号结束 $db_file = "../appdata/palicanon/pali_text/".$bookid."_pali.db3"; //open database PDO_Connect("sqlite:$db_file"); $query_pali="SELECT * FROM \"data\" WHERE \"text\" like '%".$word."%'"; echo $org_word; $word_string="\"text\" like '%".str_replace(",","%' or \"text\" like '%",$org_word); echo $word_string; $word_string=mb_substr($word_string,0,-18,"UTF-8"); $query_pali="SELECT * FROM \"data\" WHERE ".$word_string; echo $query_pali."
"; $Fetch_pali = PDO_FetchAll($query_pali); $iFetch_pali=count($Fetch_pali); echo $iFetch_pali."
"; //var_dump($Fetch_pali); if($iFetch_pali>0){ for($j=0;$j<$iFetch_pali;$j++){ echo "
"; echo "
"; echo "
".$book[$bookid]."
"; echo "
"."path>path ".$Fetch_pali[$j]['book']."第".$Fetch_pali[$j]['paragraph']."段"."
"; echo "
"; $newText=str_replace($word,"$word",$Fetch_pali[$j]['text']); echo "
".$newText."
"; echo "
"; } } */ } } echo "
"; break; } ?>