echo full joomla query (with limit etc)?

php joomla1.5
SoulieBaby picture SoulieBaby · Mar 7, 2012 · Viewed 8.3k times · Source

I was wondering if there was a way to echo out the full query with limit and limitstart etc. I can echo out the line $query, but i want to see why the limit isn't working and I can't seem to get it to display the actual query that it's sending to the database.. Here's the code:

$params =& JComponentHelper::getParams('com_news');
$limit = $params->get('x_items', 5);
$limitstart = JRequest::getVar('limitstart', 0);

$query = "SELECT * FROM #__news WHERE published = 1 AND catid = ".$Itemid." ORDER BY date DESC";
$db->setQuery($query, $limitstart, $limit);
$rows = $db->loadObjectList();

$db->getQuery($query, $limitstart, $limit); is only displaying "SELECT * FROM jos_news WHERE published = 1 AND catid = 8 ORDER BY date DESC" which doesnt have the LIMIT params on the end of the query..

Any help would be appreciated :)

Answer

None picture None · Feb 1, 2013

The JDatabaseQuery object has a __toString() function that outputs the query so you can do:

echo $db->getQuery();

Or if you want to pass it to a function you can explicitly cast it to a string first:

var_dump((string)$db->getQuery());

Related questions

How can I create a new Joomla user account from within a script?

We're creating an XML API for Joomla that allows partner sites to create new accounts for their users on our website. We've created a standalone PHP script that processes and validates the API request, but now we need to actually …

Read More
How to get the path to the current template in Joomla 1.5?

I'm writing a component and would like to insert images from the template folder. How do you get the correct path to the template folder?

Read More
How do I resolve a strpos() "empty delimiter" error?

Here's the error: For: PHP 5.2+ Warning: strpos() [function.strpos]: Empty delimiter in /helper.php on line 445 and here is the code on that line: if($src = $img->getAttribute('src') AND strpos($src,$fgParams->get('base')) === false) { // prevents repeat …

Read More