php - PHP查询不会更新数据库中的记录

您好，我正在尝试从工作表中减去一个int接受的出价，并从客户表中的贷方中减去，但由于某种原因，它不会更新贷方行。任何想法为什么会这样？

表格：https://imgur.com/a/Sighm

<?php
session_start();
require 'config.php';


$id = $_SESSION['login_user'];
$jobid    = $_POST['job_id'];
$poster_id    = $_POST['poster_id'];
$accepted_bidder    = $_POST['accepted_bidder'];
$accepted_bid    = $_POST['accepted_bid'];

$query   = "SELECT credit FROM `customer` WHERE email_adress = '$.id'";

$success = $conn->query($query);

$updated_credit = $success - $accepted_bid
echo $updated_credit;


$query2   = " UPDATE job SET start_escrow = '1' WHERE  job_id = '$jobid'";
$success2 = $conn->query($query2);

$query3   = " UPDATE credit SET credit_amount = '$updated_credit' WHERE  credit_id = '$poster_id'";
$success3 = $conn->query($query3);

$poster_id = $_POST['poster_id'];

if (!$success) {
    die("Couldn't enter data: ".$conn->error);

}
 header("location: myjobs.php");

echo "Thank You For Contacting Us <br>";

$conn->close();




?>

最佳答案

您确定已启用自动提交吗？如果没有，则必须在每个$conn->query(...)之后指定$conn->commit，否则您可以创建交易，并且仅在最后输入代码