Developing a Model-View-Controller (MVC) Component for Joomla!1.6 – Part 06

DROP TABLE IF EXISTS `#__helloworld`;     CREATE TABLE `#__helloworld` (    `id` int(11) NOT NULL AUTO_INCREMENT,    `greeting` varchar(25) NOT NULL,     PRIMARY KEY  (`id`)  ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;     INSERT INTO `#__helloworld` (`greeting`) VALUES  	('Hello World!'),  	('Good bye World!');  

<?xml version="1.0" encoding="utf-8"?>  <extension type="component" version="1.6.0" method="upgrade">     	<name>Hello World!</name>  	<!-- The following elements are optional and free of formatting conttraints -->  	<creationDate>November 2009</creationDate>  	<author>John Doe</author>  	<authorEmail>john.doe@example.org</authorEmail>  	<authorUrl>http://www.example.org</authorUrl>  	<copyright>Copyright Info</copyright>  	<license>License Info</license>  	<!--  The version string is recorded in the components table -->  	<version>0.0.6</version>  	<!-- The description is optional and defaults to the name -->  	<description>Description of the Hello World component ...</description>     	<install> <!-- Runs on install -->  		<sql>  			<file driver="mysql" charset="utf8">sql/install.mysql.utf8.sql</file>  		</sql>  	</install>  	<uninstall> <!-- Runs on uninstall -->  		<sql>  			<file driver="mysql" charset="utf8">sql/uninstall.mysql.utf8.sql</file>  		</sql>  	</uninstall>  	<update> <!-- Runs on update; New in 1.6 -->  		<schemas>  			<schemapath type="mysql">sql/updates/mysql</schemapath>  		</schemas>  	</update>     	<!-- Site Main File Copy Section -->  	<!-- Note the folder attribute: This attribute describes the folder  		to copy FROM in the package to install therefore files copied  		in this section are copied from /site/ in the package -->  	<files folder="site">  		<filename>index.html</filename>  		<filename>helloworld.php</filename>  		<filename>controller.php</filename>  		<folder>views</folder>  		<folder>models</folder>  	</files>     	<administration>  		<!-- Administration Menu Section -->  		<menu>Hello World!</menu>  		<!-- Administration Main File Copy Section -->  		<!-- Note the folder attribute: This attribute describes the folder  			to copy FROM in the package to install therefore files copied  			in this section are copied from /admin/ in the package -->  		<files folder="admin">  			<!-- Admin Main File Copy Section -->  			<filename>index.html</filename>  			<filename>helloworld.php</filename>  			<!-- SQL files section -->  			<folder>sql</folder>  			<!-- tables files section -->  			<folder>tables</folder>  			<!-- models files section -->  			<folder>models</folder>  		</files>  	</administration>     </extension>  

DROP TABLE IF EXISTS `#__helloworld`;  

<?xml version="1.0" encoding="utf-8"?>  <metadata>  	<layout title="COM_HELLOWORLD_HELLOWORLD_VIEW_DEFAULT_TITLE">  		<message>COM_HELLOWORLD_HELLOWORLD_VIEW_DEFAULT_DESC</message>  	</layout>  	<fields  		name="request"  		addfieldpath="/administrator/components/com_helloworld/models/fields"  	>  		<fieldset name="request">  			<field  				name="id"  				type="helloworld"  				label="COM_HELLOWORLD_HELLOWORLD_FIELD_GREETING_LABEL"  				description="COM_HELLOWORLD_HELLOWORLD_FIELD_GREETING_DESC"  			/>  		</fieldset>  	</fields>  </metadata>  

<?php  // No direct access to this file  defined('_JEXEC') or die;     // import the list field type  jimport('joomla.form.helper');  JFormHelper::loadFieldClass('list');     /**   * HelloWorld Form Field class for the HelloWorld component   */  class JFormFieldHelloWorld extends JFormFieldList  {  	/**  	 * The field type.  	 *  	 * @var		string  	 */  	protected $type = 'HelloWorld';     	/**  	 * Method to get a list of options for a list input.  	 *  	 * @return	array		An array of JHtml options.  	 */  	protected function getOptions()   	{  		$db = JFactory::getDBO();  		$query = $db->getQuery(true);  		$query->select('id,greeting');  		$query->from('#__helloworld');  		$db->setQuery((string)$query);  		$messages = $db->loadObjectList();  		$options = array();  		if ($messages)  		{  			foreach($messages as $message)   			{  				$options[] = JHtml::_('select.option', $message->id, $message->greeting);  			}  		}  		$options = array_merge(parent::getOptions(), $options);  		return $options;  	}  }  

<?php  // No direct access to this file  defined('_JEXEC') or die('Restricted access');     // import Joomla modelitem library  jimport('joomla.application.component.modelitem');     /**   * HelloWorld Model   */  class HelloWorldModelHelloWorld extends JModelItem  {  	/**  	 * @var string msg  	 */  	protected $msg;     	/**  	 * Returns a reference to the a Table object, always creating it.  	 *  	 * @param	type	The table type to instantiate  	 * @param	string	A prefix for the table class name. Optional.  	 * @param	array	Configuration array for model. Optional.  	 * @return	JTable	A database object  	 * @since	1.6  	 */  	public function getTable($type = 'HelloWorld', $prefix = 'HelloWorldTable', $config = array())   	{  		return JTable::getInstance($type, $prefix, $config);  	}  	/**  	 * Get the message  	 * @return string The message to be displayed to the user  	 */  	public function getMsg()   	{  		if (!isset($this->msg))   		{  			$id = JRequest::getInt('id');  			// Get a TableHelloWorld instance  			$table = $this->getTable();     			// Load the message  			$table->load($id);     			// Assign the message  			$this->msg = $table->greeting;  		}  		return $this->msg;  	}  }  

<?php  // No direct access  defined('_JEXEC') or die('Restricted access');     // import Joomla table library  jimport('joomla.database.table');     /**   * Hello Table class   */  class HelloWorldTableHelloWorld extends JTable  {  	/**  	 * Constructor  	 *  	 * @param object Database connector object  	 */  	function __construct(&$db)   	{  		parent::__construct('#__helloworld', 'id', $db);  	}  }