Guest User

Untitled

a guest
Sep 17th, 2011
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.22 KB | None | 0 0
  1. <?php
  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. $sql3="SELECT * FROM $tbl_name";
  32. $result3 = mysql_query($sql3);
  33. echo "Brugere online: <br>";
  34. while($row = mysql_fetch_array($result3))
  35. {
  36.   echo '
  37. '.$row['myusername'].'<br>
  38. ';
  39. }
  40.  
  41.  
  42. // if over 10 minute, delete session
  43. $sql5="DELETE FROM $tbl_name WHERE time<$time_check";
  44. $result5=mysql_query($sql5);
  45.  
  46. mysql_close();
  47.  
  48. // Open multiple browser page for result
  49.  
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment