");
} else {
include $dir_language . "default.php";
}
$op = $_GET["op"];
$word = mb_strtolower($_GET["word"], 'UTF-8');
$org_word = $word;
$count_return = 0;
$dict_list = array();
global $PDO;
switch ($op) {
case "pre": //预查询
PDO_Connect(_FILE_DB_WORD_INDEX_);
echo "";
$query = "select word,count from wordindex where \"word_en\" like " . $PDO->quote($word . '%') . " OR \"word\" like " . $PDO->quote($word . '%') . " limit 0,50";
echo $query;
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
for ($i = 0; $i < $iFetch; $i++) {
$word = $Fetch[$i]["word"];
$count = $Fetch[$i]["count"];
echo "
";
}
}
echo "
字典 ";
//获取书名
$arrBookName = json_decode(file_get_contents("../public/book_name/sc.json"));
echo "";
//加语尾
$arrNewWord = array();
for ($row = 0; $row < count($case); $row++) {
$len = mb_strlen($case[$row][0], "UTF-8");
$end = mb_substr($word, 0 - $len, null, "UTF-8");
if ($end == $case[$row][0]) {
$newWord = mb_substr($word, 0, mb_strlen($word, "UTF-8") - $len, "UTF-8") . $case[$row][1];
$arrNewWord[$newWord] = 1;
}
}
//加连读词尾
$arrUnWord = array();
for ($row = 0; $row < count($union); $row++) {
$len = mb_strlen($union[$row][0], "UTF-8");
foreach ($arrNewWord as $x => $x_value) {
$end = mb_substr($x, 0 - $len, null, "UTF-8");
if ($end == $union[$row][0]) {
$newWord = mb_substr($x, 0, mb_strlen($x, "UTF-8") - $len, "UTF-8") . $union[$row][1];
$arrUnWord[$newWord] = 1;
}
}
}
//将连读词和$arrNewWord混合
foreach ($arrUnWord as $x => $x_value) {
$arrNewWord[$x] = 1;
}
if (count($arrNewWord) > 0) {
$strQueryWord = "(";
foreach ($arrNewWord as $x => $x_value) {
$strQueryWord .= "'{$x}',";
}
$strQueryWord = mb_substr($strQueryWord, 0, mb_strlen($strQueryWord, "UTF-8") - 1, "UTF-8");
$strQueryWord .= ")";
} else {
$strQueryWord = "('{$word}')";
}
//主显示区开始
echo "
";
//主显示区左侧开始
echo "
";
echo "
" . $module_gui_str['search']['1001'] . " ";
/*查找实际出现的拼写
*/
PDO_Connect(_FILE_DB_WORD_INDEX_);
$query = "select id,word,count from wordindex where \"word\" in $strQueryWord";
$arrRealWordList = PDO_FetchAll($query);
$countWord = count($arrRealWordList);
echo "$word
共{$countWord}单词符合
";
$strQueryWordId = "("; //实际出现的单词id查询字串
$aQueryWordList = array(); //id 为键 拼写为值的数组
$aShowWordList = array(); //拼写为键 个数为值的数组
$aShowWordIdList = array(); //拼写为键 值Id的数组
for ($i = 0; $i < $countWord; $i++) {
$value = $arrRealWordList[$i];
$strQueryWordId .= "'{$value["id"]}',";
$aQueryWordList["{$value["id"]}"] = $value["word"];
$aShowWordList[$value["word"]] = $value["count"];
$aShowWordIdList[$value["word"]] = $value["id"];
}
$strQueryWordId = mb_substr($strQueryWordId, 0, mb_strlen($strQueryWordId, "UTF-8") - 1, "UTF-8");
$strQueryWordId .= ")";
//显示单词列表
echo "
";
echo "
全选
";
arsort($aShowWordList);
$i = 0;
foreach ($aShowWordList as $x => $x_value) {
$wordid = $aShowWordIdList[$x];
echo "
";
echo "
";
echo $x . ":" . $x_value . " ";
$i++;
}
echo "
";
echo "
";
//查找这些词出现在哪些书中
PDO_Connect(_FILE_DB_BOOK_WORD_);
$query = "SELECT book,sum(count) as co FROM "._TABLE_BOOK_WORD_." WHERE \"wordindex\" IN $strQueryWordId GROUP BY book LIMIT 0,217";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
$aWordInBook = array();
foreach ($Fetch as $xBook) {
$aWordInBook["{$xBook["book"]}"] = $xBook["co"];
}
arsort($aWordInBook);
echo "
";
echo "出现在{$iFetch}本书中：
";
echo "
全选
";
$i = 0;
foreach ($aWordInBook as $x => $x_value) {
$book = $x;
$bookname = $arrBookName[$book - 1]->title;
echo "
";
echo "
";
echo "《{$bookname}》:{$x_value}次 ";
$i++;
}
echo "
";
echo "
";
}
//查找这些词出现在哪些书中结束
echo "
";
//黑体字主显示区左侧结束
//黑体字主显示区右侧开始
echo "
";
//前20条记录
PDO_Connect(_FILE_DB_WORD_INDEX_);
$query = "SELECT book,paragraph, wordindex FROM word WHERE \"wordindex\" in $strQueryWordId LIMIT 0,20";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
PDO_Connect(_FILE_DB_PALITEXT_);
for ($i = 0; $i < $iFetch; $i++) {
$paliwordid = $Fetch[$i]["wordindex"];
$paliword = $aQueryWordList["{$paliwordid}"];
$book = $Fetch[$i]["book"];
$paragraph = $Fetch[$i]["paragraph"];
$bookname = $arrBookName[$book - 1]->title;
$c1 = $arrBookName[$book - 1]->c1;
echo "
";
echo "
《{$bookname}》 $c1
";
echo "
$paliword
";
{
$query = "select * from vri_text where \"book\" = '{$book}' and \"paragraph\" = '{$paragraph}' limit 0,1";
$FetchPaliText = PDO_FetchAll($query);
$countPaliText = count($FetchPaliText);
if ($countPaliText > 0) {
for ($iPali = 0; $iPali < $countPaliText; $iPali++) {
if (substr($paliword, -1) == "n") {
$paliword = substr($paliword, 0, -1);
}
$light_text = str_replace($paliword, "
{$paliword} ", $FetchPaliText[$iPali]["vri_text"]);
echo "
{$light_text}
";
}
}
}
echo "
";
}
}
echo "
";
//黑体字主显示区右侧结束
echo "
";
//黑体字主显示区结束
echo "
$strDictTab
";
break;
case "update":
$target = $_GET["target"];
switch ($target) {
case "bold";
$arrBookName = json_decode(file_get_contents("../public/book_name/sc.json"));
$arrBookType = json_decode(file_get_contents("../public/book_name/booktype.json"));
PDO_Connect(_FILE_DB_BOOK_WORD_);
$wordlist = $_GET["wordlist"];
$booklist = $_GET["booklist"];
$aBookList = ltrim($booklist, "(");
$aBookList = rtrim($aBookList, ")");
$aBookList = str_replace("'", "", $aBookList);
$aBookList = str_getcsv($aBookList);
foreach ($aBookList as $oneBook) {
$aInputBook["{$oneBook}"] = 1;
}
//查找这些词出现在哪些书中
$query = "SELECT book,sum(count) as co from "._TABLE_BOOK_WORD_." where \"wordindex\" in $wordlist group by book order by co DESC";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
$booktypesum["vinaya"] = array(0, 0);
$booktypesum["sutta"] = array(0, 0);
$booktypesum["abhidhamma"] = array(0, 0);
$booktypesum["anna"] = array(0, 0);
$booktypesum["mula"] = array(0, 0);
$booktypesum["atthakattha"] = array(0, 0);
$booktypesum["tika"] = array(0, 0);
$booktypesum["anna2"] = array(0, 0);
for ($i = 0; $i < $iFetch; $i++) {
$book = $Fetch[$i]["book"];
$sum = $Fetch[$i]["co"];
$t1 = $arrBookType[$book - 1]->c1;
$t2 = $arrBookType[$book - 1]->c2;
if (isset($booktypesum[$t1])) {
$booktypesum[$t1][0]++;
$booktypesum[$t1][1] += $sum;
} else {
$booktypesum[$t1][0] = 1;
$booktypesum[$t1][1] = $sum;
}
if (isset($booktypesum[$t2])) {
$booktypesum[$t2][0]++;
$booktypesum[$t2][1] += $sum;
} else {
$booktypesum[$t2][0] = 1;
$booktypesum[$t2][1] = $sum;
}
}
echo "";
}
//查找这些词出现在哪些书中结束
//前20条记录
PDO_Connect(_FILE_DB_WORD_INDEX_);
$query = "select * from word where \"wordindex\" in $wordlist and \"book\" in $booklist group by book,paragraph limit 0,20";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
PDO_Connect(_FILE_DB_PALITEXT_);
for ($i = 0; $i < $iFetch; $i++) {
$paliword = $Fetch[$i]["wordindex"];
$book = $Fetch[$i]["book"];
$bookname = $arrBookName[$book - 1]->title;
$c1 = $arrBookName[$book - 1]->c1;
$c2 = $arrBookName[$book - 1]->c2;
$paragraph = $Fetch[$i]["paragraph"];
echo "";
echo "
《{$bookname}》 $c1 $c2
";
echo "
$paliword
";
$query = "select * from vri_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++) {
if (substr($paliword, -1) == "n") {
$paliword = substr($paliword, 0, -1);
}
$light_text = str_replace($paliword, "
{$paliword} ", $FetchPaliText[$iPali]["vri_text"]);
echo "
{$light_text}
";
}
}
echo "