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 dict where \"pali\"='" . $wordlist[$x] . "' ORDER BY rowid DESC "; $Fetch = PDO_FetchAll($query); $iFetch = count($Fetch); if ($iFetch > 0) { for ($i = 0; $i < $iFetch; $i++) { $outXml = $outXml . ""; $outXml = $outXml . "" . $wordlist[$x] . ""; $outXml = $outXml . "" . $Fetch[$i]["type"] . ""; $outXml = $outXml . "" . $Fetch[$i]["gramma"] . ""; $outXml = $outXml . "" . $Fetch[$i]["parent"] . ""; $outXml = $outXml . "" . $Fetch[$i]["mean"] . ""; $outXml = $outXml . "" . $Fetch[$i]["factors"] . ""; $outXml = $outXml . "" . $Fetch[$i]["factormean"] . ""; $outXml = $outXml . ""; } } /*直接查询结束*/ /*全部查询结束*/ } } $outXml = $outXml . ""; echo $outXml;