Home  >  Article  >  Backend Development  >  PHP website training also talks about the online population statistics of PHP website

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

WBOY
WBOYOriginal
2016-07-29 08:37:511355browse

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教程有兴趣的朋友有所帮助。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn