PHP在循环中准备好的语句和事务 [英] PHP prepared statements and transactions in a loop
问题描述
循环代码中的经典交易:
The classic transactions in a loop code:
$mysqli->query("START TRANSACTION");
foreach ($pdata as $key => $value) {
$sql = "INSERT INTO temp (`fund_id`) VALUES (" . $value . ")";
$result = $mysqli->query($sql);
}
$mysqli->query("COMMIT");
然后我们更改为准备好的语句:
Then we change to prepared statements:
$mysqli->autocommit(FALSE);
foreach ($pdata as $key => $value) {
$sql = "INSERT INTO temp (`fund_id`) VALUES (?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $value);
$stmt->execute();
}
$mysqli->commit();
问题:
1)这两个代码是否相同?我是否在第二个代码中缺少带有准备好的语句的内容?
1) Are these two codes identical? Am I missing something in the second code with prepared statements?
2)$mysqli->commit()
与$mysqli->query("COMMIT")
相同吗?
3)我是否需要为准备好的语句块添加$mysqli->query("START TRANSACTION");
,否则当我们设置autocommit(FALSE)
时事务将自动开始吗?
3) Do I need to add $mysqli->query("START TRANSACTION");
for the prepared statements block or the transaction will automatically start when we set autocommit(FALSE)
?
推荐答案
可以通过将prepare
和bind_param
语句拉出循环来优化循环.
Your loop can be optimized by pulling the prepare
and bind_param
statements out of the loop.
$value = null;
$mysqli->autocommit(FALSE);
$sql = "INSERT INTO temp (`fund_id`) VALUES (?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $value);
foreach ($pdata as $value) {
$stmt->execute();
}
$mysqli->commit();
您已经关闭了autocommit(FALSE)
行的自动提交功能,因此不需要使用START TRANSACTION
语句.
You have turned off autocommit with your autocommit(FALSE)
line and therefore don't need to use the START TRANSACTION
statement.
这篇关于PHP在循环中准备好的语句和事务的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!