public function &getArticleInfo($id) { $article_info = new RokGallery_Link_Type_Article_Info(); $article_info->setId($id); $article_info->setLink('index.php?option=com_content&view=article&id=' . $id); //get the article info from joomla $db =& JFactory::getDBO(); // Get the articles $query = 'SELECT c.title' . ' FROM #__content AS c' . ' WHERE c.id = ' . $id; $db->setQuery($query); $article_info->setTitle($db->loadResult()); return $article_info; }
public function &getArticleInfo($id) { $article_info = new RokGallery_Link_Type_Article_Info(); $article_info->setId($id); $article_info->setLink('index.php?option=com_content&view=article&id=' . $id); /** @var $db JDatabase */ $db = JFactory::getDbo(); /** @var $query JDatabaseQuery */ $query = $db->getQuery(true); // Select the required fields from the table. $query->from('#__content AS a'); $query->select('a.title'); $query->where('a.id = ' . (int) $id); $db->setQuery((string) $query); if (!$db->query()) { JError::raiseError(500, $db->getErrorMsg()); } $article_info->title = $db->loadResult(); return $article_info; }
/** * @return string */ public function getUrl() { return $this->article->getLink(); }