Skip to content

Instantly share code, notes, and snippets.

@gruz
Created June 2, 2018 17:45
Show Gist options
  • Save gruz/cb2ef9b11a1944ef88e3db13fd150cb6 to your computer and use it in GitHub Desktop.
Save gruz/cb2ef9b11a1944ef88e3db13fd150cb6 to your computer and use it in GitHub Desktop.
Joomla output SQL query
<?php
// Usage
echo $db->replacePrefix((string) $query) ;
// Example
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select( 'id' );
$query->from($db->quoteName('#__kunena_categories'));
$query->where($db->quoteName('parent_id') . '=' . $db->quote( $parent_id ));
$query->where($db->quoteName('name') . '=' . $db->quote( $title ));
$db->setQuery($query);
echo $db->replacePrefix((string) $query) ;
$result = $db->loadResult();;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment