PHP prepared statements and transactions in a loop [duplicate]

by

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();

You have turned off autocommit with your autocommit(FALSE) line and therefore don’t need to use the START TRANSACTION statement.

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to change mysql to mysqli?
  3. How to prevent duplicate usernames when people register?
  4. Best way to INSERT many values in mysqli?
  5. SELECT COUNT(*) AS count – How to use this count
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. How to call a MySQL stored procedure from within PHP code?
  12. MySQLi count(*) always returns 1
  13. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  14. Do I have to guard against SQL injection if I used a dropdown?
  15. Using Mysqli bind_param with date and time columns?
  16. Using MySQLi from another class in PHP
  17. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  18. Unknown database error in PHP but it exists in PHPMyAdmin
  19. Can I blindly replace all mysql_ functions with mysqli_?
  20. How do detect that transaction has already been started?
  21. Using PHP to execute multiple MYSQL Queries
  22. Get number of rows matched by UPDATE query with PHP mysqli
  23. How to use mysqli_query() in PHP?
  24. How to run multiple insert query in SQL using PHP in one go?
  25. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  26. Which is fastest in PHP- MySQL or MySQLi?
  27. mysqli persistent connection
  28. Create mysql trigger via PHP?
  29. How to get a list of databases?
  30. How to make mysqli connect function?

Leave a Comment