Archived:Creating a simple module/Adding Form Fields - Revision history

M-b-o: M-b-o moved page J2.5:Creating a simple module/Adding Form Fields to Archived:Creating a simple module/Adding Form Fields

2022-04-26T22:18:16Z

M-b-o moved page J2.5:Creating a simple module/Adding Form Fields to Archived:Creating a simple module/Adding Form Fields

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

Dieda2 at 10:50, 12 August 2016

2016-08-12T10:50:22Z

← Older revision		Revision as of 10:50, 12 August 2016
Line 64:		Line 64:
	->select($db->quoteName('hello'))		->select($db->quoteName('hello'))
	->from($db->quoteName('#__helloworld'))		->from($db->quoteName('#__helloworld'))
	->where('id = '. int($params)); //here $params is the parameter passed to the helper getHello function		->where('id = '. (int)$params); //here $params is the parameter passed to the helper getHello function
	// Prepare the query		// Prepare the query
	$db->setQuery($query);		$db->setQuery($query);

Dieda2 at 10:49, 12 August 2016

2016-08-12T10:49:05Z

← Older revision		Revision as of 10:49, 12 August 2016
Line 64:		Line 64:
	->select($db->quoteName('hello'))		->select($db->quoteName('hello'))
	->from($db->quoteName('#__helloworld'))		->from($db->quoteName('#__helloworld'))
	->where('id = '. int($params)); //here $params is the parameter passed to the helper function		->where('id = '. int($params)); //here $params is the parameter passed to the helper getHello function
	// Prepare the query		// Prepare the query
	$db->setQuery($query);		$db->setQuery($query);

Dieda2 at 10:47, 12 August 2016

2016-08-12T10:47:29Z

← Older revision		Revision as of 10:47, 12 August 2016
Line 30:		Line 30:
	''Note:'' The form field parameters are stored for each module in the #__modules table under the params field as json encoded string.		''Note:'' The form field parameters are stored for each module in the #__modules table under the params field as json encoded string.

	Because of the Joomla! ~~moudule~~ rendering method, when we are inside the mod_helloworld.php program, we have the same variables in scope that we have in the renderModule() method of the JModuleHelper class (libraries/joomla/application/module/helper.php). Among these we have the $params variable defined as follows:		Because of the Joomla! module rendering method, when we are inside the mod_helloworld.php program, we have the same variables in scope that we have in the renderModule() method of the JModuleHelper class (libraries/joomla/application/module/helper.php). Among these we have the $params variable defined as follows:

	<source lang="php">		<source lang="php">

Dieda2: I have added the explanation of why the $params variable appears as available inside mod_helloworld.php despite it's not been defined before inside the custom code. Also I have corrected the query inside the helper.php file and the function call.

2016-08-12T10:46:39Z

I have added the explanation of why the $params variable appears as available inside mod_helloworld.php despite it's not been defined before inside the custom code. Also I have corrected the query inside the helper.php file and the function call.

← Older revision		Revision as of 10:46, 12 August 2016
Line 29:		Line 29:

	''Note:'' The form field parameters are stored for each module in the #__modules table under the params field as json encoded string.		''Note:'' The form field parameters are stored for each module in the #__modules table under the params field as json encoded string.

			Because of the Joomla! moudule rendering method, when we are inside the mod_helloworld.php program, we have the same variables in scope that we have in the renderModule() method of the JModuleHelper class (libraries/joomla/application/module/helper.php). Among these we have the $params variable defined as follows:

			<source lang="php">
			$params= new JRegistry;
			$params->loadJSON($module->params);
			</source>

			Hence, we can always access the $params variable although it's never been defined in our code.

	Now lets make the form field do something!		Now lets make the form field do something!
Line 41:		Line 50:
	**/		**/
	$language = $params->get('lang', '1');		$language = $params->get('lang', '1');
	$hello = modHelloWorldHelper::getHello( $~~language~~ );		$langid = $params->get('id', '1');
			$hello = modHelloWorldHelper::getHello($langid);
	</source>		</source>


	Now lets edit our database query in the helper file to reflect our parameter choice		Now lets edit our database query in the helper file to reflect our parameter choice
Line 53:		Line 64:
	->select($db->quoteName('hello'))		->select($db->quoteName('hello'))
	->from($db->quoteName('#__helloworld'))		->from($db->quoteName('#__helloworld'))
	->where('id = '. ~~$db->Quote~~($params));		->where('id = '. int($params)); //here $params is the parameter passed to the helper function
	// Prepare the query		// Prepare the query
	$db->setQuery($query);		$db->setQuery($query);

