redis_ref_with_mean.php 692 B

12345678910111213141516171819202122
  1. <?php
  2. require_once __DIR__."/../config.php";
  3. require_once __DIR__."/../redis/function.php";
  4. if (PHP_SAPI == "cli") {
  5. $redis = redis_connect();
  6. if ($redis != false) {
  7. $dns = _FILE_DB_REF_;
  8. $dbh = new PDO($dns, "", "", array(PDO::ATTR_PERSISTENT => true));
  9. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  10. $query = "SELECT word from "._TABLE_DICT_REF_." where dict_id in (3,4,6,7,8,10,12,13,15,18,19,21,22,23,24) group by word";
  11. $stmt = $dbh->query($query);
  12. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  13. # code...
  14. $redis->hSet("dict://ref/has_mean",$row["word"],"1");
  15. }
  16. }
  17. fwrite(STDOUT, "all done ".$redis->hLen("dict://ref/has_mean").PHP_EOL);
  18. }
  19. ?>