bind_param and execute in loop?

Question

Is it possible to invoke bind_param and execute iteratively, or must I prepare a statement at the beginning of each iteration?

$query = $db->prepare('...');
foreach ($dataItem as $item) {
    $query->bind_param($v1, $v2, ..., $item);
    $query->execute();
}
$query->close();

If I do have to recreate the statement each iteration, is it possible to optimize this process?

Thank you!

hakre · Accepted Answer · 2011-07-24 11:50:52Z

7

There is no need to prepare a statement at the beginning of each iteration.

The concept of prepared statements is to reuse the same statement multiple times in the first place, so it's good to go to prepare once and execute it multiple times.

See also this note on the manual page.

edited Jul 24, 2011 at 11:50

answered Jul 24, 2011 at 11:42

hakre

200k55 gold badges454 silver badges867 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

bind_param and execute in loop?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related