joomla 2.5 virtuemart中的数据库查询(database query in joomla 2.5 virtuemart)

joomla 2.5 virtuemart中的数据库查询(database query in joomla 2.5 virtuemart)

我编写了以下代码，从数据库中获取名为“app”的virtuemart类别id。 但它没有显示任何东西。请帮助。 我使用joomla 2.5和virtmart的最新版本

$db =& JFactory::getDBO(); $query = $db->getQuery(true); $query->select('virtuemart_category_id'); $query->from('#__virtuemart_categories_en_gb'); $query->where('category_name = "app" '); //put your condition here $db->setQuery($query); $o= $db->loadObjectList(); echo $o[0]->virtuemart_category_id;

我的数据库表前缀是nyhar_。 我在类别视图页面中编写了上面的代码，它没有显示任何内容。

I wrote the following code to get virtuemart category id with name "app" from database. but its not displaying anything.please help. I use joomla 2.5 and latest version of virtuemart

$db =& JFactory::getDBO(); $query = $db->getQuery(true); $query->select('virtuemart_category_id'); $query->from('#__virtuemart_categories_en_gb'); $query->where('category_name = "app" '); //put your condition here $db->setQuery($query); $o= $db->loadObjectList(); echo $o[0]->virtuemart_category_id;

my database table prefix is nyhar_ . I wrote the above code in category view page and it doesn't show anything.

最满意答案

尝试这个：

$db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('*'); $query->from('#__virtuemart_categories_en_gb'); $query->where('category_name = "app" '); $db->setQuery($query); $o= $db->loadResult(); echo $o;

要选择id值，可以使用$query->select('virtuemart_category_id');

Try this:

$db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('*'); $query->from('#__virtuemart_categories_en_gb'); $query->where('category_name = "app" '); $db->setQuery($query); $o= $db->loadResult(); echo $o;

To select an id value, you can use $query->select('virtuemart_category_id');