» Funktion für catch (PDOException $e) mit SQL Query Ausgabe

function pdoStatementDebug($statement) {
	// obtain statement dump
	ob_start();
	$statement->debugDumpParams();
	$contents = ob_get_contents();
	ob_end_clean();
	// extract sql query
	$contents = substr($contents, 5, strrpos($contents, PHP_EOL . 'Params:'));
	// remove line breaks
	$contents = str_replace(array("\r", "\n"), '', $contents);
	// reduce consecutive whitespace
	$contents = preg_replace('#\s+#', ' ', $contents);
	return $contents;
}
function pdoException($exception, $statement) {
	echo $exception->getMessage() . ' (' . pdoStatementDebug($statement) . ') in ' . $exception->getFile() . ' (' . $exception->getLine() . ')' . '<br>' . PHP_EOL;
}

try {
	$sql = 'bogus SQL :query';
	$stmt = $db->prepare($sql);
	$stmt->execute(array(
		':query' => 'query',
	));
} catch (PDOException $e) { pdoException($e, $stmt); }

SQLSTATE[HY093]: Invalid parameter number ([177] bogus SQL :query) in /usr/www/inc/query.php (1084)

echo

Mach mit!