كود PHP:
<?php
$link = mysql_connect('localhost', 'root', 'root') or die('Could not connect to MySQL');
mysql_select_db('my_database') or die('Could not select database');
$onlinetime = time();
$newtime = $onlinetime - 360;
mysql_query("DELETE FROM online WHERE ip='".$_SERVER['REMOTE_ADDR']."' OR timestamp < '$newtime'");
mysql_query("INSERT INTO online (ip, timestamp) VALUES ('".$_SERVER['REMOTE_ADDR']."', '$onlinetime')");
$num = mysql_num_rows(mysql_query("SELECT * FROM online"));
echo 'Online: ', $num;
?>
عدل معلومات قاعدة البيانات
وانشئ هذا الجدول في قاعدة البيانات
كود PHP:
CREATE TABLE `online` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`ip` VARCHAR( 15 ) NOT NULL ,
`timestamp` TIMESTAMP NOT NULL ,
INDEX ( `ip` )
) ENGINE = MYISAM ;