getConnection();
// إحصائيات
$stats = [];
// إجمالي الزيارات
$query = "SELECT COUNT(*) as total FROM site_visits";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['total'] = $stmt->fetch(PDO::FETCH_ASSOC)['total'];
// زيارات اليوم
$query = "SELECT COUNT(*) as today FROM site_visits WHERE DATE(created_at) = CURDATE()";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['today'] = $stmt->fetch(PDO::FETCH_ASSOC)['today'];
// زيارات هذا الأسبوع
$query = "SELECT COUNT(*) as week FROM site_visits WHERE YEARWEEK(created_at) = YEARWEEK(NOW())";
$stmt = $db->prepare($query);
$stmt->execute();
$stats['week'] = $stmt->fetch(PDO::FETCH_ASSOC)['week'];
// آخر 20 زيارة
$query = "SELECT v.*, u.name as user_name, u.phone
FROM site_visits v
LEFT JOIN users u ON v.user_id = u.id
ORDER BY v.created_at DESC
LIMIT 20";
$stmt = $db->prepare($query);
$stmt->execute();
$visits = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
إحصائيات الزيارات
آخر الزيارات
| الزائر |
الجهاز |
المتصفح |
IP |
الصفحة |
الوقت |
|
|
|
|
|
|
|