prepare("SELECT email FROM customers WHERE id=? LIMIT 1");
$q->bind_param("i",$id);
$q->execute();
$email = $q->get_result()->fetch_assoc()['email'] ?? null;
$q->close();
if ($email) {
$conn->query("DELETE FROM balance WHERE user='".$conn->real_escape_string($email)."'");
}
$del = $conn->prepare("DELETE FROM customers WHERE id=? LIMIT 1");
$del->bind_param("i",$id);
$del->execute();
$del->close();
exit("ok");
}
/* ================= SEARCH USERS (AJAX) ================= */
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['search'])) {
$search = trim($_POST['search']);
$stmt = $conn->prepare("
SELECT c.*, IFNULL(b.amount,0) balance
FROM customers c
LEFT JOIN balance b ON b.user = c.email
WHERE c.email LIKE CONCAT('%',?,'%')
ORDER BY c.id DESC
LIMIT 100
");
$stmt->bind_param("s",$search);
$stmt->execute();
$res = $stmt->get_result();
while($u = $res->fetch_assoc()):
?>
₦
query("SELECT COUNT(*) c FROM customers")->fetch_assoc()['c'];
$activeUsers = $conn->query("SELECT COUNT(*) c FROM customers WHERE is_active=1")->fetch_assoc()['c'];
$inactiveUsers = $conn->query("SELECT COUNT(*) c FROM customers WHERE is_active=0")->fetch_assoc()['c'];
$todayLogins = $conn->query("
SELECT COUNT(*) c
FROM customers
WHERE last_login IS NOT NULL
AND DATE(last_login) = CURDATE()
")->fetch_assoc()['c'];
/* ================= USERS LIST ================= */
$users = $conn->query("
SELECT c.*, IFNULL(b.amount,0) balance
FROM customers c
LEFT JOIN balance b ON b.user = c.email
ORDER BY c.id DESC
LIMIT 200
");
?>
Admin Users