Re: DB troubleshooting with PDO

From: Date: Tue, 21 Mar 2006 19:11:56 +0000
Subject: Re: DB troubleshooting with PDO
References: 1 2 3 4 5 6  Groups: php.pecl.dev 
Request: Send a blank email to pecl-dev+get-3641@lists.php.net to get a copy of this message
Having problems using that, I get the following, it keeps outputting the key info over and over until I kill it. SQL: [47] SELECT value FROM sessions WHERE sesskey = :key Params: 1 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: paramno=0 name=[4] :key is_param=1 param_type=2 Key: Position #1453675312: ENDLESS LOOP, SAME THING OVER AND OVER Richard Thomas - CEO Cyberlot Technologies Group Inc. 507.398.4124 - Voice Wez Furlong wrote:
There's a debugDumpParams() method on the PDOStatement object that outputs debugging information about binds to the output buffer. --Wez. On 3/20/06, Richard Thomas <lists@cyberlot.net> wrote:
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
-- PECL development discussion Mailing List (http://pecl.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


« previous php.pecl.dev (#3641) next »