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 "
" . $book[$bookid] . "
";
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;
}