MySQL查询有/无表特定引用

Question

In Joomla 2.5.14, when I create a query to MySQL using PHP, like:

$query = "SELECT id FROM xmb9d_content WHERE state=1" ;

It all works fine, but if I don't want a specific reference to the database prefix (xmb9d_) and use:

$query = "SELECT id FROM #__content WHERE state=1" ;

The query isn't executed. Is this the right way of building the query or what is wrong with this code?

Answer 1

You need to use the database prefix and also stick to Joomla 2.5 coding standards. There shouldn't be any problems with the prefix, providing your query is correct.

This is how it should look:

$db = JFactory::getDbo();

$query = $db->getQuery(true);
$query->select('id')
 ->from('#__content')
 ->where('state = 1');

$db->setQuery($query);

$results = $db->loadObjectList();