问从最后一刻开始活动(PHP)

EN

  if (isset($_POST['message'])) {
    if (!empty($_POST['msg'])) {
      $chatArray = array();
      $s = $_database->query("INSERT INTO chat(`username`, `text`, `date`) VALUES('".$_database->real_escape_string($_POST['username'])."', '".$_database->real_escape_string($_POST['msg'])."', '".TIME()."')");
      $newID = $_database->insert_id;
      $_database->query("UPDATE chatusers SET lastactivity=TIME() WHERE username='".$_POST['username']."'");
      $timestamp = (isset($_COOKIE['chatTimestamp'])) ? $_COOKIE['chatTimestamp'] : TIME();

      $q = $_database->query("SELECT * FROM (SELECT * FROM chat WHERE `date` > ".$timestamp." ORDER BY date DESC LIMIT 0, 24) AS a ORDER BY DATE ASC");
      if ($q->num_rows == 0) { echo '0'; }
      else {
        while ($rad = $q->fetch_array()) {
          // $chatArray["message"][] = array("msgID" => $rad['msgID'], "message" => $rad['text'], "timestamp" => $rad['date'], "date" => date('H:i', $rad['date']), "username" => $rad['username']);

        }
        $query = $_database->query("SELECT * FROM chatusers WHERE `lastactivity` > (NOW() - INTERVAL 1 minute)");
        var_dump($query);
        while ($row = $query->fetch_array()) {
          $chatArray["users"][] = array("username" => $row['name'], "lastactivity" => $row['lastactivity']);
        }
        print_r($chatArray);
      }
    }
  }