phpeveryday.com

In the last tutorial, we showed link at front page. Now, we will add message text than only display link. It will help our reader to review before they decide to click that link. We do with simple way.

Open and edit "mod_hello.php":

<?php
defined('_JEXEC') or die('Restricted access');

$items = $params->get('items', 1);
$db =& JFactory::getDBO();
$query = "SELECT id, message 
                     FROM #__hello 
           		  WHERE published = '1' 
           		  ORDER BY id DESC";
$db->setQuery( $query, 0 , $items );
$rows = $db->loadObjectList();
foreach($rows as $row)
{
   	echo 'ID: <A href="'. JRoute::_
              ('index.php?option=com_hello&id='.$row->id.'&task=view') .'">'.$row->id.'</A> </br>';
  	echo $row->message .'</br>';
}
?>

We can use like substr() to limit characters.

It is simple way. But we have other choice than this way. The way that more efficient to handle different scenario. We will discuss next posting. Don't miss it!