query("SELECT * FROM wallet_transactions WHERE id=$id")->fetch();
if ($req && $req['status'] == 'pending') {
// 1. Add Money
$pdo->prepare("UPDATE users SET wallet_balance = wallet_balance + ? WHERE id = ?")->execute([$req['amount'], $req['user_id']]);
// 2. Mark Approved
$pdo->prepare("UPDATE wallet_transactions SET status = 'approved' WHERE id = ?")->execute([$id]);
header("Location: wallet_requests.php?msg=approved");
}
}
// HANDLE REJECT
if (isset($_GET['reject'])) {
$pdo->prepare("UPDATE wallet_transactions SET status = 'rejected' WHERE id = ?")->execute([$_GET['reject']]);
header("Location: wallet_requests.php?msg=rejected");
}
// Fetch Pending Requests
$requests = $pdo->query("SELECT w.*, u.name, u.email FROM wallet_transactions w JOIN users u ON w.user_id = u.id WHERE w.status='pending' ORDER BY w.created_at DESC")->fetchAll();
?>
Wallet Requests