redis_pm_part.php 642 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. $dbh = new PDO(_DICT_DB_PM_, "", "", array(PDO::ATTR_PERSISTENT => true));
  8. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  9. $query = "SELECT pali,parts from "._TABLE_DICT_PM_." where 1 group by pali";
  10. $stmt = $dbh->query($query);
  11. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  12. # code...
  13. if(!empty($row["parts"])){
  14. $redis->hSet("dict://pm/part",$row["pali"],$row["parts"]);
  15. }
  16. }
  17. }
  18. echo "all done ".$redis->hLen("dict://pm/part");
  19. }
  20. ?>