File "fetch_user_data.php"

Full path: /home/julaysp1/public_html/admin/order/list/fetch_user_data.php
File size: 558 B (558 B bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor &nnbsp; Back

<?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);
?>