dict_lookup_pre.php 1.0 KB

12345678910111213141516171819202122232425262728293031323334
  1. <?php
  2. //查询参考字典
  3. require_once '../path.php';
  4. require_once '../public/_pdo.php';
  5. PDO_Connect("" . _FILE_DB_REF_INDEX_);
  6. if (isset($_GET["word"])) {
  7. $word = $_GET["word"];
  8. } else {
  9. echo json_encode(array(), JSON_UNESCAPED_UNICODE);
  10. exit;
  11. }
  12. $query = "SELECT word,count from " . _TABLE_REF_INDEX_ . " where eword like ? OR word like ? limit 0,20";
  13. $Fetch = PDO_FetchAll($query, array($word . '%', $word . '%'));
  14. PDO_Connect(_FILE_DB_REF_, _DB_USERNAME_, _DB_PASSWORD_);
  15. $query = "SELECT mean from " . _TABLE_DICT_REF_ . " where word = ? and language = ? limit 0,1";
  16. foreach ($Fetch as $key => $value) {
  17. # code...
  18. $mean = PDO_FetchRow($query, array($value["word"], "zh"));
  19. if ($mean) {
  20. $Fetch[$key]["mean"] = $mean["mean"];
  21. } else {
  22. $mean = PDO_FetchRow($query, array($value["word"], "en"));
  23. if ($mean) {
  24. $Fetch[$key]["mean"] = $mean["mean"];
  25. } else {
  26. $Fetch[$key]["mean"] = "";
  27. }
  28. }
  29. }
  30. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);