How to get parent category title for Tag view

Question

I want to get my current article's category and parent category link into my page. I get the category via the following code:

$db = JFactory::getDbo();
$id = $item->core_catid;
$db->setQuery("SELECT cat.title FROM #__categories cat WHERE cat.id='$id'");
$category = $db->loadResult();
echo '<p>'.$category.'</p>';

But I do not manage to get the parent category anyway. I try this but get no results:

$db->setQuery("SELECT cat.title FROM #__categories cat WHERE cat.parent_id='$id'");

Answer 1

Try this(tested and worked in Joomla 3.3.0):

Put this code:

<?php
$db = JFactory::getDbo();
$id = $item->core_catid;
$db->setQuery("SELECT cat.parent_id FROM #__categories cat WHERE cat.id='$id'");
$parent_category_id = $db->loadResult();
$db->setQuery("SELECT cat.title FROM #__categories cat WHERE cat.id='$parent_category_id'");
$parent_category_title = $db->loadResult();
if($parent_category_title != 'ROOT'){
 echo '<p>Parent Category: '.$parent_category_title.'</p>';
}
echo '<p>Parent Category: <a href="index.php?option=com_content&view=category&layout=blog&id='.$parent_category_id.'">'.$parent_category_title.'</a></p>';
?>

into this file:

templates/yourtemplate/html/com_tags/default_items.php

copy from:

components\com_tags\views\tags\tmpl\default_items.php

between this two lines

<?php foreach ($items as $i => $item) : ?> //Line 63
<?php endforeach; ?>

Answer 2

Surely in your article options you can just set 'Show Category', 'Link Category, 'Show Parent' and 'Link Parent' to 'Show' (category) and 'Yes' (link).

Answer 3

I think you could do this using the Content model to load the article.

/* Lets say the article ID is stored in $id */

/* Get an instance of the generic articles model */
$model = JModelLegacy::getInstance('Articles', 'ContentModel');
$myArticle = $model->getItem($id);

$categoryID = $myArticle->catid; /* catid = "9" */
$category_title = $myArticle->category_title; /* category_title = "Blog" */
$category_alias = $myArticle->category_alias; /* category_alias = "blog" */

$parent_id = $myArticle->parent_id; /* parent_id = "1" */
$parent_title = $myArticle->parent_title; /* parent_title = "ROOT" */
$parent_alias = $myArticle->parent_alias; /* parent_alias = "root" */

The values shown in the right-hand side comments are what I just pulled out of a demo install of Joomla 3.3 with the "Blog" sample content installed. Note the value of the root category.