is_online.php

来自「ajax 聊天室,实现多人聊天,无刷新!」· PHP 代码 · 共 37 行

<?
// configuration //
$sql_user = 'root';
$sql_pass = '';
$sql_host = 'localhost';
$sql_db   = 'ajaxim';

// checks if a user is online or not //
function is_online($username) {
   $query = @mysql_query("SELECT is_online FROM users WHERE username='".mysql_real_escape_string($username)."'");
   $result = @mysql_fetch_assoc($query);
   return $result['is_online'];
}

// connect to database //
$link = mysql_connect($sql_host, $sql_user, $sql_pass);
mysql_select_db($sql_db);

header("Content-type: image/gif");

$isonline = is_online($_GET['user']);
switch($isonline) {
   case 1:
      readfile('images/online.gif');
      break;
   case 2:
      readfile('images/away.gif');
      break;
   case 0:
   case 50:
   case 100:
      readfile('images/offline.gif');
      break;
}

mysql_close($link);
?>