可以通过将prepareand 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();
602392714
清零编程群