active_log_get.php 690 B

1234567891011121314151617
  1. <?php
  2. //显示log
  3. require_once '../config.php';
  4. if (isset($_COOKIE["uid"]) && isset($_GET["start"]) && isset($_GET["end"])) {
  5. $dns = "" . _FILE_DB_USER_ACTIVE_LOG_;
  6. $dbh = new PDO($dns, "", "", array(PDO::ATTR_PERSISTENT => true));
  7. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  8. $query = "SELECT time , active,content,timezone FROM log WHERE user_id = ? AND (time BETWEEN ? AND ?) ";
  9. $stmt = $dbh->prepare($query);
  10. $stmt->execute(array($_COOKIE["uid"], $_GET["start"], $_GET["end"]));
  11. $row = $stmt->fetchAll(PDO::FETCH_ASSOC);
  12. echo json_encode($row, JSON_UNESCAPED_UNICODE);
  13. } else {
  14. echo json_encode(array(), JSON_UNESCAPED_UNICODE);
  15. }