Viewing File: /home/quiczmwg/bitmaven.org/admin/update_balance.php

<?php
// ========================================
// update_balance.php
// ========================================

// Always include DB FIRST
require_once("../_db.php");

// ========================================
// HANDLE FORM SUBMISSION (POST REQUEST)
// ========================================
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['btnEditAmount'])) {

    $newBalance       = (float) $_POST['newBalance'];
    $newProfitBalance = (float) $_POST['newProfitBalance'];
    $id               = (int) $_POST['id'];

    $sql = "UPDATE user_login 
            SET account_balance = ?, profit_balance = ? 
            WHERE id = ?";

    $stmt = $conn->prepare($sql);
    if (!$stmt) {
        die("Prepare failed: " . $conn->error);
    }

    // d = double, d = double, i = integer
    $stmt->bind_param("ddi", $newBalance, $newProfitBalance, $id);

    if ($stmt->execute()) {
        header("Location: info.php");
        exit; // STOP execution after redirect
    } else {
        die("Update failed: " . $stmt->error);
    }
}

// ========================================
// HANDLE PAGE LOAD (GET REQUEST)
// ========================================
if (!isset($_GET['id'])) {
    die("Invalid request.");
}

$id = (int) $_GET['id'];

$sql = "SELECT account_balance, profit_balance 
        FROM user_login 
        WHERE id = ?";

$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->bind_result($currentBalance, $currentProfitBalance);
$stmt->fetch();
$stmt->close();

// ========================================
// NOW IT IS SAFE TO INCLUDE HTML FILES
// ========================================
include 'head.php';
include 'header.php';
?>
<body class="skin-default fixed-layout">
    <div id="main-wrapper">
        <?php include 'sidebar.php'; ?>
        <div class="page-wrapper">
            <section>
                <div class="">
                    <?php include 'nav1.php'; ?>
                    <div class="container-fluid">
                        <div class="card">
                            <div class="card-header">
                                <!-- </?php echo isset($_SESSION['mgs']) ? $_SESSION['mgs'] : "" ?> -->
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table">
                                        <tbody>
                                            <!-- HTML Form for updating balance -->
                                            <form action="update_balance.php" method="post">
    <div class="form-group">
        <label for="newBalance">New Balance:</label>
        <input type="text" class="form-control" name="newBalance" value="<?php echo $currentBalance; ?>" required>
    </div>
    <div class="form-group">
        <label for="newProfitBalance">New Profit Balance:</label>
        <input type="text" class="form-control" name="newProfitBalance" value="<?php echo $currentProfitBalance; ?>" required>
    </div>
    <!-- Hidden input to pass user ID -->
    <input type="hidden" name="id" value="<?php echo $id; ?>">
    <button type="submit" name="btnEditAmount" class="btn btn-success">Update Balance</button>
</form>

                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </div>
    <?php include 'footer.php'; ?>
</body>
</html>
Back to Directory File Manager
<