redis_sys_rgl_part.php 802 B

123456789101112131415161718192021222324
  1. <?php
  2. require_once __DIR__."/../config.php";
  3. require_once __DIR__."/../redis/function.php";
  4. if (PHP_SAPI == "cli" || isset($_COOKIE["userid"]))
  5. {
  6. $redis = redis_connect();
  7. if ($redis != false) {
  8. $dbh = new PDO(_DICT_DB_REGULAR_, Database["user"], Database["password"], array(PDO::ATTR_PERSISTENT => true));
  9. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  10. $query = "SELECT * from (SELECT pali,parts from "._TABLE_DICT_REGULAR_." order by confidence DESC ) group by pali";
  11. $stmt = $dbh->query($query);
  12. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  13. # code...
  14. $redis->hSet("dict://regular/part",$row["pali"],$row["parts"]);
  15. }
  16. fwrite(STDOUT, "all done ".$redis->hLen("dict://regular/part").PHP_EOL);
  17. }else{
  18. fwrite(STDERR,"redis connect is fail".PHP_EOL);
  19. }
  20. }
  21. ?>