Statistieken

<?php
# Variabelen aanmaken
$sIpAddress     =   $_SERVER['REMOTE_ADDR'];
$sDate          =   date("dmy");

# Verwijderen van oude records
$rDelete = mysql_query("DELETE FROM `counter` WHERE date != '".$sDate."'");

# Kijken of iemand vandaag al niet een keer eerder is geweest
$rCheckVisit = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."' AND `ip` = '".$sIpAddress."'");

# Wanneer iemand vandaag niet eerder is geweest
if (mysql_result($rCheckVisit, 0) == 0) {
    
    $rInsert = mysql_query("INSERT INTO `counter` (date, ip) VALUES ('".$sDate."', '".$sIpAddress."')");

}

# Ophalen van de counter gegevens
$rGetLast = mysql_query("SELECT `counterid` FROM `counter` ORDER BY `counterid` DESC LIMIT 1");
$aLast = mysql_fetch_row($rGetLast);

$rGetToday = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."'");

# Aanmaken van de variabelen
$counter['today']   = mysql_result($rGetToday, 0);
$counter['total']   = $aLast['counterid'];
?>

<?php
# Variabelen aanmaken
$sIpAddress     =   $_SERVER['REMOTE_ADDR'];
$sDate          =   date("dmy");
 
# Verwijderen van oude records
$rDelete = mysql_query("DELETE FROM `counter` WHERE date != '".$sDate."'");
 
# Kijken of iemand vandaag al niet een keer eerder is geweest
$rCheckVisit = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."' AND `ip` = '".$sIpAddress."'");
 
# Wanneer iemand vandaag niet eerder is geweest
if (mysql_result($rCheckVisit, 0) == 0) {
 
    $rInsert = mysql_query("INSERT INTO `counter` (date, ip) VALUES ('".$sDate."', '".$sIpAddress."')");
 
}
 
# Ophalen van de counter gegevens
$rGetLast = mysql_query("SELECT `counterid` FROM `counter` ORDER BY `counterid` DESC LIMIT 1");
$aLast = mysql_fetch_row($rGetLast);
 
$rGetToday = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."'");
 
# Aanmaken van de variabelen
$counter['today']   = mysql_result($rGetToday, 0);
$counter['total']   = $aLast['counterid'];
?>

<?php
# Variabelen aanmaken
$sIpAddress     =   $_SERVER['REMOTE_ADDR'];
$sDate          =   date("dmy");

# Kijken of iemand vandaag al niet een keer eerder is geweest
$rCheckVisit = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."' AND `ip` = '".$sIpAddress."'");

# Wanneer iemand vandaag niet eerder is geweest
if (mysql_result($rCheckVisit, 0) == 0) {
    
    $rInsert = mysql_query("INSERT INTO `counter` (date, ip) VALUES ('".$sDate."', '".$sIpAddress."')");

}

# Ophalen van de counter gegevens
$rGetLast = mysql_query("SELECT * FROM `counter");
$aLast = mysql_num_rows($rGetLast);
$rGetToday = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."'");

# Aanmaken van de variabelen
$counter['today']   = mysql_result($rGetToday, 0);
$counter['total']   = $aLast;
?>

<?php
# Variabelen aanmaken
$sIpAddress     =   $_SERVER['REMOTE_ADDR'];
$sDate          =   date("dmy");
 
# Kijken of iemand vandaag al niet een keer eerder is geweest
$rCheckVisit = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."' AND `ip` = '".$sIpAddress."'");
 
# Wanneer iemand vandaag niet eerder is geweest
if (mysql_result($rCheckVisit, 0) == 0) {
 
    $rInsert = mysql_query("INSERT INTO `counter` (date, ip) VALUES ('".$sDate."', '".$sIpAddress."')");
 
}
 
# Ophalen van de counter gegevens
$rGetLast = mysql_query("SELECT * FROM `counter");
$aLast = mysql_num_rows($rGetLast);
$rGetToday = mysql_query("SELECT COUNT(counterid) FROM `counter` WHERE `date` = '".$sDate."'");
 
# Aanmaken van de variabelen
$counter['today']   = mysql_result($rGetToday, 0);
$counter['total']   = $aLast;
?>