PHP MySQLi multi_query prepared statement

Question

I wanted to know if it is possible to prepare multiple statements for MySQLi multi_query?

lonesomeday · Accepted Answer · 2011-02-03 00:34:33Z

8

No.

mysqli::multi_query takes a query string as its argument, not a prepared statement.

mysql::prepare can only prepare a single statement:

The query must consist of a single SQL statement.

answered Feb 3, 2011 at 0:34

lonesomeday

239k54 gold badges330 silver badges329 bronze badges

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

3 Comments

Fernando Silva Over a year ago

I've got a question. If a prepared statement is a best practice to avoid SQL Injection, how would you perform multiple INSERTS on multiple tables, maintaining the benefits of prepared statements? Would you break each SQL statement into single prepared statements and just cascade them at the database or is there a one-hit solution? I just need some term or expression I can google and learn about.

Pavel V. Over a year ago

@FernandoSilva: I use transactions for this - see this answer for this specific problem and this question and its answers (not only the first one) for transactions.

Fernando Silva Over a year ago

@PavelV. Thanks, just read up on what you mentioned, that would do the trick for me. I eventually bumped into transactions without even knowing that's what it was called. Thanks once again^^

Collectives™ on Stack Overflow

PHP MySQLi multi_query prepared statement

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related