Re: DB troubleshooting with PDO
| From: | Wez Furlong | 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
>
>