SiteStats

[onlyican]

Hey guys

I have a small problem

What I want to do is Record movement on my website

For example
When a user clicks on the website I want to log
What time they came on the website
What page they are on
There IP
Where they come from

But for every user, every page
so I can see that a user clicked on 10 pages before closing or something

I was thinking of adding into a MySQL table
But then if you look at a basic screen of
100 Unique Hits a day
say
3000 Page Hits

Thats a lot of data to add into a table

thats 21000 entries per week

OR
90000 entries on a 30 day month

So what is the best way of storing all this data without killing the server by filling up a MySQL table

[marcus]

Create a table, and log the users IP.

Insert their IP into the table, and have something like:

IP | Hits | Time | LastPage

And check if the user's IP already exists in the database, and if it does then it won't create a new row each time. Then just do

[code]
$sql = "SELECT ip FROM stats WHERE ip ='$_SERVER[REMOTE_ADDR]'";
$res = mysql_query($sql);
$res2 = mysql_fetch_assoc($res);
$num = mysql_numrows($res);

if($num > 0){
//update stats
}else {
$sql = "INSERT INTO stats (`ip`) VALUES('$_SERVER[REMOTE_ADDR]')";
$res = mysql_query($sql);
};
[/code]

[onlyican]

but I want to know what page that user went on and at what time he went on that page.
If it was a case of number of unique hits then I would do that

I have a couple of other ideas, but I want to hear yours first

[marcus]

just update their row with what page they are in the last page column using $_SERVER[REQUEST_URI]

[marcus]

Then when showing what page that user is on you can easily use fetch assoc or fetch array and echo off last page and link it http://site.com/$lastpage

If they were on index.php the link would be site.com/index.php

[onlyican]

I dont want to use it in the code in that way, cos I would use sessions for last page

I want to be able to run a query
Find out when a user came on the site, where he came from, what link he then clicked on, then after that, how long was he on each page

(Sorry bout using he, it could be a she as well)

[marcus]

Your best solution would actually using a different row for each one.

Or you can create a table for each IP, but that would be ever worse, haha. I understand what you're saying, and your first theory with over 90,000 rows, yes that would be alot, like only 30-60mb of SQL usage.

[onlyican]

so I am looking for a way of recording the stats without using MySQL.
Thanks mgallforever, but thats the perpose of this post. as I said, I know several options, but I dont want to mention them cos I want people to mention them to me

[SharkBait]

A bit similar, but check out [url=http://www.google.com/analytics]Google's Analytics[/url] Not that it will show you how its coded, but its a free service that Google offers that tracks site information.

Google bought out Urchin so its similar to one of the more popular sitetracking applications out there.

Just an idea.. that's all.

[onlyican]

Me and my friend registered for this at the same time, just after they released it

I have it now, but he does not.
Isn't there like a massive waiting list for it

[onlyican]

I have been told about working with the server

For Apache Bases hosting
http://httpd.apache.org/docs/2.0/mod/mod_log_config.html

[ataria]

OR. If your using cpanl, you can just go to 'stats' and then go to 'awstats'
and it tells you a shitload of useful information.

and, it doesn't stress your DB.
Try it :]

[onlyican]

and I know that as I mentioned I want something like awstats, as we use Plesk not Cpanel, and we want to build something in the admin, not another dir like cpanel