Zero24: /* Adding Form Fields to the module */

2014-09-27T13:48:22Z

Adding Form Fields to the module

← Older revision		Revision as of 13:48, 27 September 2014
Line 18:		Line 18:
	type="sql"		type="sql"
	default="1"		default="1"
	~~<!-- Please use a language string in the final version for a easy translation -->~~
	label="Select a language"		label="Select a language"
	query="SELECT id AS value, lang FROM #__helloworld" />		query="SELECT id AS value, lang FROM #__helloworld" />

Zero24: User Joomla Core CS

2014-09-27T13:47:09Z

User Joomla Core CS

← Older revision		Revision as of 13:47, 27 September 2014
Line 14:		Line 14:
	<fields name="params">		<fields name="params">
	<fieldset name="basic">		<fieldset name="basic">
	<field name="lang" type="sql" default="1" label="Select a language" query="SELECT id AS value, lang FROM #__helloworld" />		<field
			name="lang"
			type="sql"
			default="1"
			<!-- Please use a language string in the final version for a easy translation -->
			label="Select a language"
			query="SELECT id AS value, lang FROM #__helloworld" />
	</fieldset>		</fieldset>
	</fields>		</fields>
Line 36:		Line 42:
	**/		**/
	$language = $params->get('lang', '1');		$language = $params->get('lang', '1');
	$hello = modHelloWorldHelper::getHello( $language );		$hello = modHelloWorldHelper::getHello( $language );
	</source>		</source>

Line 42:		Line 48:

	<source lang="php">		<source lang="php">
	//Obtain a database connection		// Obtain a database connection
	$db = JFactory::getDbo();		$db = JFactory::getDbo();
	//Retrieve the shout - note we are now retrieving the id not the lang field.		// Retrieve the shout - note we are now retrieving the id not the lang field.
	$query = $db->getQuery(true)		$query = $db->getQuery(true)
	->select($db->quoteName('hello'))		->select($db->quoteName('hello'))
	->from($db->quoteName('#__helloworld'))		->from($db->quoteName('#__helloworld'))
	->where('id = '. $db->Quote($params));		->where('id = '. $db->Quote($params));
	//Prepare the query		// Prepare the query
	$db->setQuery($query);		$db->setQuery($query);
	// Load the row.		// Load the row.

Wilsonge: /* Adding Form Fields to the module */ Update sql form field query

2013-05-13T23:27:31Z

Adding Form Fields to the module: Update sql form field query

← Older revision		Revision as of 23:27, 13 May 2013
Line 14:		Line 14:
	<fields name="params">		<fields name="params">
	<fieldset name="basic">		<fieldset name="basic">
	<field name="lang" type="sql" default="10" label="Select a language" query="SELECT id AS value, ~~title AS~~ lang FROM #__helloworld" />		<field name="lang" type="sql" default="1" label="Select a language" query="SELECT id AS value, lang FROM #__helloworld" />
	</fieldset>		</fieldset>
	</fields>		</fields>

Wilsonge: /* Adding Form Fields to the module */ Update db query

2013-05-13T23:25:35Z

Adding Form Fields to the module: Update db query

← Older revision		Revision as of 23:25, 13 May 2013
Line 52:		Line 52:
	$db->setQuery($query);		$db->setQuery($query);
	// Load the row.		// Load the row.
	$~~results~~ = $db->~~loadRow~~();		$result = $db->loadResult();
	//Return the Hello		//Return the Hello
	return $~~results[1]~~;		return $result;
	</source>		</source>

Wilsonge: /* Adding Form Fields to the module */ Add in missed close brackets

2013-05-12T14:11:06Z

Adding Form Fields to the module: Add in missed close brackets

← Older revision		Revision as of 14:11, 12 May 2013
Line 7:		Line 7:

	== Adding Form Fields to the module ==		== Adding Form Fields to the module ==
	In this case we are going to extend our previous example using the database to provide a list of languages for the user to select from. To allow this to happen we will use the SQL form field type (full details for this on the [[SQL_form_field_type\|SQL Form Field]] docs page.		In this case we are going to extend our previous example using the database to provide a list of languages for the user to select from. To allow this to happen we will use the SQL form field type (full details for this on the [[SQL_form_field_type\|SQL Form Field]] docs page).

	First of all we are going to add a form field into our xml file. Remember those config tags that we added in earlier? Well now inside these tags we are going to add the following code:		First of all we are going to add a form field into our xml file. Remember those config tags that we added in earlier? Well now inside these tags we are going to add the following code: