active_log_get.php 662 B

12345678910111213141516171819
  1. <?php
  2. //显示log
  3. require_once '../path.php';
  4. if(isset($_COOKIE["uid"]) && isset($_GET["start"]) && isset($_GET["end"])){
  5. $dns = "sqlite:"._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. }
  14. else{
  15. echo json_encode(array(), JSON_UNESCAPED_UNICODE);
  16. }
  17. ?>