2
0

update_analytics.php 826 B

123456789101112131415161718192021
  1. <?php
  2. require_once "../path.php";
  3. require_once "../public/_pdo.php";
  4. require_once '../public/load_lang.php';
  5. require_once '../public/function.php';
  6. global $PDO;
  7. PDO_Connect("" . _FILE_DB_TERM_);
  8. echo "Day Index,创建,更新\n";
  9. $end = strtotime("now");
  10. $begin = strtotime("-1 day");
  11. for ($i = 0; $i < 100; $i++) {
  12. $query = "select count(*) from term where \"create_time\" > " . $PDO->quote($begin) . " AND \"create_time\" < " . $PDO->quote($end);
  13. $create = PDO_FetchOne($query);
  14. $query = "select count(*) from term where modify_time <> create_time AND \"modify_time\" > " . $PDO->quote($begin) . " AND \"modify_time\" < " . $PDO->quote($end);
  15. $modify = PDO_FetchOne($query);
  16. echo date("m/d/Y", $begin) . ',' . $create . "," . $modify . "\n";
  17. $end = $begin;
  18. $begin = strtotime("-1 day", $end);
  19. }