[PDO] Displaying output from prepare()?

Gilles Ganault schreef:
> Hello
>
> I use the prepare/execute combo to generate SQL statements. Is it
> possible to actually see what PDO creates with prepare()?
>
> =======
> $sql = "INSERT INTO mytable (id, label) VALUES (NULL,?)";
> $insert = $dbh->prepare($sql);
>
> //Display SQL before running it
>
> $insert->execute(array($argv[1]));
> =======
>
> Thank you.

Hi Gilles,

As far as I know: No.
However, if you are on a bughunt, you can probably ask your database
itself to log anything that is executed against it in a logfile.

Regards,
Erwin Moller

--
============================
Erwin Moller
Now dropping all postings from googlegroups.
Why? http://improve-usenet.org/
============================
 >> Stay informed about: [PDO] Displaying output from prepare()? 

Gilles Ganault escribió:
> I use the prepare/execute combo to generate SQL statements. Is it
> possible to actually see what PDO creates with prepare()?

I guess you want to see the SQL query with the value of your parameters,
something like: INSERT INTO mytable (id, label) VALUES (NULL,'Foo Bar')

I suppose these internals depend on the driver but I'd dare say that
"INSERT INTO mytable (id, label) VALUES (NULL,?)" is what's actually
sent to the database server, with the values being sent separately.

--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
 >> Stay informed about: [PDO] Displaying output from prepare()? 

On Tue, 07 Oct 2008 12:17:14 -0400, Jerry Stuckle
<jstucklex RemoveThis @attglobal.net> wrote:
>Unfortunately not.

Too bad. Thanks guys.
 >> Stay informed about: [PDO] Displaying output from prepare()? 

..oO(Gilles Ganault)

>I use the prepare/execute combo to generate SQL statements. Is it
>possible to actually see what PDO creates with prepare()?

See <news:em6a35-1r3.ln1@ophelia.g5n.co.uk>.

Micha
 >> Stay informed about: [PDO] Displaying output from prepare()?