EkoDLuffy

user_online.php

Nov 30th, 2016
7,959
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.83 KB | None | 0 0
  1. <?php
  2.     if(isset($_SESSION['user'])){
  3.         $sqlm=$dbh->prepare("SELECT name FROM chatters WHERE name=?");
  4.         $sqlm->execute(array($_SESSION['user']));
  5.        
  6.         if($sqlm->rowCount()!=0){
  7.             $sql=$dbh->prepare("UPDATE chatters SET seen=NOW() WHERE name=?");
  8.             $sql->execute(array($_SESSION['user']));
  9.         }else{
  10.             $sql=$dbh->prepare("INSERT INTO chatters (name,seen) VALUES (?,NOW())");
  11.             $sql->execute(array($_SESSION['user']));
  12.         }
  13.     }
  14.  
  15.     //pastikan wakti pada database dan php server sama
  16.     $sql=$dbh->prepare("SELECT * FROM chatters");
  17.     $sql->execute();
  18.    
  19.     while($r=$sql->fetch()){
  20.         $curtime=strtotime(date("Y-m-d H:i:s",strtotime('-25 seconds', time())));
  21.        
  22.         if(strtotime($r['seen']) < $curtime){
  23.             $kql=$dbh->prepare("DELETE FROM chatters WHERE name=?");
  24.             $kql->execute(array($r['name']));
  25.         }
  26.     }
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment