~~~ class MyPDOStatement extends PDOStatement { protected $_debugValues = null; protected function __construct() { // need this empty construct()! } public function execute($values=array()) { $this->_debugValues = $values; try { $t = parent::execute($values); // maybe do some logging here? } catch (PDOException $e) { // maybe do some logging here? throw $e; } return $t; } public function _debugQuery($replaced=true) { $q = $this->queryString; if (!$replaced) { return $q; } return preg_replace_callback('/:([0-9a-z_]+)/i', array($this, '_debugReplace'), $q); } protected function _debugReplace($m) { $v = $this->_debugValues[$m[1]]; if ($v === null) { return "NULL"; } if (!is_numeric($v)) { $v = str_replace("'", "''", $v); } return "'". $v ."'"; } } // have a look at http://www.php.net/manual/en/pdo.constants.php $options = array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_STATEMENT_CLASS => array('MyPDOStatement', array()), ); // create PDO with custom PDOStatement class $pdo = new PDO($dsn, $username, $password, $options); // prepare a query $query = $pdo->prepare("INSERT INTO mytable (column1, column2, column3) VALUES (:col1, :col2, :col3)"); // execute the prepared statement $query->execute(array( 'col1' => "hello world", 'col2' => 47.11, 'col3' => null, )); // output the query and the query with values inserted //http://stackoverflow.com/questions/7716785/get-last-executed-query-in-php-pdo var_dump( $query->queryString, $query->_debugQuery() ); ~~~