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