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;$i1){ //先直接查,查不到再用语尾表查 $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; ?>