我想比较一下数据库中的用户余额和输入量。如果数据库中的用户余额低于(int) 10。表单输入为(int) 12。
在下面的代码中,如果发件人没有在表单中输入足够的余额,我希望发件人看到“余额不足”;
public function makeTransactions($from, $amount, $to) {
try {
$check = $this->db->prepare("SELECT balance FROM `Users` WHERE `email` = '$from' ");
$check->execute();
$available = $check->fetch(PDO::FETCH_ASSOC);
if ($available < $amount) {
$msg = "Insufficient balance!";
return $msg;
} else {
$sendNow = $this->db->prepare("UPDATE `Users` SET balance = balance-'$amount' WHERE `email` = '$from' ");
$proceed = $sendNow->execute();
if ($proceed) {
$proceed = $this->db->prepare("UPDATE `Users` SET balance = balance+'$amount' WHERE `email` = '$to' ");
$result = $proceed->execute();
if ($result) {
$msg = "Transaction successful";
return $msg;
} else {
$msg = "Transaction failed";
return $msg;
}
}
}
}
}发布于 2022-11-28 13:08:41
https://stackoverflow.com/questions/74600740
复制相似问题