unieke bezoekers

CREATE TABLE `hits` (
  `id` int(50) NOT NULL auto_increment,
  `datum` varchar(10) NOT NULL default '',
  `tijd` varchar(5) NOT NULL default '',
  `ip_adres` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `hits_overview` (
  `id` int(5) NOT NULL auto_increment,
  `datum` varchar(10) NOT NULL default '',
  `aantal_hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `hits` (
  `id` int(50) NOT NULL auto_increment,
  `datum` varchar(10) NOT NULL default '',
  `tijd` varchar(5) NOT NULL default '',
  `ip_adres` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `hits_overview` (
  `id` int(5) NOT NULL auto_increment,
  `datum` varchar(10) NOT NULL default '',
  `aantal_hits` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

<?
/*
	Name:		hits.php
	Version:	1.0
	Author:		Mad_Mike
*/


/* geeft IP van client */
function get_ip() { 
	if(getenv("HTTP_X_FORWARDED_FOR"))
	{ 
    	$IPadres = getenv("HTTP_X_FORWARDED_FOR"); 
	} elseif(getenv("HTTP_CLIENT_IP"))	{ 
		$IPadres = getenv("HTTP_CLIENT_IP"); 
	} else { 
		$IPadres = $_SERVER["REMOTE_ADDR"]; 
	} 
	return $IPadres; 
}

$ip = get_ip();
$datum = date("d-m-Y");
$tijd = date("H:i");

$mysql = "SELECT id FROM hits WHERE ip_adres = '$ip' AND datum = 'datum'";
$query = mysql_query($mysql) or die(mysql_error());
$aantal = mysql_num_rows($query);

if($aantal < 1) {
	// de eerste keer dat deze site bezocht wordt op deze dag
	$qeury2 = mysql_query("INSERT INTO hits (datum, tijd, ip_adres) values ('$datum', '$tijd', ' $ip')") or die(mysql_error());
	
	// update de dag-overzicht (hits_overview)
	$query3 = mysql_query("SELECT * FROM hits_overview WHERE datum = '$datum'") or die(mysql_error());
	$aantal3 = mysql_num_rows($query3);
	if($aantal < 1) {
		// eerste bezoeker vandaag
		$query4 = mysql_query("INSERT INTO hits_overview (datum, aantal_hits) values ('$datum', '1')") or die(mysql_error());
	} else {
		$select = mysql_fetch_array($query3);
		$aantal_hits = $select['aantal_hits'];
		$aantal_hits++;
		
		// update de gegevens
		$query5 = mysql_query("UPDATE hits_overview SET aantal_hits = '$aantal_hits' WHERE datum = '$datum'") or die(mysql_error());
	}
	
}

?>

<?
/*
	Name:		hits.php
	Version:	1.0
	Author:		Mad_Mike
*/
 
 
/* geeft IP van client */
function get_ip() { 
	if(getenv("HTTP_X_FORWARDED_FOR"))
	{ 
    	$IPadres = getenv("HTTP_X_FORWARDED_FOR"); 
	} elseif(getenv("HTTP_CLIENT_IP"))	{ 
		$IPadres = getenv("HTTP_CLIENT_IP"); 
	} else { 
		$IPadres = $_SERVER["REMOTE_ADDR"]; 
	} 
	return $IPadres; 
}
 
$ip = get_ip();
$datum = date("d-m-Y");
$tijd = date("H:i");
 
$mysql = "SELECT id FROM hits WHERE ip_adres = '$ip' AND datum = 'datum'";
$query = mysql_query($mysql) or die(mysql_error());
$aantal = mysql_num_rows($query);
 
if($aantal < 1) {
	// de eerste keer dat deze site bezocht wordt op deze dag
	$qeury2 = mysql_query("INSERT INTO hits (datum, tijd, ip_adres) values ('$datum', '$tijd', ' $ip')") or die(mysql_error());
 
	// update de dag-overzicht (hits_overview)
	$query3 = mysql_query("SELECT * FROM hits_overview WHERE datum = '$datum'") or die(mysql_error());
	$aantal3 = mysql_num_rows($query3);
	if($aantal < 1) {
		// eerste bezoeker vandaag
		$query4 = mysql_query("INSERT INTO hits_overview (datum, aantal_hits) values ('$datum', '1')") or die(mysql_error());
	} else {
		$select = mysql_fetch_array($query3);
		$aantal_hits = $select['aantal_hits'];
		$aantal_hits++;
 
		// update de gegevens
		$query5 = mysql_query("UPDATE hits_overview SET aantal_hits = '$aantal_hits' WHERE datum = '$datum'") or die(mysql_error());
	}
 
}
 
?>