PHP website training also talks about the online population statistics of PHP website

function checkOnline($userid,$tempid=null)
{
$conn = connect();
//For all users
//Set yourself as online first
$stmt = "UPDATE ".DB_NAME.".USER SET Is
$result = query($stmt,$conn);
//info($stmt);
//If the current user is a visitor
if ($tempid != null)
{
$stmt = "SELECT TempID FROM " .Db_name. "Tempuseer Where
Tempid =". $ Tempid;
$ Result = Query ($ STMT, $ CONN);
// Info ($ STMT);
// = fetch_array($result))
{
$stmt = "UPDATE ".DB_NAME.".TEMPUSER SET
RequestTime='".getCurrentTime()."' WHERE TempID=".$tempid;
$result = query ($ stmt,$conn);
//info($stmt);
//The visitor is offline
else
{
$stmt = "INSERT INTO ".DB_NAME.".TEMPUSER
VALUES('".$tempid ."','".getCurrentTime()."')";
$result = query($stmt,$conn);
//info($stmt);
}
}
//View other users
/ /Normal user
$stmt = "UPDATE ".DB_NAME.".USER SET Is
unix_timestamp(RequestTime) > ".ONLINE_DURATION." AND UserGroupID != ".GUEST;
$result = query($stmt,$conn) ; stmt,$conn );
disconnect($conn);
}
//Get the number of people online, divided into users and visitors
function getOnlineNumber()
{
$olnum = array();​​
$stmt = " SELECT COUNT(UserID) FROM ".DB_NAME.".USER WHERE Is
UserGroupID != 4"; //4 is the guest's user group 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)) '];
}
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."
";     
$conn = mysql_connect(DB_HOST,DB_USER,DB_PASS);     
mysql_select_db(DB_NAME);     
/*    
if ($conn)    
{    
echo "Connect to database sucessfully. connection id:".$conn."
";    
}    
else    
{    
echo "Connect to database failed.
";    
}    
*/     
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.
";    
else    
echo "MySQL Database disconnecting failed. Please try again.
";    
*/     
}     
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']."人"; 

以上就介绍了php网站培训 也谈php网站在线人数统计，包括了php网站培训方面的内容，希望对PHP教程有兴趣的朋友有所帮助。