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("$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("$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("$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; }