Tracking Website Statistics with PHP - Visitor Specific Analysis (
Page 3 of 4 )
Number of times user visited:
$query = "SELECT count(*) FROM stattracker WHERE ip =
'127.0.0.1'";
$result=mysql_query($query);
while ($row =mysql_fetch_array($result)) {
echo "Visited " .$row['count(*)']. " times";
}
Here I'm checking how many times a particular user visited the site. In this case the visitor is identified by their IP address.
Pages user visited
$query = "SELECT *,count(*) FROM stattracker WHERE ip =
'127.0.0.1' GROUP BY page";
$result=mysql_query($query);
while ($row =mysql_fetch_array($result)) {
echo "Page: " .$row['page']. "Viewed: ".$row['count(*)']. "<br>";
}
Browser used when visiting
$query = "SELECT *,count(*) FROM stattracker WHERE ip =
'127.0.0.1' GROUP BY browser";
$result=mysql_query($query);
while ($row =mysql_fetch_array($result)) {
echo "Browser used: " .$row['browser']. "Used: ".$row['count
(*)']. "times<br>";
}
Number of visits by this user in last 30 days:
$query = "SELECT *,COUNT(*) FROM stattracker WHERE ip =
'127.0.0.1' AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) GROUP BY
page";
$result=mysql_query($query);
while ($row =mysql_fetch_array($result)) {
echo "Page: " .$row['page']. "Viewd: ".$row['COUNT(*)']. "times<br>";
}
Page Specific Analysis
How many times a particular page has been visited:
$query = "SELECT count(*) FROM stattracker WHERE page =
'/pagename.php'";
$result=mysql_query($query);
while ($row =mysql_fetch_array($result)) {
echo "Visited " .$row['count(*)']. " times";
}
Who visits this page?
$query = "SELECT *,count(*) FROM stattracker WHERE page =
'/pagename.php' GROUP BY ip";
$result=mysql_query($query);
while ($row =mysql_fetch_array($result)) {
echo "Visited " .$row['count(*)']. " times. By: ".$row['ip'];
}
