phpeveryday.com

In this tutorial, we will build a screen that lists all of the messages in database. We start with simple grid.

1. Open "admin.hello.html.php" file and replace showHello() with following code:

   
   <?
   	function showHello($rows){
   	?>
   	<form action="index.php" 
              method="post" name="adminForm">    
       <table class="adminlist">
       <thead>
       	<tr>
           	<th width="20">
               <input type="checkbox" name="toggle"
               value="" 
    onclick="checkAll(<?php echo count($rows)?>)">
               </th>
               <th width="50" class="title">ID</td>
               <th>Message</th>
               <th nowrap="nowrap">Published</th>
           </tr>
       </thead>
       <?php
       $k = 0;
   	for($i=0, $n=count($rows); $i < $n ; $i++)
   	{
   		$row = &$rows[$i];
   		$checked 	= JHTML::_('grid.id', $i, $row->id);
   		$published 	= JHTML::_('grid.published', $row, $i); 
   		?>
           <tr class="<?php echo "row$k"; ?>">
           	<td><?php echo $checked?></td>
           	<td><?php echo $row->id?></td>
           	<td><?php echo $row->message?></td>            
           	<td><?php echo $published?></td>            
           </tr>
           <?
   		$k = 1 - $k;
   	}
   	?>
       </table>
       <input type="hidden" name="option" value="com_hello">
       <input type="hidden" name="task" value="">    
       <input type="hidden" name="boxchecked" value="0">    
       </form>
       <?php
   	}
   ?>
   

2. Open admin.hello.php, replace showHello() with following code:

   
   function showHello(){
       $db =& JFactory::getDBO();
   	$query = "SELECT * FROM #__hello";
   	$db->setQuery( $query );
   	$rows = $db->loadObjectList();
   	if($db->getErrorNum()){
   		echo $db->stderr();
   		return false;
   	}
    	HTML_contact::showHello($rows);
   }