php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #39287 PDO: Get last executed query
Submitted: 2006-10-28 03:26 UTC Modified: 2021-10-27 12:48 UTC
Votes:19
Avg. Score:4.7 ± 0.7
Reproduced:14 of 14 (100.0%)
Same Version:2 (14.3%)
Same OS:2 (14.3%)
From: waax at yahoo dot com Assigned:
Status: Open Package: PDO related
PHP Version: 5.1.6 OS:
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: waax at yahoo dot com
New email:
PHP Version: OS:

 

 [2006-10-28 03:26 UTC] waax at yahoo dot com
Description:
------------
Getting the last executed query would be helpful for debugging. Something like:

<?php
$stmt->execute();
print $stmt->getLastQuery();

?>


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-04-29 03:48 UTC] fcardinaux at gmail dot com
Such a feature would be useful for profiling as well. 

The software profiler I use transforms each SELECT statement into an EXPLAIN SELECT, which cannot work unless the parameters are replaced by the values used when the query is executed.
 [2021-10-27 12:48 UTC] cmb@php.net
-Package: Feature/Change Request +Package: PDO related
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Nov 21 14:01:29 2024 UTC