Skip to content

Instantly share code, notes, and snippets.

@twysto

twysto/Display a readable DQL Query (Doctrine 1.2)

Created March 3, 2017 10:56
Show Gist options
  • Save twysto/3ed0f89007e18150f5bf7bd6b0d9564c to your computer and use it in GitHub Desktop.
Save twysto/3ed0f89007e18150f5bf7bd6b0d9564c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Display a readable DQL Query (Doctrine 1.2)
<?php
// Paste it before $query->execute()
die(
vsprintf(
strtr(
$query->getSqlQuery(),
array(
'?' => '%s',
'%' => '%%'
)
),
$query->getFlattenedParams()
)
);
// Shorter
die(vsprintf(strtr($query->getSqlQuery(),array('?'=>'%s','%'=>'%%')),$query->getFlattenedParams()));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment