Simple PHP/MySQL script that logs all of the search engine queries used to find the site (in Google, Yahoo, MSN and AOL)
- List them by how many hits the query has been used per day
- List by day/date and delete data older than 7 days
- List the last 50 queries used to find the site
- Password protect the stats
Most pages I want tracked are .php, so basicly I just want to add a php include line to my pages. (The index page are in .shtml though so if possible I also need a ssi include line.) A database is already open on the php pages using:
$open = mysql_connect($host, $username, $password)
I would like the database table to be named 'referrers'.
It's VERY IMPORTANT that the script is fast and efficient as it will track about 50,000 searches per day.
Here is an example of the kind of script I'm looking for (it lacks some of the features I listed though and I don't need the redirect thing)
[url removed, login to view]
Use PMB for any questions.