PHP在循环中准备语句和事务

可以通过将

prepare

bind_param

$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