判断会员在线方法探讨

CREATE TABLE user (

id int(11) autoincreatment,

name varchar(11),

password varchar(64),

isonline enum(0,1),

onlinetime int(11),

offlinetime int(11)

)primary key id;

<?php

session_start();

if(!is_login())

{

   exit('未登录');

}

/**

在此更新在线时间

*/

$updateOnLineTimeSql = "update user set ōnlinetime=time() where id = $_SESSION['id']";

mysql_query($updateOnlineTimeSql);

<?php

  session_start();

if(!is_login())

{

   exit('未登录');

}

/**

用当前时间戳与表中onlinetime字段做差,如果大于30分钟,即已离线,否则为在线.

*/

$getOnLineTimeStampSql = "select onlinttime from user where id=$_SESSION['id']";

$getOnLineTimeStampQuery = mysql_query($getOnLineTimeStampSql);

$getOnLineTimeStampRes = mysql_fetch_array($getOnLineTimeStampQuery);

$onLineTimeStamp = $getOnLineTimeStampRes['onlinetime'];

if(time()-$onLineTimeStamp>30*60)

{

 //已退出,将数据库中的isonline置为0

}

else

{

//他还是在线的.

}