Advertisement
Guest User

Untitled

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