connect_error) die("Database connection failed: " . $conn->connect_error); // --- Admin session check --- if (!isset($_SESSION['admin'])) $_SESSION['admin'] = 'Admin'; // --- Create balance table if not exists --- $conn->query(" CREATE TABLE IF NOT EXISTS balance ( id INT AUTO_INCREMENT PRIMARY KEY, user VARCHAR(100) UNIQUE, amount DECIMAL(15,2) DEFAULT 0 ); "); // --- Ensure transaction table exists --- $conn->query(" CREATE TABLE IF NOT EXISTS transaction ( id INT AUTO_INCREMENT PRIMARY KEY, user VARCHAR(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; "); // --- Ensure required columns exist --- $required_columns = [ 'admin' => "VARCHAR(100) DEFAULT NULL", 'type' => "ENUM('credit','debit') DEFAULT 'credit'", 'amount' => "DECIMAL(15,2) DEFAULT 0", 'old_balance' => "DECIMAL(15,2) DEFAULT 0", 'new_balance' => "DECIMAL(15,2) DEFAULT 0", 'reason' => "VARCHAR(255) DEFAULT NULL", 'created_at' => "DATETIME DEFAULT CURRENT_TIMESTAMP" ]; foreach($required_columns as $col => $definition){ $check = $conn->query("SHOW COLUMNS FROM transaction LIKE '$col'"); if($check->num_rows==0){ $conn->query("ALTER TABLE transaction ADD COLUMN $col $definition"); } } // --- Handle AJAX endpoints --- if (isset($_GET['action'])) { $act = $_GET['action']; // Live autocomplete for fund form if ($act == 'search_user' && isset($_GET['term'])) { $term = "%{$_GET['term']}%"; $stmt = $conn->prepare("SELECT user FROM balance WHERE user LIKE ? LIMIT 10"); $stmt->bind_param("s", $term); $stmt->execute(); $res = $stmt->get_result(); $users = []; while ($row = $res->fetch_assoc()) $users[] = $row['user']; echo json_encode($users); exit; } // Modal transaction view if ($act == 'transactions' && isset($_GET['user'])) { $user = $_GET['user']; $stmt = $conn->prepare("SELECT * FROM transaction WHERE user=? ORDER BY id DESC"); $stmt->bind_param("s", $user); $stmt->execute(); $res = $stmt->get_result(); echo "

Transactions for: $user

"; if ($res->num_rows==0) echo "

No transactions found.

"; else { echo ""; while($t=$res->fetch_assoc()){ echo ""; } echo "

Type	Amount	Old	New	Reason	Admin	Date
".ucfirst($t['type'])."	".number_format($t['amount'],2)."	".number_format($t['old_balance'],2)."	".number_format($t['new_balance'],2)."	".htmlspecialchars($t['reason'])."	".htmlspecialchars($t['admin'])."	".htmlspecialchars($t['created_at'])."

"; } $stmt->close(); exit; } // Top search box filter if ($act == 'top_search' && isset($_GET['term'])) { $term = "%{$_GET['term']}%"; // Balances $stmt = $conn->prepare("SELECT * FROM balance WHERE user LIKE ? ORDER BY id DESC"); $stmt->bind_param("s",$term); $stmt->execute(); $res_bal = $stmt->get_result(); echo "

User Balances

"; if($res_bal->num_rows==0) echo "

No users found.

"; else { echo ""; while($b=$res_bal->fetch_assoc()){ echo ""; } echo "

User	Amount	Action
".htmlspecialchars($b['user'])."	".number_format($b['amount'],2)."

"; } $stmt->close(); // Transactions $stmt = $conn->prepare("SELECT * FROM transaction WHERE user LIKE ? ORDER BY id DESC LIMIT 20"); $stmt->bind_param("s",$term); $stmt->execute(); $res_trans = $stmt->get_result(); echo "

Recent Transactions

"; if($res_trans->num_rows==0) echo "

No transactions found.

"; else { echo ""; while($t=$res_trans->fetch_assoc()){ echo ""; } echo "

User	Type	Amount	Old	New	Admin	Date
".htmlspecialchars($t['user'])."	".ucfirst($t['type'])."	".number_format($t['amount'],2)."	".number_format($t['old_balance'],2)."	".number_format($t['new_balance'],2)."	".htmlspecialchars($t['admin'])."	".htmlspecialchars($t['created_at'])."

"; } $stmt->close(); exit; } } // --- Handle fund/debit POST --- $message = ""; if ($_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['user'], $_POST['action'], $_POST['amount'])) { $user = trim($_POST['user']); $action = strtolower(trim($_POST['action'])); $amount = floatval($_POST['amount']); $reason = trim($_POST['reason'] ?? ''); $admin = $_SESSION['admin']; $date = date('Y-m-d H:i:s'); if ($user!=="" && $amount>0 && in_array($action,['credit','debit'])) { $stmt = $conn->prepare("SELECT amount FROM balance WHERE user=? LIMIT 1"); $stmt->bind_param("s",$user); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows==0) { $conn->query("INSERT INTO balance (user,amount) VALUES ('$user',0.00)"); $current_balance = 0.00; } else $current_balance = floatval($result->fetch_assoc()['amount']); $stmt->close(); if ($action=='credit') $new_balance = $current_balance + $amount; else { if ($current_balance<$amount) $message="

Insufficient funds for $user.

"; $new_balance = $current_balance - $amount; } if (empty($message)) { $stmt = $conn->prepare("UPDATE balance SET amount=? WHERE user=?"); $stmt->bind_param("ds",$new_balance,$user); $stmt->execute(); $stmt->close(); $stmt = $conn->prepare("INSERT INTO transaction (user,admin,type,amount,old_balance,new_balance,reason,created_at) VALUES (?,?,?,?,?,?,?,?)"); $stmt->bind_param("sssdddss",$user,$admin,$action,$amount,$current_balance,$new_balance,$reason,$date); $stmt->execute(); $stmt->close(); $message="

".ucfirst($action)." successful for $user!

"; } } else $message="

Invalid input!

"; } // --- Fetch balances and transactions --- $balances = $conn->query("SELECT * FROM balance ORDER BY id DESC"); $transactions = $conn->query("SELECT * FROM transaction ORDER BY id DESC LIMIT 20"); ?> Admin Dashboard

Admin Dashboard

Fund / Debit User

User Balances

num_rows==0): ?>

No users found.

fetch_assoc()): ?>

User	Amount	Action

Recent Transactions

num_rows==0): ?>

No transactions found.

fetch_assoc()): ?>

User	Type	Amount	Old	New	Admin	Date