############### Code <? session_start(); $session=session_id(); $time=time(); $time_check=$time-600; $host="localhost"; $username=""; $password=""; $db_name="test"; $tbl_name="user_online"; mysql_connect("$host", "$username", "$password")or die("cannot connect to server"); mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE session='$session'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count=="0"){ $sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')"; $result1=mysql_query($sql1); } else { "$sql2=UPDATE $tbl_name SET time='$time' WHERE session = '$session'"; $result2=mysql_query($sql2); } $sql3="SELECT * FROM $tbl_name"; $result3=mysql_query($sql3); $count_user_online=mysql_num_rows($result3); echo "User online : $count_user_online "; $sql4="DELETE FROM $tbl_name WHERE time<$time_check"; $result4=mysql_query($sql4);
mysql_close(); ?>
|