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"]; array_push($newBookList, array($book, $sum)); $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 "
"; echo "出现在{$iFetch}本书中:
"; echo "全选
"; echo "律藏-{$booktypesum["vinaya"][0]}-{$booktypesum["vinaya"][1]}
"; echo "经藏-{$booktypesum["sutta"][0]}-{$booktypesum["sutta"][1]}
"; echo "阿毗达摩藏-{$booktypesum["abhidhamma"][0]}-{$booktypesum["abhidhamma"][1]}
"; echo "其他-{$booktypesum["anna"][0]}-{$booktypesum["anna"][1]}

"; echo "根本-{$booktypesum["mula"][0]}-{$booktypesum["mula"][1]}
"; echo "义注-{$booktypesum["atthakattha"][0]}-{$booktypesum["atthakattha"][1]}
"; echo "复注-{$booktypesum["tika"][0]}-{$booktypesum["tika"][1]}
"; echo "其他-{$booktypesum["anna2"][0]}-{$booktypesum["anna2"][1]}

"; echo "
"; for ($i = 0; $i < $iFetch; $i++) { $book = $Fetch[$i]["book"]; $bookname = _get_book_info($book)->title; if (isset($booklist)) { if (isset($aInputBook["{$book}"])) { $bookcheck = "checked"; } else { $bookcheck = ""; } } else { $bookcheck = "checked"; } $t1 = $arrBookType[$book - 1]->c1; $t2 = $arrBookType[$book - 1]->c2; echo "
"; echo "
"; } echo ""; echo "
"; } return ($newBookList); //查找这些词出现在哪些书中结束 } switch ($op) { case "pre": //预查询 { $time_start = microtime_float(); $searching = $arrWordList[count($arrWordList) - 1]; PDO_Connect( _FILE_DB_RESRES_INDEX_); if (count($arrWordList) > 1) { echo "
"; foreach ($arrWordList as $oneword) { echo $oneword . "+"; } echo "
"; } $query = "SELECT title from \""._TABLE_RES_INDEX_."\" where (title_en like " . $PDO->quote("%" . $searching . '%') . " OR title like " . $PDO->quote("%" . $searching . '%') . ") group by title limit 20"; $Fetch = PDO_FetchAll($query); $queryTime = (microtime_float() - $time_start) * 1000; $iFetch = count($Fetch); if ($iFetch > 0) { for ($i = 0; $i < $iFetch; $i++) { $word = $Fetch[$i]["title"]; echo "$word"; } } break; } case "search": { $time_start = microtime_float(); echo "
"; //主显示区开始 echo "
"; //主显示区左侧开始 echo "
"; echo ""; $queryTime = (microtime_float() - $time_start) * 1000; echo "
"; //查找这些词出现在哪些书中 echo "
"; $booklist = render_book_list($_GET["word"]); echo "
"; $wordInBookCounter = 0; $strFirstBookList = "("; foreach ($booklist as $onebook) { $wordInBookCounter += $onebook[1]; $strFirstBookList .= "'" . $onebook[0] . "',"; if ($wordInBookCounter >= 20) { break; } } $strFirstBookList = mb_substr($strFirstBookList, 0, mb_strlen($strFirstBookList, "UTF-8") - 1, "UTF-8"); $strFirstBookList .= ")"; echo "
"; //黑体字主显示区左侧结束 //黑体字主显示区右侧开始 echo "
"; //前20条记录 $time_start = microtime_float(); PDO_Connect( _FILE_DB_RESRES_INDEX_); if (isset($_GET["booklist"])) { $query = "SELECT * from \""._TABLE_RES_INDEX_."\" where (title_en like " . $PDO->quote("%" . $_GET["word"] . '%') . " OR title like " . $PDO->quote("%" . $_GET["word"] . '%') . ") and book in {$_GET["booklist"]} limit 50"; } else { $query = "SELECT * from \""._TABLE_RES_INDEX_."\" where title_en like " . $PDO->quote("%" . $_GET["word"] . '%') . " OR title like " . $PDO->quote("%" . $_GET["word"] . '%') . " limit 50"; } $Fetch = PDO_FetchAll($query); $queryTime = (microtime_float() - $time_start) * 1000; $iFetch = count($Fetch); if ($iFetch > 0) { PDO_Connect( _FILE_DB_PALITEXT_); for ($i = 0; $i < $iFetch; $i++) { $title = $Fetch[$i]["title"]; $book = $Fetch[$i]["book"]; $paragraph = $Fetch[$i]["paragraph"]; echo "
"; echo "
$title
"; $bookInfo = _get_book_info($book); $bookname = $bookInfo->title; $c1 = $bookInfo->c1; $c2 = $bookInfo->c2; $c3 = $bookInfo->c3; $path_1 = $c1 . ">"; if ($c2 !== "") { $path_1 = $path_1 . $c2 . ">"; } if ($c3 !== "") { $path_1 = $path_1 . $c3 . ">"; } $path_1 = $path_1 . "《{$bookname}》>"; $path = _get_para_path($book, $paragraph); echo $path_1 . $path; $query = "select chapter_len from "._TABLE_PALI_TEXT_." where book = ? and paragraph = ? limit 1"; $chapter_len = PDO_FetchAll($query,array($book,$paragraph)); $chapter_len = $chapter_len[0]["chapter_len"]; $query = "select text from "._TABLE_PALI_TEXT_." where book = ? and (paragraph > ? and paragraph <= ?) limit 3"; $FetchPaliText = PDO_FetchAll($query,array($book,$paragraph,($paragraph + $chapter_len))); $paliContent = ""; foreach ($FetchPaliText as $text) { $paliContent .= $text["text"]; } $paliContent = mb_substr($paliContent, 0, 200, "UTF-8"); echo "
{$paliContent}
"; echo "
"; echo "
"; } } $queryTime = (microtime_float() - $time_start) * 1000; echo "
搜索时间:$queryTime
"; echo "
"; //黑体字主显示区右侧结束 echo "
"; echo "
"; echo "
"; //黑体字主显示区结束 echo "
"; //查黑体字结束 echo "
"; break; } case "update": $target = $_GET["target"]; switch ($target) { case "bold"; $wordlist = $_GET["wordlist"]; $booklist = $_GET["booklist"]; $aBookList = ltrim($booklist, "("); $aBookList = rtrim($aBookList, ")"); $aBookList = str_replace("'", "", $aBookList); $aBookList = str_getcsv($aBookList); $arrBookType = json_decode(file_get_contents("../public/book_name/booktype.json")); //查找这些词出现在哪些书中 $newBookList = render_book_list($wordlist, $aBookList); //前20条记录 $time_start = microtime_float(); PDO_Connect(_FILE_DB_PALI_INDEX_); $query = "SELECT * from "._TABLE_WORD_." where \"wordindex\" in $wordlist and \"book\" in $booklist group by book,paragraph limit 20"; $Fetch = PDO_FetchAll($query); //echo "
$query
"; $queryTime = (microtime_float() - $time_start) * 1000; echo "
搜索时间:$queryTime
"; $iFetch = count($Fetch); if ($iFetch > 0) { PDO_Connect(_FILE_DB_PALITEXT_); for ($i = 0; $i < $iFetch; $i++) { $paliword = $Fetch[$i]["wordindex"]; //$paliword=$wordlist["{$paliwordid}"]; $book = $Fetch[$i]["book"]; $bookInfo = _get_book_info($book); $bookname = $bookInfo->title; $c1 = $bookInfo->c1; $c2 = $bookInfo->c2; $c3 = $bookInfo->c3; $paragraph = $Fetch[$i]["paragraph"]; $path_1 = $c1 . ">"; if ($c2 !== "") { $path_1 = $path_1 . $c2 . ">"; } if ($c3 !== "") { $path_1 = $path_1 . $c3 . ">"; } $path_1 = $path_1 . "《{$bookname}》>"; echo "
"; echo "
《{$bookname}》 $c1 $c2
"; echo "
$paliword
"; $query = "SELECT * from "._TABLE_PALI_TEXT_." where book = ? and paragraph = ? limit 20"; $FetchPaliText = PDO_FetchAll($query,array($book,$paragraph)); $countPaliText = count($FetchPaliText); if ($countPaliText > 0) { for ($iPali = 0; $iPali < $countPaliText; $iPali++) { $path = ""; $parent = $FetchPaliText[0]["parent"]; $deep = 0; $sFirstParentTitle = ""; while ($parent > -1) { $query = "SELECT * from "._TABLE_PALI_TEXT_." where book = ? and paragraph = ? limit 1"; $FetParent = PDO_FetchAll($query,array($book,$parent)); if ($sFirstParentTitle == "") { $sFirstParentTitle = $FetParent[0]["toc"]; } $path = "{$FetParent[0]["toc"]}>{$path}"; $parent = $FetParent[0]["parent"]; $deep++; if ($deep > 5) { break; } } $path = $path_1 . $path . "No. " . $paragraph; echo "
$path
"; //echo "
$paliword
"; if (substr($paliword, -1) == "n") { $paliword = substr($paliword, 0, -1); } $light_text = str_replace($paliword, "{$paliword}", $FetchPaliText[$iPali]["html"]); echo "
{$light_text}
"; echo "
"; } } echo "
"; } } break; } break; }