مفيد.كوم

كود: تحديد الكل

CREATE TABLE `user_online` (

كود: تحديد الكل

`session` char(100) NOT NULL default '', 
`time` int(11) NOT NULL default '0' 
) TYPE=MyISAM;

كود: تحديد الكل

<? 
session_start(); 
$session=session_id(); 
$time=time(); 
$time_check=$time-600; //SET TIME 10 Minute 
$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="user_online"; // Table name 
// Connect to server and select databse 
mysql_connect("$host", "$username", "$password")or die("cannot connect to server"); 
mysql_select_db("$db_name")or die("cannot select DB"); 
$sql="SELECT * FROM $tbl_name WHERE session='$session'"; 
$result=mysql_query($sql); 
$count=mysql_num_rows($result); 
if($count=="0"){ 
$sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')"; 
$result1=mysql_query($sql1); 
} 
else { 
"$sql2=UPDATE $tbl_name SET time='$time' WHERE session = '$session'"; 
$result2=mysql_query($sql2); 
} 
$sql3="SELECT * FROM $tbl_name"; 
$result3=mysql_query($sql3); 
$count_user_online=mysql_num_rows($result3); 
echo "User online : $count_user_online ";  
// if over 10 minute, delete session  
$sql4="DELETE FROM $tbl_name WHERE time<$time_check"; 
$result4=mysql_query($sql4); 
mysql_close(); 
// Open multiple browser page for result 
?> 
[right]<div align="right">[IMG]http://www.phpeasystep.com/imgs/db_user_online.gif[/IMG] 
  
<div align="right"><font color="blue"><u>الكود:</u></font></div>  
</div>

كود: تحديد الكل

session_start();

كود: تحديد الكل

$session=session_id(); 
$time=time(); 
$time_check=$time-600; //SET TIME 10 Minute

كود: تحديد الكل

$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="user_online"; // Table name 
// Connect to server and select databse 
mysql_connect("$host", "$username", "$password")or die("cannot connect to server"); 
mysql_select_db("$db_name")or die("cannot select DB");

كود: تحديد الكل

$sql="SELECT * FROM $tbl_name WHERE session='$session'"; 
$result=mysql_query($sql); 
$count=mysql_num_rows($result); 
if($count=="0"){ 
$sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')"; 
$result1=mysql_query($sql1); 
} 
else { 
"$sql2=UPDATE $tbl_name SET time='$time' WHERE session = '$session'"; 
$result2=mysql_query($sql2); 
}

كود: تحديد الكل

$sql3="SELECT * FROM $tbl_name"; 
$result3=mysql_query($sql3); 
$count_user_online=mysql_num_rows($result3); 
echo "User online : $count_user_online ";  
// if over 10 minute, delete session  
$sql4="DELETE FROM $tbl_name WHERE time<$time_check"; 
$result4=mysql_query($sql4); 
mysql_close();