Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

PHP MySQLi multi_query prepared statement

Tags:

php

mysql

bind

prepared-statement

mysqli

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

like image 537
ATLChris Avatar asked Feb 02 '11 23:02

ATLChris

1 Answers

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.

like image 196
lonesomeday Avatar answered Sep 21 '22 12:09

lonesomeday
Sign in to Comment

Related questions

Generate unique random alphanumeric characters that are 7 characters long
sh equivalent of __FILE__
How to convert images to pdf using PHP? [closed]
Static or not static?
Simple torrent system in PHP?
ob_get_level() starts at level 1
Display value of bindParam using PHP PDO
Get a specific child tag from a DOMElement in PHP
Effects of method chaining
Naming conventions - Working with PHP and MySQL
POST to password protected URL?
CodeIgniter - force_download() no output
DOMDocument::validate() problem
I was just hacked, but I don't know how or more importantly, why. Very odd code injected
"Trying to get properties on a non-object" in PHP
Redirecting a page to another page for 5 seconds then redirecting again
CakePHP Cookies getting scrambled - Suhosin related
How can I match a Russian word using preg_replace in PHP?
Gmail mark as spam email with html and anchor links
PHP long polling, without excessive database access

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!