0) { $bookid = 'p' . $data[2]; $toc_book[$bookid] = $data[1]; } } } echo "

Word Analysis

"; if (!isset($_GET["col"])) { ?> 返回
"; echo "您选择的是：
"; $boolList = array(); for ($i = 1; $i < 218; $i++) { if (isset($_GET["p$i"])) { if ($_GET["p$i"] == "on") { array_push($boolList, "p$i"); echo $toc_book["p$i"] . "; "; } } } echo "
"; $countInsert = 0; $wordlist = array(); $bookstring = ""; for ($i = 0; $i < count($boolList); $i++) { $bookstring .= "'" . $boolList[$i] . "'"; if ($i < count($boolList) - 1) { $bookstring .= ","; } } //open database PDO_Connect(_FILE_DB_STATISTICS_); if ($col == "parent") { $query = "SELECT count(*) FROM "._TABLE_WORD_STATISTICS_." WHERE (bookid in (" . $bookstring . ")) "; /*查總數，并分類匯總*/ $count_word = PDO_FetchOne($query); $query = "SELECT sum(count) FROM "._TABLE_WORD_STATISTICS_." WHERE (bookid in (" . $bookstring . ")) "; /*查總數，并分類匯總*/ $sum_word = PDO_FetchOne($query); $query = "select count(*) from (SELECT count() FROM "._TABLE_WORD_STATISTICS_." WHERE (bookid in (" . $bookstring . ") and parent<>'') group by parent )"; /*查總數，并分類匯總*/ $count_parent = PDO_FetchOne($query); $query = "SELECT sum(count) FROM "._TABLE_WORD_STATISTICS_." WHERE (bookid in (" . $bookstring . ") and parent<>'') "; /*查總數，并分類匯總*/ $sum_parent = PDO_FetchOne($query); echo "单词个数： $count_word
总词数： $sum_word
parent个数： $count_parent
有parent的单词总数:$sum_parent
"; $query = "select * from (SELECT parent,sum(count) as wordsum FROM "._TABLE_WORD_STATISTICS_." WHERE (bookid in (" . $bookstring . ") and parent<>'') group by parent) order by wordsum DESC limit 0 ,2000"; /*查總數，并分類匯總*/ $Fetch = PDO_FetchAll($query); $iFetch = count($Fetch); echo ""; echo ""; $sum_prsent = 0; if ($iFetch > 0) { $sum = $Fetch[0]["wordsum"]; $first = $sum * 100 / $sum_word; for ($i = 0; $i < $iFetch; $i++) { $sum = $Fetch[$i]["wordsum"]; $prsent = $sum * 100 / $sum_word; $prsent1 = $prsent * 100 / $first; $sum_prsent += $prsent; echo ""; echo ""; echo ""; } } echo "

序号	parent	数量	百分比	累计百分比
" . ($i + 1) . "	" . $Fetch[$i]["parent"] . "	" . $sum . "	" . $prsent . "	" . $sum_prsent . "

"; } else { } /*查询结束*/ ?>