tags:

views:

101

answers:

1
Q: 

Get the Actual SQL of a Prepared Statement with mysqli??

Is there any way to get the actual SQL that is the result of preparing a statement when using the mysqli extension?

My problem: I am using prepared statements. In all cases, they SHOULD update a record. I am not catching any errors. However, when I check for affected rows, there are none. So, I want to see the actual SQL that would be executed as a result of the prepare statement.

Is there any way to do this? I've check the mysqli reference docs, but they don't seem to have anything.

A: 

Look at this question for answers to you question.

Davide Gualano  2009-09-18 00:00:15
Funny, just did that myself. I don't know how you managed to know that answer was around though. Of course, this only works if you have control of the DB server.... If you don't it seems you're out of luck.
Justin  2009-09-18 00:02:45
I was browsing through questions tagged 'mysqli', and I stumbled in that question and immediately after in your own :)And yes, you have to turn logging on the mysql server to achieve what you need.
Davide Gualano  2009-09-18 00:08:03

related questions

mysqli problem - prepared statements
mysqli binding fields in a prepared statement
How can I get every n rows in MySQL?
mysqli bind variables
Converting mysql to mysqli - how to get superglobal connection object?
php giving a blank page, no errors
converting from mysql to mysqli - outputting variables
The counterpart of mysqli::real_escape_string?
Limit a MySQL query to an even number of results (using PHP and mysqli)
Getting a PHP DateTime object into a string representation of a MYSQL date
Ensuring MySQL connection works in PHP function
mysqli prepared statements and REPLACE INTO
using nulls in a mysqli prepared statement
Do MySQL prepared queries provide a performance benefit for once-per-session queries?
mysqli->error: Is it for the last query only, or for the last error from the query group?
Is there a way to see a prepared query as it will be executed on the database?
Is there a way to bind an array to mysqli prepare
Empty string in not-null column in MySQL?
Which is fastest in PHP- MySQL or MySQLi?
Possible to use multiple/nested MySQLi statements?
mysqli_statement::num_rows() returns the wrong value
PHP + MySql + Stored Procedures, how do I get access an "out" value?
Using MySQLi - which is better for closing queries
mysqli or PDO - what are the pros and cons?
PHP + MYSQLI: Variable parameter/result binding with prepared statements.