如何获取Joomla文章的标题？

Question

I have designed a Joomla template. I want to bring my articles on my template, I have written code that is bring article body text on my template but neither image nor title is coming up. Can anyone help please ?

$query = "select * from jh7na_content order by id desc limit 2";
$sql = mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($sql)){
    echo "<div id='div1' style='border='2px';'>".html_entity_decode($row['introtext'])."</div>";             
}

Answer 1

A few things you should know. Firstly, if you want to show an article, why not create a menu item, and assign an article to it in the Joomla backend? Secondly, your query is only showing the article text because you have told it to and are not calling the Title. Thirdly, you should be using Joomla coding standards, especially when making database queries, like so:

$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*')
 ->from('#__content')
 ->order('id DESC');
$db->setQuery($query,0,2);
$rows = $db->loadObjectList();

foreach($rows as $row){
    echo "<div class='title'>" . $row['title']. "</div>"; 
    echo "<div class='introtext'>" . $row['introtext']. "</div>"; 
}

However, as stated before, you should assign an article to a menu item.

Hope this helps