PHP 在多个查询和表上插入和更新

Question

在那里我想在一个条件下进行更新和创建，因此当我创建新记录时，如果我成功创建新记录，则会自动更新我的数据。

这是我的 PHP:

<?php 
require "dbconnection.php";

$a = array();
$a['transidmerchant'] = $_POST['TRANSIDMERCHANT'];
$a['totalamount'] =$_POST['AMOUNT'];
$a['words'] = $_POST['WORDS'];
$a['payment_channel'] = $_POST['PAYMENTCHANNEL'];
$a['session_id'] = $_POST['SESSIONID'];
$a['payment_date_time'] = $_POST['REQUESTDATETIME'];
$a['trxstatus'] = 'Requested';
$query = "INSERT INTO doku (transidmerchant,totalamount,words,payment_channel,session_id,payment_date_time,trxstatus) 
VALUES ('$_POST[TRANSIDMERCHANT]','$_POST[AMOUNT]','$_POST[WORDS]','$_POST[PAYMENTCHANNEL]','$_POST[SESSIONID]','$_POST[REQUESTDATETIME]','Requested')";

$sql = "UPDATE orders SET status='Paid' where id='$_POST[TRANSIDMERCHANT]'";
if(mysqli_query($con,$query)) {
    mysqli_connect($con,$sql);
    echo 1;
}else{
    echo("Error description: " . mysqli_error($con));
}

我的查询:$query 和 $sql

我希望我的 $sql 在 $query 成功创建时更新

Answer 1

if (mysqli_query($con, $query) === true) {
    mysqli_query($con, $sql);
    echo 1;
} else {
    echo('Error description: ' . mysqli_error($con));
}