Difference between revisions of "JElementSQL/fetchElement"
From Joomla! Documentation
< API16:JElementSQL
(New page:
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki>
</span>
{{Description:JElementSQL/fet...) |
|||
Line 23: | Line 23: | ||
| | | | ||
|- | |- | ||
− | | | + | | &$node |
| | | | ||
| | | |
Revision as of 05:14, 30 March 2010
The "API16" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.
Template:Description:JElementSQL/fetchElement
Syntax[edit]
fetchElement($name, $value, &$node, $control_name)
Parameter Name | Default Value | Description |
---|---|---|
$name | ||
$value | ||
&$node | ||
$control_name |
Defined in[edit]
libraries/joomla/html/parameter/element/sql.php
Importing[edit]
jimport( 'joomla.html.parameter.element.sql' );
Source Body[edit]
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
)
);
}
[Edit See Also] Template:SeeAlso:JElementSQL/fetchElement
Examples[edit]
<CodeExamplesForm />