<?php
include('../../includes/configuration.php'); 

// Query to fetch total user count and sum of balance
$query = "SELECT COUNT(*) AS total_users, SUM(balance) AS total_balance FROM users";
$result = mysqli_query($conn, $query);

if ($result) {
    $data = mysqli_fetch_assoc($result);
    echo json_encode([
        'totalUsers' => $data['total_users'],
        'totalBalance' => $data['total_balance']
    ]);
} else {
    echo json_encode([
        'totalUsers' => 0,
        'totalBalance' => 0
    ]);
}

mysqli_close($conn);
?>