whos on line
Note: This Snippet Need sql db to work.
This script show logged in users, and update the db.
<?php
/* Please dump these MySQL query into your PHPadmin:
----------------------------------------------------
CREATE TABLE online (
id int(11) NOT NULL auto_increment,
visitor varchar(100) default NULL,
timevisit int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
------------------------------------------------- */
// -- DATABASE CONNECTION -->
$conn=mysql_connect("localhost","myuser","12345") or die ("can't connect to server");
@mysql_select_db("mydata") or die ("can't select database");
// UPDATING ONLINE USER DATABASE
// (add these line below on top of your webpage)
$uvisitor=$REMOTE_ADDR;
$uvisitor.="|".gethostbyaddr($uvisitor);
$utime=time();
$exptime=$utime-600; // (in seconds)
@mysql_query("delete from online where timevisit<$exptime");
$uexists=@mysql_num_rows(@mysql_query("select id from online where visitor='$uvisitor'"));
if ($uexists>0){
@mysql_query("update online set timevisit='$utime' where visitor='$uvisitor'");
} else {
@mysql_query("insert into online (visitor,timevisit) values ('$uvisitor','$utime')");
}
// DISPLAYING ONLINE USER DATABASE -->
$rs=@mysql_query("select * from online");
echo "<style><!--n";
echo "body {font-family:verdana;font-size:10pt}n";
echo "td {font-family:verdana;font-size:10pt}n";
echo "--></style>n";
echo "<div align=center><table><tr bgcolor=#CCCCCC>
<td><b>Visitor IP/Host<td><b>Last visit</tr>";
while ($ro=@mysql_fetch_array($rs)){
echo "<tr><td>".$ro[visitor]."<td>".date('j M Y - H:i',$ro[timevisit])."</tr>";
}
echo "</table></div>";
$jmlonline=@mysql_num_rows(@mysql_query("select id from online"));
echo "<div align=center><b>There are $jmlonline user online</b></div>";
?>
07.12.2006. 17:29
