Guest User

Untitled

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