How can I display the full text of a query created by PDO?

Question

I'm creating a SQL query with PDO in PHP. Unfortunately, there seems to be an error in my query. I've tried $query->errorInfo(), but that only gives me a little bit of the error message ("There is an error in your syntax near...").

How can I display the entire query that PDO is passing to my database?

TIA.

Why don't you just post the problematic code so we can tell you what's wrong? — Matthew Flaschen, Jun 26 '09 at 03:25

score 3 · Accepted Answer · edited May 23 '17 at 12:29

3

You can't really. This has been discussed here before, see this:

Getting raw SQL query string from PDO prepared statements

edited May 23 '17 at 12:29

Community

1
1

answered Jun 26 '09 at 03:23

karim79

339,989
67
413
406

Thanks for showing me that - one of the comments had the answer. Sorry - thought I had searched hard enough, guess not. Much appreciated. – benjy Jun 26 '09 at 03:26

How can I display the full text of a query created by PDO?

1 Answers1

Linked