在mysql_query中触发多个查询

Question

$updateStock = "UPDATE opening SET qtyUsed = 1000 WHERE openingId = 1 ; UPDATE purchase SET qtyUsed = qtyUsed + 25 WHERE purchaseId = 1";

$updateAllStock = mysql_query($updateStock);

这会产生错误：Data Not InsertedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE purchase SET qtyUsed = qtyUsed + ' at line 3

Answer 1

mysql_query一次只能执行一个查询。您需要执行两次mysql_query。

使用mysqli而不是mysql扩展。使用mysqli，您可以执行多个查询。http://www.php.net/manual/fr/mysqli.multi-query.php

Answer 2

您可以使用mysqli_query()，它允许多个语句。注意。

Answer 3

您要发送两个查询，因此必须查询数据库两次。mysqli中支持多个查询，但我强烈建议不要使用此功能，因为这样会增加SQL注入攻击的可能性。

$updateStock = "UPDATE opening SET qtyUsed = 1000 WHERE openingId = 1";
$updatePurchase = "UPDATE purchase SET qtyUsed = qtyUsed + 25 WHERE purchaseId = 1";

$updateAllStock = mysql_query($updateStock);
$updateAllPurchase = mysql_query($updatePurchase);