xpath('//word'); /*prepare words from xmldoc and remove same words*/ foreach ($wordsSutta as $ws) { $pali = $ws->pali; $arrlength = count($wordlist); $found = false; for ($x = 0; $x < $arrlength; $x++) { if (strcmp($pali, $wordlist[$x]) == 0) { $found = true; break; } } if (!$found) { $srcWord = str_replace("-", "", lcfirst($pali)); $srcWord = str_replace("’", "", lcfirst($pali)); $srcWord = str_replace(".", "", lcfirst($pali)); $srcWord = str_replace("ŋ", "ṃ", lcfirst($pali)); $wordlist[$countInsert] = str_replace("-", "", lcfirst($pali)); /*首字符转为小写 first letter convert to lowercase */ $countInsert++; } } $arrlength = count($wordlist); /*size of word list*/ break; case "word": $wordlist[0] = $word; $arrlength = 1; break; case "words": break; default: } /* prepare case ending table in the csv file,one record have one kinds of case so we combine the same form of case ending */ $caseRowCounter = 0; $casetable = array(); if (($handle = fopen('caseend.csv', 'r')) !== false) { while (($data = fgetcsv($handle, 0, ',')) !== false) { $find = false; for ($i = 0; $i < count($casetable); $i++) { if ($casetable[$i][0] == $data[0] && $casetable[$i][1] == $data[1]) { $casetable[$i][2] = $casetable[$i][2] . "$" . $data[2]; $find = true; break; } } if ($find == false) { $casetable[$caseRowCounter] = $data; $caseRowCounter++; } } } $outXml = ""; $db_path = "dict/"; $db_file = $db_path . $dictFileName; //open database PDO_Connect("$db_file"); for ($x = 0; $x < $arrlength; $x++) { if (mb_strlen($wordlist[$x]) > 1) { //先直接查，查不到再用语尾表查 $query = "select * from tptdict where \"word\"='" . $wordlist[$x] . "' ORDER BY rowid DESC "; $Fetch = PDO_FetchAll($query); $iFetch = count($Fetch); if ($iFetch > 0) { for ($i = 0; $i < $iFetch; $i++) { if (strcmp($Fetch[$i]["org"], '?') == 0 && strcmp($Fetch[$i]["mean"], '?') == 0 && strcmp($Fetch[$i]["gramma"], '?') == 0) { continue; } $outXml = $outXml . ""; $outXml = $outXml . "" . $wordlist[$x] . ""; $outXml = $outXml . "" . $Fetch[$i]["org"] . ""; $outXml = $outXml . "" . $Fetch[$i]["mean"] . ""; $outXml = $outXml . "" . $Fetch[$i]["gramma"] . ""; $outXml = $outXml . ""; } } /*直接查询结束*/ else { /*没查到，用语尾表查*/ for ($iCase = 0; $iCase < count($casetable); $iCase++) { if (substr($wordlist[$x], 0 - strlen($casetable[$iCase][0])) == $casetable[$iCase][0]) { $pali = substr($wordlist[$x], 0, strlen($wordlist[$x]) - strlen($casetable[$iCase][0])); $pali = $pali . $casetable[$iCase][1]; $query = "select * from tptdict where \"word\"='" . $pali . "' ORDER BY rowid DESC "; $Fetch = PDO_FetchAll($query); $iFetch = count($Fetch); if ($iFetch > 0) { for ($i = 0; $i < $iFetch; $i++) { if (strcmp($Fetch[$i]["org"], '?') == 0 && strcmp($Fetch[$i]["mean"], '?') == 0 && strcmp($Fetch[$i]["gramma"], '?') == 0) { continue; } $outXml = $outXml . ""; $outXml = $outXml . "" . $wordlist[$x] . ""; $outXml = $outXml . "" . $Fetch[$i]["word"] . "@" . $casetable[$iCase][0] . "$" . $Fetch[$i]["org"] . ""; $outXml = $outXml . "" . $Fetch[$i]["mean"] . ""; $outXml = $outXml . "" . $Fetch[$i]["gramma"] . "$" . $casetable[$iCase][2] . ""; $outXml = $outXml . ""; } } } } } /*全部查询结束*/ } } $outXml = $outXml . ""; echo $outXml;