Re: DB troubleshooting with PDO
| From: | Richard Thomas | Date: | Mon, 20 Mar 2006 19:28:14 +0000 |
| Subject: | Re: DB troubleshooting with PDO | ||
| References: | 1 2 3 4 | Groups: | php.pecl.dev |
| Request: | Send a blank email to pecl-dev+get-3634@lists.php.net to get a copy of this message | ||
Question is there a way to get a list of binded variables and there values?
Richard Thomas - CEO
Cyberlot Technologies Group Inc.
507.398.4124 - Voice
Richard Thomas wrote:
Thanks, that provides enough info to help, just have to figure out how to extend PDOStatement to save that, or put it directly in my code. Richard Thomas - CEO Cyberlot Technologies Group Inc. 507.398.4124 - Voice Wez Furlong wrote:The PDOStatement class has a queryString property (case sensitive naming it seems), that might be useful, but is subject to the caveat that you won't necessarily see the values with parameters replaced, simply because no such string exists for database APIs that have real prepared statements. --Wez. On 3/17/06, Richard Thomas <lists@cyberlot.net> wrote:Is it possible to somehow pull the final string submitted to mysql when you do a prepare/execute? What I would like to do is log all the querys in debug mode for troubleshooting and be able to review them afterwards. -- PECL development discussion Mailing List (http://pecl.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php