PDOStatement::debugDumpParams

debugDumpParams.php

<?php

try {
  $dbh = new PDO('mysql:host=127.0.0.1;dbname=mysql', 'root', 'pwd');

	$host = 'localhost';
	$sth = $dbh->prepare('SELECT * FROM user WHERE Host = :host');
	$sth->bindValue(':host', $host, PDO::PARAM_STR);
	$sth->execute();

	ob_start();
	$sth->debugDumpParams();
	$dump = ob_get_contents();
	ob_end_clean();
	
  $sth = null;
  $dbh = null;

  $tmp = explode("\n", $dump);
  var_dump(substr($tmp[1], stripos($tmp[1], 'SELECT')));

} catch (PDOException $e) {
  print "Error!: " . $e->getMessage() . PHP_EOL;
}
die();