mint/app/studio/dict_find2.php

<?php
require 'checklogin.inc';
include "./config.php";
include "./_pdo.php";

$countInsert=0;
$wordlist=array();
$tempFile="temp.txt";


//$input = file_get_contents("php://input"); //
//$inputWordList=explode("$",$input);
$arrlength=0;/*size of word list*/
//$dictType=$inputWordList[0];
//$dictFileName=$inputWordList[1];
//$parentLevel=$inputWordList[2];
$dictType=$_POST["type"];
$dictFileName=$_POST["filename"];
$parentLevel=$_POST["level"];
$wordlist=json_decode($_POST["data"],false);


switch($dictType){
	case "user":
		$dictDir=$dir_user_base.$userid.$dir_dict_user.'/';
		break;
	case "sys":
		$dictDir=$dir_dict_system;
		break;
	case "third":
		$dictDir=$dir_dict_3rd;
		break;
}

if($dictFileName=="wbw"){
	$dictFileName=$file_dict_wbw_default;
}
if($dictFileName=="user_default"){
	$dictFileName=$file_dict_user_default;
}
/*
for($i=3;$i<count($inputWordList);$i++){
	if(!empty($inputWordList[$i])){
		$words[$inputWordList[$i]]=1;
	}
}
foreach($words as $word=>$value){
$wordlist[$arrlength]=$word;
$arrlength++;
}
*/
$arrlength=count($wordlist);

echo "<wordlist>";

$db_path=$dictDir;
$db_file = $db_path.$dictFileName;

//open database
PDO_Connect("sqlite:$db_file");
global $PDO;
for($x=0;$x<$arrlength;$x++){
	if(mb_strlen($wordlist[$x]->word)>1){
		//直接查
		if($dictFileName=="wbw"){
			if($wordlist[$x]->level==1){
				$query = "select * from dict where \"type\"<> \"pali\"=".$PDO->quote($wordlist[$x]->word)."  AND ( type <> '.n.' AND  type <> '.ti.' AND  type <> '.adj.'  AND  type <> '.pron.'  AND  type <> '.v.' )   ORDER BY rowid DESC";
			}
			else{
				$query = "select * from dict where \"pali\"=".$PDO->quote($wordlist[$x]->word)." ORDER BY rowid DESC";
			}
		}
		else{
			if($wordlist[$x]->level==1){
				$query = "select * from dict where \"pali\"=".$PDO->quote($wordlist[$x]->word)."  AND ( type <> '.n.' AND  type <> '.ti.' AND  type <> '.adj.'  AND  type <> '.pron.'  AND  type <> '.v.' )";
			}
			else{
				$query = "select * from dict where \"pali\"=".$PDO->quote($wordlist[$x]->word)."";
			}
		}

		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		if($iFetch>0){
			for($i=0;$i<$iFetch;$i++){
				$outXml = "<word>";
				$outXml .= "<id>".$Fetch[$i]["id"]."</id>";
				if(isset($Fetch[$i]["guid"])){$outXml .= "<guid>".$Fetch[$i]["guid"]."</guid>";}else{$outXml .= "<guid></guid>";}
				$outXml .= "<pali>".$Fetch[$i]["pali"]."</pali>";
				$outXml .= "<type>".$Fetch[$i]["type"]."</type>";
				$outXml .= "<gramma>".$Fetch[$i]["gramma"]."</gramma>";
				$outXml .= "<parent>".$Fetch[$i]["parent"]."</parent>";
				$outXml .= "<mean>".$Fetch[$i]["mean"]."</mean>";
				$outXml .= "<factors>".$Fetch[$i]["factors"]."</factors>";
				if(isset($Fetch[$i]["part_id"])){$outXml .= "<part_id>".$Fetch[$i]["part_id"]."</part_id>";}else{$outXml .= "<part_id></part_id>";}
				$outXml .= "<factormean>".$Fetch[$i]["factormean"]."</factormean>";
				if(isset($Fetch[$i]["note"])){
					$outXml .= "<note>".$Fetch[$i]["note"]."</note>";
				}
				else{
					$outXml .= "<note></note>";
				}
				if(isset($Fetch[$i]["status"])){
					$outXml .= "<status>".$Fetch[$i]["status"]."</status>";
				}
				else{
					$outXml .= "<status>256</status>";
				}
				if(isset($Fetch[$i]["enable"])){
					$outXml .= "<enable>".$Fetch[$i]["enable"]."</enable>";
				}
				else{
					$outXml .= "<enable>TURE</enable>";
				}

				if(isset($Fetch[$i]["dict_name"])){
					$outXml .= "<dict_name>".$Fetch[$i]["dict_name"]."</dict_name>";
				}
				else{
					$outXml .= "<dict_name>unkow</dict_name>";
				}

				if(isset($Fetch[$i]["language"])){
					$outXml .= "<language>".$Fetch[$i]["language"]."</language>";
				}
				else{
					$outXml .= "<language>en</language>";
				}

				if(isset($Fetch[$i]["time"])){
					$outXml .= "<time>".$Fetch[$i]["time"]."</time>";
				}
				else{
					$outXml .= "<time>0</time>";
				}				
				$outXml .= "</word>";
				echo $outXml;
			}
		}
/*直接查询结束*/

	}
}

$outXml = "</wordlist>";
echo $outXml;
//fwrite($fpTemp, $outXml);
//fclose($fpTemp);

//$fpTemp = fopen($tempFile, "r") or die("Unable to open file!");
//$tempText = fread($fpTemp,filesize($tempFile));
//fclose($fpTemp);

//echo $tempText;
?>