Actions

API16

JElementSQL/fetchElement

From Joomla! Documentation

< API16:JElementSQL
Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

[<! removed edit link to red link >]

<! removed transcluded page call, red link never existed >

Contents

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
                )
        );
}

[<! removed edit link to red link >] <! removed transcluded page call, red link never existed >

Examples

<CodeExamplesForm />