Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
<?php
session_start();
mysql_connect('localhost', 'ИМЕ КЪМ БАЗА ДАННИ', 'ПАРОЛА КЪМ БАЗА ДАННИ');
mysql_select_db('cu');
$time=time();
if($_SESSION['sesscheck_t']!=true) {
$_SESSION['sesscheck']=time();
$_SESSION['sesscheck_t']=true;
$ip=htmlspecialchars(addslashes($_SERVER['REMOTE_ADDR']));
$hostname=htmlspecialchars(addslashes(gethostname()));
mysql_query("INSERT INTO `cu`(`ip`,`hostname`,`vreme`) VALUES ('$ip','$hostname', '$time')");
}
if (time() - $_SESSION['sesscheck'] > 300) {
$_SESSION['sesscheck_t']=false;
}
$time_check=$time-300; //Трябва да е равно на времето зададено на сесията
mysql_query("DELETE FROM `cu` WHERE vreme<$time_check");
?>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
</head>
<body>
<?php
//Да приемем, че това е админ панела.
$online_row=mysql_query("SELECT * FROM `cu` ");
$online_obshto=mysql_num_rows($online_row);
echo "В момента има: ".$online_obshto." гост в сайта<br><br><br>";
while($online=mysql_fetch_assoc($online_row)){
echo "<table border='1'>";
echo "<tr><td>".$online['ip']."</td>";
echo "<td>".stripslashes($online['hostname'])."</td>";
echo "</tr></table>";
}
?>
</body>
</html>
isset($_SESSION['sess_check'])
unset($_SESSION['sess_check']);
<?php
header("Content-Type: text/html; charset=UTF-8");
$link = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('test', $link) or die(mysql_error());
if(isset($_SERVER['REMOTE_ADDR'])){
$hostname = php_uname('n');
$time_diff = time() - 30;
$check = mysql_query("SELECT * FROM `status` WHERE `user_ip` = '{$_SERVER['REMOTE_ADDR']}'") or die(mysql_error());
if(mysql_num_rows($check) > 0){
if($row = mysql_fetch_assoc($check)){
if($row['timestamp'] > $time_diff){
mysql_query("UPDATE `status` SET `timestamp` = UNIX_TIMESTAMP() WHERE `user_ip` = '{$_SERVER['REMOTE_ADDR']}'") or die(mysql_error());
}
else{
mysql_query("DELETE FROM `status` WHERE `user_ip` = '{$_SERVER['REMOTE_ADDR']}'") or die(mysql_error());
}
}
}
else{
mysql_query("INSERT INTO `status`(`id`, `user_ip`, `hostname`, `timestamp`) VALUES ('', '{$_SERVER['REMOTE_ADDR']}', '{$hostname}', UNIX_TIMESTAMP())") or die(mysql_error());
}
}
?>
<?php
header("Content-Type: text/html; charset=UTF-8");
$link = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('test', $link) or die(mysql_error());
mysql_query("DELETE FROM `status` WHERE `timestamp` < (UNIX_TIMESTAMP() - 30)") or die(mysql_error());
$query = mysql_query("SELECT * FROM `status`") or die(mysql_error());
if(mysql_num_rows($query) > 0){
while($row = mysql_fetch_assoc($query)){
echo "ID: {$row['id']} ---- IP: {$row['user_ip']} ---- HOSTNAME: {$row['hostname']} ---- TIMESTAMP: {$row['timestamp']}<br />";
}
}
else{
echo "Няма записи!";
}
?>