Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
SELECT MAX(id) FROM Tabelle WHERE ip = '$ip'
SELECT wert1, wert2, wert3, MAX(id) FROM Tabelle WHERE ip = '$ip'
<?php include "connect.php";
$ip = "$REMOTE_ADDR";
$time = time();
$now = date("H:i:s", $time);
$today = date("d.m.Y", $time);
$select = mysql_query("SELECT * FROM counter WHERE ip = '$ip'");
$rows = mysql_num_rows($select);
if($rows == 0){
mysql_query("INSERT INTO counter(ip, date, time) VALUES('$ip','$today','$now')");
}
else {
$select = mysql_query("SELECT id FROM counter WHERE ip = '$ip' ORDER BY id DESC LIMIT 1");
while($row = mysql_fetch_array($select)){
$id = $row['id'];
$select2 = mysql_query("SELECT * FROM counter WHERE id = '$id'");
while($row2 = mysql_fetch_array($select2)){
$date2 = $row2['date'];
$time1 = $row2['time'];
$date = explode(".", $date2);
$time = explode(":", $time1);
$dbtime = mktime($time[0], $time[1], $time[2], $date[1], $date[0], $date[2]);
$time = time();
$timediv = $time - $dbtime;
if($timediv <= 60*60/2){
}
else {
$now = date("H:i:s", $time);
$date = date("d.m.Y", $time);
mysql_query("INSERT INTO counter(ip, date, time) VALUES('$ip','$date','$now')");
}
}
}
}
$count = mysql_query("SELECT * FROM counter");
$visitors = mysql_num_rows($count);
$show = $visitors;
echo 'Bisher waren '.$show.' Besucher bei ebsevent.de';
?>