Re: [fw-general] Zend_Db -> last query with values

[Isaak Malik]

Here's my debug template which uses the ZFW DB profiler:

http://paste2.org/p/40615

Use it and/or copy anything you like.

On Wed, Jun 18, 2008 at 4:28 PM, dbowen <[EMAIL PROTECTED]> wrote:

>
>
> Mark Steudel-3 wrote:
> >
> > Hi All,
> >
> >
> >
> > I was wondering if it was possible to get back the last run query
> > including
> > the values that get swapped in place of the ?
> >
> >
> >
> > E.g. if I did:
> >
> > $id = 4;
> >
> >
> >
> > $sql = "SELECT id FROM table WHERE id = ?";
> >
> >
> >
> > $rows = $this->db->fetchAll( $sql, $id );
> >
> >
> >
> > echo $this->db->lastQuery();
> >
> >
> >
> > It would spit back SELECT id FROM table WHERE id = 4.
> >
> >
> >
> > I tried using the profiler, but it just gives me back the sql statement
> > before $id gets passed into it.
> >
> >
> >
> > Thanks, Mark
> >
> >
> >
> >
> >
>
> I was interested in this same type of output from the profiler. Here's what
> I ended up doing.
>
> $profiler = $db->getProfiller();
> $profiles = $pofiler->getQueryProfiles();
> foreach ($profiles as $query) {
>  $q = str_replace('?', '&lt;span style="background-color:
> yellow"&gt;%s&lt;/span&gt;', $query->getQuery());
>  $q = vsprintf($q, array_map(array($db, 'quote'),
> $query->getQueryParams()));
>  print "$q\n";
> }
>
> This gives me the actual queries with the replaced values highlighted.
>
> --
> View this message in context:
> http://www.nabble.com/Zend_Db--%3E-last-query-with-values-tp17738679p17983910.html
> Sent from the Zend Framework mailing list archive at Nabble.com.
>
>
-- 
Isaak Malik
Web Developer