query("SELECT role FROM users WHERE id = {$_SESSION['user_id']}")->fetch_assoc();
if ($check['role'] !== 'admin') die("Access Denied");
// 1. Get Totals
$today = date('Y-m-d');
$views_today = $conn->query("SELECT COUNT(*) as c FROM site_analytics WHERE DATE(visited_at) = '$today'")->fetch_assoc()['c'];
$unique_today = $conn->query("SELECT COUNT(DISTINCT ip_address) as c FROM site_analytics WHERE DATE(visited_at) = '$today'")->fetch_assoc()['c'];
$total_views = $conn->query("SELECT COUNT(*) as c FROM site_analytics")->fetch_assoc()['c'];
// 2. Chart Data (Last 7 Days)
$chart_labels = [];
$chart_data = [];
for ($i = 6; $i >= 0; $i--) {
$d = date('Y-m-d', strtotime("-$i days"));
$chart_labels[] = date('M d', strtotime($d));
$chart_data[] = $conn->query("SELECT COUNT(*) as c FROM site_analytics WHERE DATE(visited_at) = '$d'")->fetch_assoc()['c'];
}
// 3. Top Countries
$countries = $conn->query("SELECT country, COUNT(*) as c FROM site_analytics GROUP BY country ORDER BY c DESC LIMIT 5");
// 4. Device Stats
$mobile = $conn->query("SELECT COUNT(*) as c FROM site_analytics WHERE device_type = 'Mobile'")->fetch_assoc()['c'];
$desktop = $conn->query("SELECT COUNT(*) as c FROM site_analytics WHERE device_type = 'Desktop'")->fetch_assoc()['c'];
?>
Website Analytics
Traffic Analytics
Page Views (Today)
Unique Visitors (Today)
Total Lifetime Views
Traffic Trend (7 Days)
Top Countries
fetch_assoc()): ?>
Device Type
Recent Visitors (Live Feed)
Time
IP Address
Country
OS / Browser
Page
query("SELECT * FROM site_analytics ORDER BY visited_at DESC LIMIT 20");
if($logs->num_rows > 0):
while($log = $logs->fetch_assoc()):
?>