How to see the query processed with php PDO?

Your best option would be to turn MySQL's general log option. Run the following in MySQL terminal (or any other preferred program / app you use to control MySQL) SET GLOBAL general_log = ON; SET GLOBAL general_log_file = 'path_to_file. Log'; Run your query, inspect the file.

Superb! Thnx, that was very useful! – Orhan Jul 26 at 13:08 If there is a syntax error or missing column/field in the query (which is one of the likely reasons for a PDOException being thrown), is it still going to log those?(partly for my curiosity, partly for general clarification) – Zimzat Jul 26 at 13:13 It'll log anything that actually gets to MySQL.

If you invoke a nonexisting function that throws a PDOException (assuming there is such error implementation), it won't log it. It will log failed queries in transaction, malformed queries and so on - basically anything reaching the MySQL daemon. – Michael J.V.Jul 26 at 13:23.

They really didn't need to extend the PDO class to do what they did. Simply create a new instance then add (or remove) that attribute after creation rather than during. That being said, there's a built-in way of outputting the debug information regarding a statement, and that's using PDOStatement->debugDumpParams.

This won't let you see the compiled version (that's done database-side for databases that support it) but it will let you see both the query and that bound parameters easily. A note of caution, don't enable this on a live system. It could give attackers of your website a big clue into how your system is set up and what they can do it take over (and destroy or otherwise ruin).

Thnx for the function! But that still doesn't output the values of the parameters. – Orhan Jul 26 at 13:33 ... Huh.So it doesn't.

I misread the examples on that page. I guess this is why Zend's Db adapter does its own encapsulation of all those aspects. – Zimzat Jul 26 at 16:45.

As far as I know, there is no way to see the actual query when using prepared statements.

Your best option would be to turn MySQL's general log option. Run the following in MySQL terminal (or any other preferred program / app you use to control MySQL).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.