php - mysqli_multi_query 不工作，没有任何反应

Question

我正在尝试做一个 mysqli_multi_query。由于某种原因，它不会工作。这是我到目前为止所做的:

<?php
$con=mysqli_connect("host","user","pw","db");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

   $orderid = $_GET['orderid'];
   $sql = "INSERT INTO orders_archive SELECT * FROM orders WHERE orders_id='".$orderid."'";
   $sql .= "DELETE FROM orders WHERE orders_id='".$orderid."'";


mysqli_multi_query($con,$sql);

mysqli_close($con);
?>

orderid 由ajax 给出。

Answer 1

查询必须用;分隔。

$sql = "INSERT INTO orders_archive SELECT * FROM orders WHERE orders_id='".$orderid."';";
$sql .= "DELETE FROM orders WHERE orders_id='".$orderid."'";