API16:JElementSQL/fetchElement - Revision history

JoomlaWikiBot: preparing for archive only

2017-03-25T01:36:00Z

preparing for archive only

← Older revision		Revision as of 01:36, 25 March 2017
Line 69:		Line 69:

	===Examples===		===Examples===
	~~<CodeExamplesForm />~~		=== Code Examples ===
	<dpl>		<dpl>
	noresultsheader=\n		noresultsheader=\n
	category=fetchElement		category=fetchElement
	category=JElementSQL		category=JElementSQL
	~~category~~=CodeExample		namespace=CodeExample
	category=MethodExample		category=MethodExample
	include=*		include=*

JoomlaWikiBot: clean up

2017-03-24T13:55:46Z

clean up

← Older revision		Revision as of 13:55, 24 March 2017
Line 1:		Line 1:
	~~<span class="editsection" style="font-size:76%;">~~
	~~<nowiki>[<! removed edit link to red link >]</nowiki>~~
	~~</span>~~

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

Line 69:		Line 65:
	</source>		</source>

	~~<span class="editsection" style="font-size:76%;">~~
	~~<nowiki>[<! removed edit link to red link >]</nowiki>~~
	~~</span>~~
	<! removed transcluded page call, red link never existed >		<! removed transcluded page call, red link never existed >

JoomlaWikiBot: removing red link to edit, no existant pages

2013-05-13T05:04:07Z

removing red link to edit, no existant pages

← Older revision		Revision as of 05:04, 13 May 2013
Line 1:		Line 1:

	<span class="editsection" style="font-size:76%;">		<span class="editsection" style="font-size:76%;">
	<nowiki>[<~~/nowiki>[[Description:JElementSQL/fetchElement\|Edit Descripton]]<nowiki~~>]</nowiki>		<nowiki>[<! removed edit link to red link >]</nowiki>
	</span>		</span>

	~~{{Description:JElementSQL/fetchElement}}~~		<! removed transcluded page call, red link never existed >

	===Syntax===		===Syntax===
Line 71:		Line 70:

	<span class="editsection" style="font-size:76%;">		<span class="editsection" style="font-size:76%;">
	<nowiki>[<~~/nowiki>[[SeeAlso:JElementSQL/fetchElement\|Edit See Also]]<nowiki~~>]</nowiki>		<nowiki>[<! removed edit link to red link >]</nowiki>
	</span>		</span>
	~~{{SeeAlso:JElementSQL/fetchElement}}~~		<! removed transcluded page call, red link never existed >

	===Examples===		===Examples===
Line 86:		Line 85:
	format= ,,,		format= ,,,
	</dpl>		</dpl>
			[[Category:Archived pages API16]]

Doxiki at 10:14, 30 March 2010

2010-03-30T10:14:24Z

← Older revision		Revision as of 10:14, 30 March 2010
Line 23:		Line 23:
	\|		\|
	\|-		\|-
	\|		\| &$node
	\|		\|
	\|		\|

Doxiki: New page: [Edit Descripton] {{Description:JElementSQL/fet...

2010-03-22T22:50:27Z

New page: <nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki> {{Description:JElementSQL/fet...

New page

<nowiki>[</nowiki>[[Description:JElementSQL/fetchElement|Edit Descripton]]<nowiki>]</nowiki>


{{Description:JElementSQL/fetchElement}}

===Syntax===
<source lang="php">fetchElement($name, $value, &$node, $control_name)</source>

{| class="wikitable"
|-
!Parameter Name
!Default Value
!Description
|-
| $name
|
|
|-
| $value
|
|
|-
|
|
|
|-
| $control_name
|
|
|}

===Defined in===
libraries/joomla/html/parameter/element/sql.php
===Importing===
<source lang="php">jimport( 'joomla.html.parameter.element.sql' );</source>

===Source Body===
<source lang="php">
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
)
);
}
</source>


<nowiki>[</nowiki>[[SeeAlso:JElementSQL/fetchElement|Edit See Also]]<nowiki>]</nowiki>

{{SeeAlso:JElementSQL/fetchElement}}

===Examples===
<CodeExamplesForm />
<dpl>
noresultsheader=\n
category=fetchElement
category=JElementSQL
category=CodeExample
category=MethodExample
include=*
format= ,,,
</dpl>