PHP 多个查询

Question

是不是不能在不同的表上同时执行插入和删除？或者我错过了什么

if(isset($_POST['update']))

{

    $id = $_POST['delete_id'];

    $name= $_POST['edit_name'];

    $name2= $_POST['edit_name2'];

    $pic = $_POST['edit_pic'];

    $contactnumber = $_POST['edit_contact'];

    $address = $_POST['edit_address'];

    $details = $_POST['edit_details'];

    $query = "INSERT INTO tabletest (name,name2,pic,contact,address,details,) VALUES ('$name' , '$name2' , '$pic' , '$contactnumber' , '$address' , '$details')";

    $query .= "DELETE FROM tabletest2 WHERE id='$id'";

    if (mysqli_multi_query($connection, $query))

    {

        $_SESSION['success'] = "Data Updated";

        header('Location: blankpage.php');

    } 

    else 

    {

        $_SESSION['status'] = "Error, Please try again";

        header('Location: blankpage.php');

    }

    

}

Answer 1

可以同时执行 DELETE 和 INSERT，但它们需要是单独的查询。如果您想让这两个操作都成为原子操作（都必须成功，否则都不应该执行），那么您需要使用DB transactions。要将 2 个查询作为单个原子语句执行，您可以执行以下操作：mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);$connection = new mysqli();$connection->set_charset('utf8mb4'); // always set the charsetif (isset($_POST['update'])) {    $id = $_POST['delete_id'];    $name = $_POST['edit_name'];    $name2 = $_POST['edit_name2'];    $pic = $_POST['edit_pic'];    $contactnumber = $_POST['edit_contact'];    $address = $_POST['edit_address'];    $details = $_POST['edit_details'];    // start transaction    $connection->begin_transaction();    try {        $stmt = $connection->prepare('INSERT INTO tabletest (name,name2,pic,contact,address,details,) VALUES (?,?,?,?,?,?)');        $stmt->bind_param('ssssss', $name, $name2, $pic, $contactnumber, $address, $details);        $stmt->execute();        $stmt = $connection->prepare('DELETE FROM tabletest2 WHERE id=?');        $stmt->bind_param('s', $id);        $stmt->execute();            // save data and end transaction        $connection->commit();        $_SESSION['success'] = "Data Updated";        header('Location: blankpage.php');    } catch (Exception $e) {        $connection->rollback();        $_SESSION['status'] = "Error, Please try again";        header('Location: blankpage.php');    }}