Re:Inserting and displaying Unique Statistics from users viewing my site, problem

bearslife · 08-06-2004, 02:16 PM

I am trying to figure out how I can insert user information only once
(ip,date,browser,referrer) etc... I don't want to have the user information inserted more than once into my mysql database table. Then I want to display it only once every visitor. I have the scripts working fine right now, but it enters and displays every hit to my site regardless if it is unique or not.

Below is my table in mysql:

CREATE TABLE `statistical` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(25) NOT NULL default '',
`date` varchar(50) NOT NULL default '',
`subfolder` varchar(65) NOT NULL default '',
`os` varchar(250) NOT NULL default '',
`referrer` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
)

Here is my script used to insert the informaiton into the database:
"/astatistic.php"

PHP Code:


			
<?

$username = "";

$password = "";

$host = "";

$database = "";

mysql_connect($host,$username,$password) or die("Cannot connect to the database.<br>" . mysql_error());

mysql_select_db($database) or die("Cannot select the database.<br>" . mysql_error());



$ip = $_SERVER['REMOTE_ADDR'];

$date = date("D M j g:ia");

$subfolder = $_SERVER['PHP_SELF'];

$os = $_SERVER['HTTP_USER_AGENT'];

$referrer = $_SERVER['HTTP_REFERER'];



$result=mysql_query("INSERT INTO statistical (ip, date, subfolder, os, referrer) VALUES ('$ip','$date','$subfolder','$os','$referrer')")or die("Insert Error: ".mysql_error());



?>

Thanks, and god bless, I really hope that someone can help me figure out how to place the user only oncel into my database and display only that once not five million of the same person stats. Thanks again.

bdl · 08-06-2004, 06:14 PM

Although using the users IP address isn't strictly the best way to go about it (because more than one user can access from the same IP), I suppose performing two queries per page would be the way you'd want to approach this. The first query simply looks up the users IP in the database, then if it doesn't exist, logic dictates that the second query is run.

redhead · 08-06-2004, 06:53 PM

It could be more specific if you'd extend that ie:

PHP Code:


			
$been_here = mysql_query("SELECT id FROM statistical WHERE ip = \"$_SERVER['REMOTE_ADDR']\" AND os = \"$_SERVER['HTTP_USER_AGENT']\"");

But then again, in these M$ days, this wouldn't catch that many if they were sharing IP.

And if the viewer were to have multiple boot options, this would srew it up aswell.

idx · 08-07-2004, 07:58 AM

Depending on what you're looking to get our of the stats, you may also want to query the date. What if the same person views your site tomorrow, next week or 3 months from now?

Seems like a missed hit.

-r