database->getQuery

Returns the current value of the internal SQL query string (as set-up by database->setQuery).  The string has HTML special characters escaped and will be surrounded by HTML <pre> tags so that it is suitable for output to web browsers in an error message, for example.

Syntax

string getQuery ( )

Examples

Example:

function showQuery( $sql ) {
  global $database;
 
  $database->setQuery( $sql );
  echo 'The query is: ' . $database->getQuery();
}
 
$database->showQuery( 'SELECT * FROM #__users' );

would produce:

The query is: <pre>SELECT * FROM jos_users</pre>

Please report any errors on this page to the Developer Documentation Forum.