Visitor Specific Analysis - PHP

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'];
}