";
$query = "select word,count from dict where \"eword\" like " . $PDO->quote($word . '%') . " OR \"word\" like " . $PDO->quote($word . '%') . " limit 0,100";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
for ($i = 0; $i < $iFetch; $i++) {
$outXml = "";
$word = $Fetch[$i]["word"];
$outXml = $outXml . "$word";
$outXml = $outXml . "" . $Fetch[$i]["count"] . "";
$outXml = $outXml . "";
echo $outXml;
}
}
echo "";
break;
case "my":
$query = "select guid,word,meaning,other_meaning from term where owner= " . $PDO->quote($username);
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
}
break;
case "allpali":
$query = "select word from term where 1 group by word";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
}
break;
case "allmean":
$query = "select meaning from term where \"word\" = " . $PDO->quote($word) . " group by meaning";
$Fetch = PDO_FetchAll($query);
foreach ($Fetch as $one) {
echo "" . $one["meaning"] . " ";
}
//echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
break;
case "load_id":
if (isset($_GET["id"])) {
$id = $_GET["id"];
$query = "select * from term where \"guid\" = " . $PDO->quote($id);
$Fetch = PDO_FetchAll($query);
echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
} else {
echo "{}";
}
break;
case "search":
//查本人数据
echo "" . $module_gui_str['editor']['1122'] . "
"; //My Term
$query = "select * from term where \"word\" = " . $PDO->quote($word) . " AND \"owner\"= " . $PDO->quote($username) . " limit 0,30";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
$count_return += $iFetch;
if ($iFetch > 0) {
for ($i = 0; $i < $iFetch; $i++) {
$mean = $Fetch[$i]["meaning"];
$guid = $Fetch[$i]["guid"];
$dict_list[$guid] = $Fetch[$i]["owner"];
echo "";
echo "
";
echo "
$word
";
echo "
";
echo "
" . $mean . "
";
echo "
" . $Fetch[$i]["other_meaning"] . "
";
echo "
" . $Fetch[$i]["note"] . "
";
echo "
";
//编辑词条表单
echo "
";
echo "
";
echo "
"; //'意思'
echo "
"; //'备选意思（可选项）'
echo "
"; //'注解'
echo "
";
echo "
";
echo ""; //Apply
echo ""; //Edit
echo "
";
echo "
";
echo ""; //Cancel
echo ""; //保存
echo "
";
echo "
";
echo "
" . $_local->gui->new_technic_term . "
"; //New Techinc Term
echo "
";
echo "" . $_local->gui->spell . "：";
echo "";
echo "
"; //'拼写'
echo "
";
echo "" . $_local->gui->g_mean . "：";
echo "";
echo "
"; //'意思'
echo "
";
echo "" . $_local->gui->other_meaning . "：";
echo "";
echo "
"; //'备选意思（可选项）'
echo "
";
echo "" . $_local->gui->tag . "：";
echo "";
echo "
"; //'标签'
echo "
";
echo "" . $_local->gui->note . "：";
echo "";
echo "
"; //'注解'
echo "
"; //保存
echo "
";
echo "
";
echo "
" . $Fetch[$i]["owner"] . "
";
echo "
" . $mean . "
";
echo "
" . $Fetch[$i]["other_meaning"] . "
";
echo "
" . $Fetch[$i]["note"] . "
";
echo "
"; //复制
echo "
";
$query = "select * from term where \"meaning\" like " . $PDO->quote($word) . " limit 0,30";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
$count_return += $iFetch;
if ($iFetch > 0) {
for ($i = 0; $i < $iFetch; $i++) {
$mean = $Fetch[$i]["meaning"];
$pos = mb_stripos($mean, $word, 0, "UTF-8");
if ($pos) {
if ($pos > 20) {
$start = $pos - 20;
} else {
$start = 0;
}
$newmean = mb_substr($mean, $start, 100, "UTF-8");
} else {
$newmean = $mean;
}
$pos = mb_stripos($newmean, $word1, 0, "UTF-8");
$head = mb_substr($newmean, 0, $pos, "UTF-8");
$mid = mb_substr($newmean, $pos, mb_strlen($word1, "UTF-8"), "UTF-8");
$end = mb_substr($newmean, $pos + mb_strlen($word1, "UTF-8"), null, "UTF-8");
$heigh_light_mean = "$head$mid$end";
$outXml = "";
$outXml = $outXml . "
" . $Fetch[$i]["owner"] . "
";
$outXml = $outXml . "
" . $Fetch[$i]["word"] . "
";
$outXml = $outXml . "
" . $heigh_light_mean . "
";
$outXml = $outXml . "
{$Fetch[$i]["note"]}
";
$outXml = $outXml . "
";
foreach ($dict_list as $x => $x_value) {
echo "
$x_value";
}
echo "
";
} else {
echo "updata ok.";
}
}
break;
case "extract":
$query = "select * from term where \"guid\" in ($list) limit 0,1000";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
}
break;
}