如何从类别ID获取类别名称? [英] how to get category name from category id?

问题描述

我是joomla的新手.在我的模块中，我必须提供选择类别选项.我试图通过以下代码从后端获取类别名称，但它不起作用.代码..

I am new in joomla.In my module i have to give select category option. I tried to get category name from back-end by following code but it doesn't work.Code..

$backId=$params->get('mycategory');
$db->setQuery('SELECT cat.title FROM #__categories cat RIGHT JOIN #__content cont ON cat.id = cont.catid WHERE cont.id='.$backId);
$category_title = $db->loadResult();

if ($category_title)
{
    echo $category_title;
}

如何获取所选的类别名称.谢谢...

how can i get the category name that i selected.Thanks...

推荐答案

希望这可能有效.

$db = JFactory::getDbo();
$id = jrequest::getint('id');
//match id to cat.id from _categories set to variable $id
$db->setQuery("SELECT cat.title FROM #__categories cat WHERE cat.id='$id'");
$category_title = $db->loadResult();
echo "$id";
echo "$category_title";

这篇关于如何从类别ID获取类别名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！