<?php

include 'processerror.php';

set_error_handler("logmyerror");

//colect statdata
$page = $_SERVER ['PHP_SELF'];
$ip = $_SERVER['REMOTE_ADDR'];
$user = "";
logstats($page, $ip, $user);

// set database server access variables:
$host = "localhost";
$user = "root";
$pass = "09k6CcsGxBq7p";
$db = "userslogin";

// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$query = "SELECT
	YEAR(`created`) as YR,
	MONTH(`created`) as Month,
	DAY(`created`) as day,
	count(distinct `IP`) as distinct_users
FROM `stats`
GROUP BY
	YEAR(`created`),
	MONTH(`created`),
	DAY(`created`)
";
// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// see if any rows were returned
if (mysql_num_rows($result) > 0) {
    // yes
    // print them one after another

	   echo "<table cellpadding=10 border=1 align=center >";
    while($row = mysql_fetch_row($result)) {
        echo "<tr>";
        echo "<td>".$row[0]."</td>";
        echo "<td>" . $row[1]."</td>";
		echo "<td>". $row[2]."</td>";
		echo "<td>". $row[3]."</td>";
        echo "</tr>";
    }
      echo "</table>";

}
else {
    // no
    // print status message
    echo "No rows found!";
}

$query1 = "SELECT
	YEAR(`created`) as YR,
	MONTH(`created`) as Month,
	DAY(`created`) as day,
	`IP`,
	COUNT(*) as page_hits
FROM `stats`
GROUP BY
	YEAR(`created`),
	MONTH(`created`),
	DAY(`created`),
	`IP`
";
// execute query
$result1 = mysql_query($query1) or die ("Error in query: $query1. ".mysql_error());

// see if any rows were returned
if (mysql_num_rows($result1) > 0) {
    // yes
    // print them one after another

	   echo "<table cellpadding=10 border=1 align=center >";
    while($row = mysql_fetch_row($result1)) {
        echo "<tr>";
        echo "<td>".$row[0]."</td>";
        echo "<td>" . $row[1]."</td>";
		echo "<td>". $row[2]."</td>";
		echo "<td>". $row[3]."</td>";
		echo "<td>". $row[4]."</td>";
        echo "</tr>";
    }
      echo "</table>";

}
else {
    // no
    // print status message
    echo "No rows found!";
}

// free result set memory
mysql_free_result($result);

// close connection
mysql_close($connection);

?>