Re: DB troubleshooting with PDO

From: Date: Tue, 21 Mar 2006 07:10:29 +0000
Subject: Re: DB troubleshooting with PDO
References: 1 2 3 4 5  Groups: php.pecl.dev 
Request: Send a blank email to pecl-dev+get-3636@lists.php.net to get a copy of this message
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 (#3636) next »