connect_error) {
die("Verbindung zur Datenbank fehlgeschlagen: " . $conn->connect_error);
}
// Abfrage für die Anzahl der Benutzer
$sql = "SELECT COUNT(*) as total_users FROM UserAccounts";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$totalUsers = $row['total_users'];
// Abfrage für die Anzahl der Regionen
$sql = "SELECT COUNT(*) as total_regions FROM regions";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$totalRegions = $row['total_regions'];
// Abfrage für die Anzahl der Online-Benutzer
$sql = "SELECT COUNT(*) as online_users FROM Presence WHERE LastSeen > NOW() - INTERVAL 5 MINUTE";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$onlineUsers = $row['online_users'];
// Abfrage für die letzten Transaktionen
$sql = "SELECT sender, receiver, amount, time FROM transactions ORDER BY time DESC LIMIT 5";
$result = $conn->query($sql);
$recentTransactions = [];
while ($row = $result->fetch_assoc()) {
$recentTransactions[] = $row;
}
// Abfrage für die letzten Benutzer
$sql = "SELECT PrincipalID, FirstName, LastName, Created FROM UserAccounts ORDER BY Created DESC LIMIT 5";
$result = $conn->query($sql);
$recentUsers = [];
while ($row = $result->fetch_assoc()) {
$recentUsers[] = $row;
}
// Abfrage für die Gesamtsumme der Transaktionen
$sql = "SELECT SUM(amount) as total_amount FROM transactions";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$totalTransactions = $row['total_amount'];
// Abfrage für die Regionen mit den meisten Besuchern
$sql = "SELECT RegionID, COUNT(*) as visit_count FROM Presence GROUP BY RegionID ORDER BY visit_count DESC LIMIT 5";
$result = $conn->query($sql);
$topRegions = [];
while ($row = $result->fetch_assoc()) {
$topRegions[] = $row;
}
// Abfrage für die letzten Benutzeraktivitäten
$sql = "SELECT UserID, LastSeen FROM Presence ORDER BY LastSeen DESC LIMIT 5";
$result = $conn->query($sql);
$recentActivities = [];
while ($row = $result->fetch_assoc()) {
$recentActivities[] = $row;
}
// Verbindung schließen
$conn->close();
?>
<?php echo SITE_NAME; ?> Analytics