#推荐

乐博互娱转账脚本的详细修复方案

CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    from_user_id INT NOT NULL,
    to_user_id INT NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    status ENUM('pending', 'completed', 'failed') DEFAULT 'pending',
    transaction_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<?php
// 假设使用MySQL数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database_name");

if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// 获取转账请求参数
$from_user_id = $_POST['from_user_id']; // 转出用户ID
$to_user_id = $_POST['to_user_id']; // 转入用户ID
$amount = $_POST['amount']; // 转账金额

// 检查转账金额是否为正
if ($amount <= 0) {
    die("Invalid amount");
}

// 开始事务处理
$mysqli->begin_transaction();

try {
    // 1. 查询转出用户余额
    $result = $mysqli->query("SELECT balance FROM users WHERE id = $from_user_id");
    $from_user = $result->fetch_assoc();

    if ($from_user['balance'] < $amount) {
        throw new Exception("Insufficient balance");
    }

    // 2. 更新转出用户余额
    $mysqli->query("UPDATE users SET balance = balance - $amount WHERE id = $from_user_id");

    // 3. 更新转入用户余额
    $mysqli->query("UPDATE users SET balance = balance + $amount WHERE id = $to_user_id");

    // 4. 创建转账记录
    $mysqli->query("INSERT INTO transactions (from_user_id, to_user_id, amount, status) VALUES ($from_user_id, $to_user_id, $amount, 'completed')");

    // 提交事务
    $mysqli->commit();

    echo "Transfer successful";
} catch (Exception $e) {
    // 回滚事务
    $mysqli->rollback();
    
    echo "Transfer failed: " . $e->getMessage();
}

$mysqli->close();
?>