Difference between revisions of "JDatabaseMySQL/loadAssocList"
From Joomla! Documentation
< API16:JDatabaseMySQL
(New page: ===Description===
Load a assoc list of database rows.
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<...) |
m (removing red link to edit, no existant pages) |
||
| Line 3: | Line 3: | ||
<span class="editsection" style="font-size:76%;"> | <span class="editsection" style="font-size:76%;"> | ||
| − | <nowiki>[< | + | <nowiki>[<! removed edit link to red link >]</nowiki> |
</span> | </span> | ||
| − | + | <! removed transcluded page call, red link never existed > | |
===Syntax=== | ===Syntax=== | ||
| Line 56: | Line 56: | ||
<span class="editsection" style="font-size:76%;"> | <span class="editsection" style="font-size:76%;"> | ||
| − | <nowiki>[< | + | <nowiki>[<! removed edit link to red link >]</nowiki> |
</span> | </span> | ||
| − | + | <! removed transcluded page call, red link never existed > | |
===Examples=== | ===Examples=== | ||
| Line 71: | Line 71: | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
| + | [[Category:Archived pages API16]] | ||
Revision as of 22:00, 12 May 2013
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.
Description[edit]
Load a assoc list of database rows.
[<! removed edit link to red link >]
<! removed transcluded page call, red link never existed >
Syntax[edit]
loadAssocList($key=null, $column=null)| Parameter Name | Default Value | Description |
|---|---|---|
| $key | null | The field name of a primary key. |
| $column | null | An optional column name. Instead of the whole row, only this column value will be in the return array. |
Returns[edit]
array If is empty as sequential list of returned records.
Defined in[edit]
libraries/joomla/database/database/mysql.php
Importing[edit]
jimport( 'joomla.database.database.mysql' );Source Body[edit]
public function loadAssocList($key = null, $column = null)
{
if (!($cur = $this->query())) {
return null;
}
$array = array();
while ($row = mysql_fetch_assoc($cur)) {
$value = ($column) ? (isset($row[$column]) ? $row[$column] : $row) : $row;
if ($key) {
$array[$row[$key]] = $value;
} else {
$array[] = $value;
}
}
mysql_free_result($cur);
return $array;
}[<! removed edit link to red link >] <! removed transcluded page call, red link never existed >
Examples[edit]
<CodeExamplesForm />