// include configuration file require_once('inc/app_conf.php'); $date = mktime(0,0,0); $mysql_conn = dbconnect(); $counted=$_COOKIE["counted"]; if(!$counted) { //Set a cookie to run out at the end of the day setcookie("counted",1,mktime(0,0,0) + 86400); $query = "SELECT hits FROM hits WHERE type = 'unique' AND date = '".$date."' LIMIT 1;"; $result = mysql_query($query) or die('Error, query failed'); if (mysql_num_rows($result) == 0) { $query = "INSERT INTO hits(type, date, hits) VALUES ('unique', '".$date."', '1');"; mysql_query($query) or die('Error, query failed'); } else { $query = "UPDATE hits SET hits = hits+1 WHERE type='unique' AND date = '".$date."' LIMIT 1;"; mysql_query($query) or die('Error, query failed'); } } $query = "SELECT hits FROM hits WHERE type = 'page' AND date = '".$date."' LIMIT 1;"; $result = mysql_query($query) or die('Error, query failed'); if (mysql_num_rows($result) == 0) { $query = "INSERT INTO hits(type, date, hits) VALUES ('page', '".$date."', '1');"; mysql_query($query) or die('Error, query failed'); } else { $query = "UPDATE hits SET hits = hits+1 WHERE type='page' AND date = '".$date."' LIMIT 1;"; mysql_query($query) or die('Error, query failed'); } mysql_close($mysql_conn); ?>
|
||||||||||||||||||||||||||
|
|
|
![]() |
||||||||||||||||||||||||