Unique/Total Hits Counter (Using SQL)

Unique/Total Hits Counter (Using SQL)

Counter that you can use to count unique AND total hits on your site. You can also see how much each user/IP has viewed your site.

PHP Example: (!)

PHP code:

function counter()
{
$ip = $_SERVER['REMOTE_ADDR'];
$query = mysql_query("SELECT * FROM counter WHERE ip = '" . $ip . "'");

if(!$query)
{
$query = mysql_query("INSERT INTO counter(ip, views) VALUES('$ip', '1')")
OR DIE(mysql_error());
}
else
{
$query = mysql_query("UPDATE users SET views = views + 1 WHERE ip = '" . $ip . "'") OR DIE(mysql_error());
}
}