Archived:Developing a MVC Component/Using the database - Revision history

M-b-o: M-b-o moved page J2.5:Developing a MVC Component/Using the database to Archived:Developing a MVC Component/Using the database

2022-04-26T22:18:50Z

M-b-o moved page J2.5:Developing a MVC Component/Using the database to Archived:Developing a MVC Component/Using the database

← Older revision	Revision as of 22:18, 26 April 2022
(No difference)

Tom Hutchison: Hutchy68 moved page J2.5:Developing a Model-View-Controller Component/Using the database to J2.5:Developing a MVC Component/Using the database: trying to shorten title

2013-05-03T19:46:46Z

Hutchy68 moved page J2.5:Developing a Model-View-Controller Component/Using the database to J2.5:Developing a MVC Component/Using the database: trying to shorten title

← Older revision	Revision as of 19:46, 3 May 2013
(No difference)

Tom Hutchison: Hutchy68 moved page Developing a Model-View-Controller Component/2.5/Using the database to J2.5:Developing a Model-View-Controller Component/Using the database: namespacing

2013-05-03T19:38:11Z

Hutchy68 moved page Developing a Model-View-Controller Component/2.5/Using the database to J2.5:Developing a Model-View-Controller Component/Using the database: namespacing

← Older revision	Revision as of 19:38, 3 May 2013
(No difference)

Marcodings: replace depricated JRequest by JInput

2013-02-07T13:32:41Z

replace depricated JRequest by JInput

