(→Adding Form Fields to the module: Update db query)
(→Adding Form Fields to the module: Update sql form field query)
|Line 14:||Line 14:|
<field name="lang" type="sql" default="
<field name="lang" type="sql" default="" label="Select a language" query="SELECT id AS value, lang FROM #__helloworld" />
Form fields give a great deal of customisation in Joomla and for modules are the sole way of allowing the user to tweak the module to the needs of their site.
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 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:
<fields name="params"> <fieldset name="basic"> <field name="lang" type="sql" default="1" label="Select a language" query="SELECT id AS value, lang FROM #__helloworld" /> </fieldset> </fields>
This selects the languages from the database table and allows the user to choose which one from a select element.
If you were to install the module as it is now you would see if you were to access the module in the backend of Joomla that a dropdown had appeared (although picking an option won't affect the module at the moment).
Note: The form field parameters are stored for each module in the #__modules table under the params field as json encoded string.
Now lets make the form field do something!
Lets go into the mod_helloworld.php and retrieve the parameter (note you cannot retrieve the parameter in the helper), and then pass it into the helper function.
/** * This retrieves the lang parameter we stored earlier. Note the second part * which states to use the default value of 1 if the parameter cannot be * retrieved for some reason **/ $language = $params->get('lang', '1'); $hello = modHelloWorldHelper::getHello( $language );
Now lets edit our database query in the helper file to reflect our parameter choice
//Obtain a database connection $db = JFactory::getDbo(); //Retrieve the shout - note we are now retrieving the id not the lang field. $query = $db->getQuery(true) ->select($db->quoteName('hello')) ->from($db->quoteName('#__helloworld')) ->where('id = '. $db->Quote($params)); //Prepare the query $db->setQuery($query); // Load the row. $result = $db->loadResult(); //Return the Hello return $result;
Form fields give the user an easy way to customise the module to their sites settings. This allows the modules scope to be increased as well for many languages and applications.