本页文章导读:
▪php下使用以下代码连接并测试
代码如下:<?php $myServer = "localhost"; //主机 $myUser = "sa"; //用户名 $myPass = "password"; //密码 $myDB = "Northwind";? //MSSQL库名 $s = @mssql_connect($myServer, $myUser, $m.........
▪也谈php网站在线人数统计
function checkOnline($userid,$tempid=null) { $conn = connect(); //对于所有用户 //先设置自己为在线 $stmt = "UPDATE ".DB_NAME.".USER SET IsOnline='Y' WHERE UserID=".$userid;.........
▪php实现的在线人员函数库
//增加用户 function AddUser($username){ global $db; $Ip=getenv('REMOTE_ADDR'); $Ip1 = getenv('HTTP_X_FORWARDED_FOR'); if (($Ip1 != "") && ($Ip1 != "unknown")) $Ip=$Ip1; $curren.........
function checkOnline($userid,$tempid=null)
{
$conn = connect();
//对于所有用户
//先设置自己为在线
$stmt = "UPDATE ".DB_NAME.".USER SET IsOnline='Y' WHERE UserID=".$userid;
$result = query($stmt,$conn);
//info($stmt);
//如果当前用户是游客
if ($tempid != null)
{
$stmt = "SELECT TempID FROM ".DB_NAME.".TEMPUSER WHERE
TempID=".$tempid;
$result = query($stmt,$conn);
//info($stmt);
//如果该游客还在线
if ($row = fetch_array($result))
{
$stmt = "UPDATE ".DB_NAME.".TEMPUSER SET
RequestTime='".getCurrentTime()."' WHERE TempID=".$tempid;
$result = query($stmt,$conn);
//info($stmt);
}
//该游客已经离线
else
{
$stmt = "INSERT INTO ".DB_NAME.".TEMPUSER
VALUES('".$tempid."','".getCurrentTime()."')";
$result = query($stmt,$conn);
//info($stmt);
}
}
//查看其他用户
//普通用户
$stmt = "UPDATE ".DB_NAME.".USER SET IsOnline='N' WHERE ".time()." -
unix_timestamp(RequestTime) > ".ONLINE_DURATION." AND UserGroupID != ".GUEST;
$result = query($stmt,$conn);
//游客
$stmt = "DELETE FROM ".DB_NAME.".TEMPUSER WHERE ".time()." -
unix_timestamp(RequestTime) > ".ONLINE_DURATION;
$result = query($stmt,$conn);
disconnect($conn);
}
//得到在线人数，分用户和游客
function getOnlineNumber()
{
$olnum = array();
$conn = connect();
$stmt = "SELECT COUNT(UserID) FROM ".DB_NAME.".USER WHERE IsOnline='Y' AND
UserGroupID != 4"; //4 为guest的用户组id
//info ($stmt);
$result = query($stmt,$conn);
$olnum['user'] = result($result,0,"COUNT(UserID)");
$stmt = "SELECT COUNT(TempID) FROM ".DB_NAME.".TEMPUSER";
//info ($stmt);
$result = query($stmt,$conn);
if ($row = fetch_array($result))
{
$olnum['guest'] = $row['COUNT(TempID)'];
}
disconnect($conn);
return $olnum; //from www.w3sky.com
}
其中的connect(), disconnect(), query(),fetch_array()函数在dbmanager.inc.PHP中
dbmanager.inc.PHP
define("DB_NAME","databasename");
define("DB_USER","user");
define("DB_PASS","pass");
define("DB_HOST","localhost");
function connect()
{
//echo "Connecting to Host:".HOST."<br>";
$conn = mysql_connect(DB_HOST,DB_USER,DB_PASS);
mysql_select_db(DB_NAME);
/*
if ($conn)
{
echo "Connect to database sucessfully. connection id:".$conn."<br>";
}
else
{
echo "Connect to database failed.<br>";
}
*/
return $conn;
}
function pconnect()
{
return mysql_pconnect(DB_HOST,DB_USER,DB_PASS);
}
function disconnect($conn)
{
$close = mysql_close($conn);
/*
if ($close)
echo "MySQL Database disconnected.<br>";
else
echo "MySQL Database disconnecting failed. Please try again.<br>";
*/
}
function query($stmt,$conn)
{
return mysql_query($stmt,$conn); //from www.w3sky.com
}
function fetch_array($result)
{
return mysql_fetch_array($result);
}
function fetch_row($result)
{
return mysql_fetch_row($result);
}
function num_rows($result)
{
return mysql_num_rows($result);
}
function result($result,$row,$field)
{
return mysql_result($result,$row,$field);
}
rule层：
rl_online.PHP
function getOnline()
{
if ($userid == 2)
{
if (session_is_registered("tempuserid"))
{
checkOnline($userid,$tempuserid);
}
}
else
{
checkOnline($userid);
}
return getOnlineNumber();
}
ui层：
ui_online.PHP
$online_num = getOnline();
echo "在线人数，注册用户".$online_num['user']."人，游客".$online_num['guest']."人";
//增加用户
function AddUser($username){
global $db;
$Ip=getenv('REMOTE_ADDR');
$Ip1 = getenv('HTTP_X_FORWARDED_FOR');
if (($Ip1 != "") && ($Ip1 != "unknown")) $Ip=$Ip1;
$current_time=date("Y-m-d H:i:s");
$SQL="select user from class_online where user='$username'";
$res=mysql_query($SQL,$db);
$row=@mysql_num_rows($res);
if($row==0) {
$SQL="insert into class_online (user,ip,lasttime) values('$username','$Ip','$current_time')";
mysql_query($SQL,$db);
}
}
//更新在线用户名单
function UpdateMember(){
global $db;
$SQL="delete from class_online where UNIX_TIMESTAMP()-UNIX_TIMESTAMP(lasttime)>180"; //3分钟不活动则退出
//echo $SQL;
mysql_query($SQL,$db);
}
//更新在线状态
function UpdateOnline($username){
global $db;
$current_time=date("Y-m-d H:i:s");;
$SQL="update class_online set lasttime='$current_time' where user='$username'";
$res=mysql_query($SQL,$db);
}
//删除用户
function OutOneUser($user){
global $db;
$SQL="delete from class_online where user='$user'";
mysql_query($SQL,$db);
return true;
}
//检查是否在线
function CheckUser($user){
global $db;
$SQL="select user from class_online where user='$user'";
$res=mysql_query($SQL,$db);
$row=mysql_num_rows($res);
if($row>0) return true;
else return false;
}
//取在线名单
function ReadOnlineName(){
global $db;
$SQL="select * from class_online";
$res=mysql_query($SQL,$db);
while($row=mysql_fetch_array($res)){
$result[]=$row[user];
}
return $result;
}
//********************在线人员函数库***************end
