📄 check.php

📁 邮箱加即时聊天

💻 PHP

字号:

<html>
<head>
	<meta http-equiv="refresh" content="30" >
	<title></title>
</head>
<body>
<?php
include "Sysconf.php";//连接数据库
$sql = "select * from online";
$result=mysql_query($sql);
while($temp=mysql_fetch_array($result,MYSQL_ASSOC))
{
    if(time()-$temp['last_access']>25)
    {
        $sql="delete from online where user='".$temp['user']."'";
        mysql_query($sql);
        echo $temp['user']."下线"."<br>";
    }
}
$sql="delete from short_message where isRead=1";//每次刷新时删除已经被读过的消息
$result=mysql_query($sql);//检查未读的消息的接受者是否下线，若下线，则标记该消息isRead=2;
$sql='update short_message set isRead=2 where isRead=0 and receiver not in (select user from online)';$result=mysql_query($sql);   
?>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -