Advertisement
Guest User

Untitled

a guest
May 2nd, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. <?php
  2.  
  3. session_start();
  4. $session=session_id();
  5. $time=time();
  6. $time_check=$time-600; //SET TIME 10 Minute
  7.  
  8. $host="localhost"; // Host name
  9. $username=""; // Mysql username
  10. $password=""; // Mysql password
  11. $db_name="test"; // Database name
  12. $tbl_name="user_online"; // Table name
  13.  
  14. // Connect to server and select databse
  15. mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
  16. mysql_select_db("$db_name")or die("cannot select DB");
  17.  
  18. $sql="SELECT * FROM $tbl_name WHERE session='$session'";
  19. $result=mysql_query($sql);
  20.  
  21. $count=mysql_num_rows($result);
  22.  
  23. if($count=="0"){
  24.  
  25. $sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')";
  26. $result1=mysql_query($sql1);
  27. }
  28.  
  29. else {
  30. "$sql2=UPDATE $tbl_name SET time='$time' WHERE session = '$session'";
  31. $result2=mysql_query($sql2);
  32. }
  33.  
  34. $sql3="SELECT * FROM $tbl_name";
  35. $result3=mysql_query($sql3);
  36.  
  37. $count_user_online=mysql_num_rows($result3);
  38.  
  39. echo "User online : $count_user_online ";
  40.  
  41. // if over 10 minute, delete session
  42. $sql4="DELETE FROM $tbl_name WHERE time<$time_check";
  43. $result4=mysql_query($sql4);
  44.  
  45. // Open multiple browser page for result
  46.  
  47.  
  48. // Close connection
  49.  
  50. mysql_close();
  51. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement