redis_pm_part.php 770 B

123456789101112131415161718192021222324252627
  1. <?php
  2. require_once __DIR__."/../config.php";
  3. require_once __DIR__."/../redis/function.php";
  4. echo 'discard';
  5. return;
  6. if (PHP_SAPI == "cli") {
  7. $redis = redis_connect();
  8. if ($redis != false) {
  9. $dbh = new PDO(_DICT_DB_PM_, Database["user"], Database["password"], array(PDO::ATTR_PERSISTENT => true));
  10. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  11. $query = "SELECT pali,parts from "._TABLE_DICT_PM_." group by pali";
  12. $stmt = $dbh->query($query);
  13. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  14. # code...
  15. if(!empty($row["parts"])){
  16. $redis->hSet("dict://pm/part",$row["pali"],$row["parts"]);
  17. }
  18. }
  19. fwrite(STDOUT, "all done ".$redis->hLen("dict://pm/part").PHP_EOL);
  20. }else{
  21. fwrite(STDERR,"redis connect is fail".PHP_EOL);
  22. }
  23. }
  24. ?>