redis_comp_part.php 910 B

123456789101112131415161718192021222324252627
  1. <?php
  2. #从自动复合词数据库中提取数据到ridis
  3. #已经废弃
  4. require_once "../config.php";
  5. require_once "../redis/function.php";
  6. if (PHP_SAPI == "cli") {
  7. $redis = redis_connect();
  8. if ($redis != false) {
  9. $dbh = new PDO(_DICT_DB_COMP_, "", "", array(PDO::ATTR_PERSISTENT => true));
  10. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  11. $query = "SELECT pali from "._TABLE_DICT_COMP_." where 1 group by pali";
  12. $stmt = $dbh->query($query);
  13. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  14. # code...
  15. $query = "SELECT parts as word from "._TABLE_DICT_COMP_." where pali=?";
  16. $stmtOne = $dbh->query($query);
  17. $stmtOne->execute(array($row["pali"]));
  18. $fComp = $stmtOne->fetchAll(PDO::FETCH_ASSOC);
  19. $output = json_encode(array($fComp), JSON_UNESCAPED_UNICODE);
  20. $redis->hSet("dict://comp",$row["pali"],$output);
  21. }
  22. }
  23. echo "all done".$redis->hLen("dict://comp");
  24. }
  25. ?>