alert('提现金额不能低于1元，请重新输入');window.location.href='../withdrawal.php' "; exit(); // 结束代码的执行 } $tx_type = $_POST['tx_type']; // 对 $tx_type 进行验证和过滤 $cr_time = $_POST['cr_time']; // 获取时间戳 $proxy_acc = $_POST ['proxy_acc']; // 根据 $tx_type 的值，获取其他表单字段的值 if ($tx_type == '1') { $alipay_name = $_POST['alipay_name']; // 对 $alipay_name 进行验证和过滤 $alipay_account = $_POST['alipay_account']; // 对 $alipay_account 进行验证和过滤 // 执行提现操作 $sql = "UPDATE proxy SET proxy_balance = proxy_balance - ? WHERE proxy_acc = ?"; $stmt = mysqli_prepare($con, $sql); mysqli_stmt_bind_param($stmt, "ds", $tx_price, $proxy_acc); mysqli_stmt_execute($stmt); mysqli_stmt_close($stmt); // 将数据插入到数据库表中 $sql = "INSERT INTO withdrawal (proxy_acc, tx_price, tx_type, tx_name, tx_acc, cr_time) VALUES (?, ?, ?, ?, ?, ?)"; $stmt = mysqli_prepare($con, $sql); mysqli_stmt_bind_param($stmt, "sdssss", $proxy_acc, $tx_price, $tx_type, $alipay_name, $alipay_account, $cr_time); if(mysqli_stmt_execute($stmt)){ echo " "; }else{ echo " "; } mysqli_stmt_close($stmt); } elseif ($tx_type == '2') { $tx_name = $_POST['tx_name']; // 对 $tx_name 进行验证和过滤 $tx_acc = $_POST['tx_acc']; // $tx_acc 进行验证和过滤 $bank_name = $_POST['bank_name']; // 对 $bank_name 进行验证和过滤 $bank_branch = $_POST['bank_branch']; // 对 $bank_branch 进行验证和过滤 // 执行提现操作 $sql = "UPDATE proxy SET proxy_balance = proxy_balance - ? WHERE proxy_acc = ?"; $stmt = mysqli_prepare($con, $sql); mysqli_stmt_bind_param($stmt, "ds", $tx_price, $proxy_acc); mysqli_stmt_execute($stmt); mysqli_stmt_close($stmt); // 将数据插入到数据库表中 $sql = "INSERT INTO withdrawal (proxy_acc, tx_price, tx_type, tx_name, tx_acc, tx_bank_name, tx_bank_zh, cr_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; $stmt = mysqli_prepare($con, $sql); mysqli_stmt_bind_param($stmt, "sdssssss", $proxy_acc, $tx_price, $tx_type, $tx_name, $tx_acc, $bank_name, $bank_branch, $cr_time); if(mysqli_stmt_execute($stmt)){ echo " "; }else{ echo " "; } mysqli_stmt_close($stmt); } } ?>