← Older revision		Revision as of 13:32, 7 February 2013
Line 257:		Line 257:
	{		{
	//request the selected id		//request the selected id
	$id = ~~JRequest~~::~~getInt~~('id');		$jinput = JFactory::getApplication()->input;
			$id = $jinput->get('id', 1, 'INT' );

	// Get a TableHelloWorld instance		// Get a TableHelloWorld instance

Neo314: After following the tutorial failed, I found this to be the problem.

2012-12-24T07:38:31Z

After following the tutorial failed, I found this to be the problem.

← Older revision		Revision as of 07:38, 24 December 2012
Line 30:		Line 30:

	'''Important Note:''' When the component is installed, the files in the SQL updates folder (for example, ''admin/sql/updates/mysql'') are read and the name of the last file alphabetically is used to populate the component's version number in the <code>#__schemas</code> table. This value must be in this table in order for the automatic update to execute the update SQL files for future versions. For this reason, it is good practice to create a SQL update file for each version (even if it is empty or just has a comment). This way the <code>#__schemas</code> version will always match the component version.		'''Important Note:''' When the component is installed, the files in the SQL updates folder (for example, ''admin/sql/updates/mysql'') are read and the name of the last file alphabetically is used to populate the component's version number in the <code>#__schemas</code> table. This value must be in this table in order for the automatic update to execute the update SQL files for future versions. For this reason, it is good practice to create a SQL update file for each version (even if it is empty or just has a comment). This way the <code>#__schemas</code> version will always match the component version.

			'''Important Note:''' When saving the SQL files in utf8, be sure to save them as utf8 NO BOM or the query will fail with MySQL error #1064.

	This is the install file. It will be executed if you put an appropriate order in the ''helloworld.xml'' file		This is the install file. It will be executed if you put an appropriate order in the ''helloworld.xml'' file

Chefren: Correction for "messages" variable array in site/models/helloworld.php

2012-12-06T02:04:49Z

Correction for "messages" variable array in site/models/helloworld.php

← Older revision		Revision as of 02:04, 6 December 2012
Line 225:		Line 225:
	* @var array messages		* @var array messages
	*/		*/
	protected $~~msg~~;		protected $messages;

	/**		/**

Morrizon: Display correct code from zip

2012-10-23T08:53:30Z

Display correct code from zip

← Older revision		Revision as of 08:53, 23 October 2012
Line 153:		Line 153:
	<source lang="php">		<source lang="php">
	<?php		<?php

	/**
	* @version $Id: hello.php 15 2009-11-02 18:37:15Z chdemko $
	* @package Joomla16.Tutorials
	* @subpackage Components
	* @copyright Copyright (C) 2005 - 2010 Open Source Matters, Inc. All rights reserved.
	* @author Christophe Demko
	* @link http://joomlacode.org/gf/project/helloworld_1_6/
	* @license License GNU General Public License version 2 or later
	*/

	// No direct access to this file		// No direct access to this file
	defined('_JEXEC') or die~~('Restricted access')~~;		defined('_JEXEC') or die;

	// import ~~Joomla modelitem library~~		// import the list field type
	jimport('joomla.~~application~~.~~component.modelitem~~');		jimport('joomla.form.helper');
			JFormHelper::loadFieldClass('list');

	/**		/**
	* HelloWorld ~~Model~~		* HelloWorld Form Field class for the HelloWorld component
	*/		*/
	class ~~HelloWorldModelHelloWorld~~ extends ~~JModelItem~~		class JFormFieldHelloWorld extends JFormFieldList
	{		{
	/**		/**
	* @var string ~~msg~~		* The field type.
			*
			* @var string
	*/		*/
	protected $~~msg~~;		protected $type = 'HelloWorld';

	/**		/**
	* ~~Returns~~ a ~~reference to the~~ a ~~Table object, always creating it~~.		* Method to get a list of options for a list input.
	*		*
	* @~~param type The table type to instantiate~~		* @return array An array of JHtml options.
	* @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()~~)		protected function getOptions()
	{		{
	~~return JTable~~::~~getInstance~~($~~type,~~ $~~prefix~~, $~~config~~);		$db = JFactory::getDBO();
	}		$query = $db->getQuery(true);
	/**		$query->select('id,greeting');
	* Get the message		$query->from('#__helloworld');
	* @return string ~~The message to be displayed to the user~~		$db->setQuery((string)$query);
	*/		$messages = $db->loadObjectList();
	~~public function getMsg~~()		$options = array();
	{		if ($messages)
	if ~~(!isset~~($~~this->msg)~~)
	{		{
	~~$id = JRequest::getInt~~(~~'id');~~		foreach($messages as $message)
	~~// Get a TableHelloWorld instance~~		{
	$~~table =~~ $~~this->getTable(~~);		$options[] = JHtml::_('select.option', $message->id, $message->greeting);
			}
	~~// Load the message~~
	$~~table->load~~($~~id);~~

	~~// Assign the~~ message
	~~$this~~->~~msg =~~ $~~table~~->greeting;
	}		}
	return $~~this->msg~~;		$options = array_merge(parent::getOptions(), $options);
			return $options;
	}		}
	}		}

Bguernouti at 22:04, 19 October 2012

2012-10-19T22:04:42Z

← Older revision		Revision as of 22:04, 19 October 2012
Line 153:		Line 153:
	<source lang="php">		<source lang="php">
	<?php		<?php

			/**
			* @version $Id: hello.php 15 2009-11-02 18:37:15Z chdemko $
			* @package Joomla16.Tutorials
			* @subpackage Components
			* @copyright Copyright (C) 2005 - 2010 Open Source Matters, Inc. All rights reserved.
			* @author Christophe Demko
			* @link http://joomlacode.org/gf/project/helloworld_1_6/
			* @license License GNU General Public License version 2 or later
			*/

	// No direct access to this file		// No direct access to this file
	defined('_JEXEC') or die;		defined('_JEXEC') or die('Restricted access');

	// import ~~the list field type~~		// import Joomla modelitem library
	jimport('joomla.~~form~~.~~helper');~~		jimport('joomla.application.component.modelitem');
	~~JFormHelper::loadFieldClass('list~~');

	/**		/**
	* HelloWorld ~~Form Field class for the HelloWorld component~~		* HelloWorld Model
	*/		*/
	class ~~JFormFieldHelloWorld~~ extends ~~JFormFieldList~~		class HelloWorldModelHelloWorld extends JModelItem
	{		{
	/**		/**
	* The field type.		* @var string msg
	*
	* @var string
	*/		*/
	protected $~~type = 'HelloWorld'~~;		protected $msg;

	/**		/**
	* ~~Method~~ to ~~get a list of options for~~ a ~~list input~~.		* Returns a reference to the a Table object, always creating it.
	*		*
	* @~~return~~ array An array ~~of JHtml options~~.		* @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
	*/		*/
	~~protected~~ function ~~getOptions~~()		public function getTable($type = 'HelloWorld', $prefix = 'HelloWorldTable', $config = array())
	{		{
	~~$db = JFactory~~::~~getDBO~~();		return JTable::getInstance($type, $prefix, $config);
	$~~query =~~ $~~db->getQuery(true~~);		}
	~~$query->select('id,greeting');~~		/**
	~~$query->from('#__helloworld');~~		* Get the message
	~~$db->setQuery((~~string~~)$query);~~		* @return string The message to be displayed to the user
	~~$messages = $db->loadObjectList~~();		*/
	~~$options = array();~~		public function getMsg()
	if ($~~messages~~)		{
			if (!isset($this->msg))
	{		{
	~~foreach~~($~~messages as~~ $~~message~~)		$id = JRequest::getInt('id');
	{		// Get a TableHelloWorld instance
	$~~options[] = JHtml::_~~(~~'select.option',~~ $message->~~id,~~ $~~message~~->greeting);		$table = $this->getTable();
	}
			// Load the message
			$table->load($id);

			// Assign the message
			$this->msg = $table->greeting;
	}		}
	~~$options = array_merge(parent::getOptions(), $options);~~		return $this->msg;
	return $~~options~~;
	}		}
	}		}

Bguernouti at 22:00, 19 October 2012

2012-10-19T22:00:34Z

← Older revision		Revision as of 22:00, 19 October 2012
Line 225:		Line 225:
	* @var array messages		* @var array messages
	*/		*/
	protected $~~messages~~;		protected $msg;

	/**		/**

Jammin320: Corrected mistaken variable name

2012-10-04T05:37:48Z

Corrected mistaken variable name

← Older revision		Revision as of 05:37, 4 October 2012
Line 255:		Line 255:
	{		{
	//request the selected id		//request the selected id
	$~~input~~ = JRequest::getInt('id');		$id = JRequest::getInt('id');

	// Get a TableHelloWorld instance		// Get a TableHelloWorld instance