API16:JElementSQL/fetchElement

Syntax

fetchElement($name, $value, &$node, $control_name)

Parameter Name	Default Value	Description
$name
$value
&$node
$control_name

Defined in

libraries/joomla/html/parameter/element/sql.php

Importing

jimport( 'joomla.html.parameter.element.sql' );

Source Body

public function fetchElement($name, $value, &$node, $control_name)
{
        $db                     = & JFactory::getDbo();
        $db->setQuery($node->attributes('query'));
        $key = ($node->attributes('key_field') ? $node->attributes('key_field') : 'value');
        $val = ($node->attributes('value_field') ? $node->attributes('value_field') : $name);

        $options = $db->loadObjectlist();

        // Check for an error.
        if ($db->getErrorNum()) {
                JError::raiseWarning(500, $db->getErrorMsg());
                return false;
        }

        if (!$options) {
                $options = array();
        }

        return JHtml::_('select.genericlist', $options, $control_name.'['.$name.']',
                array(
                        'id' => $control_name.$name,
                        'list.attr' => 'class="inputbox"',
                        'list.select' => $value,
                        'option.key' => $key,
                        'option.text' => $val
                )
        );
}

Examples

<CodeExamplesForm />