Actions

API16

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>[[Description:JDatabaseMySQL/loadAssocList|Edit Descripton]]<nowiki>]</nowiki>
+
<nowiki>[<! removed edit link to red link >]</nowiki>
 
</span>
 
</span>
  
{{Description:JDatabaseMySQL/loadAssocList}}
+
<! 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>[[SeeAlso:JDatabaseMySQL/loadAssocList|Edit See Also]]<nowiki>]</nowiki>
+
<nowiki>[<! removed edit link to red link >]</nowiki>
 
</span>
 
</span>
{{SeeAlso:JDatabaseMySQL/loadAssocList}}
+
<! removed transcluded page call, red link never existed >
  
 
===Examples===
 
===Examples===
Line 71: Line 71:
 
  format= ,,,
 
  format= ,,,
 
</dpl>
 
</dpl>
 +
[[Category:Archived pages API16]]

Latest revision as of 22:00, 12 May 2013

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.

Contents

Description

Load a assoc list of database rows.

[<! removed edit link to red link >]

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

Syntax

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

array If is empty as sequential list of returned records.

Defined in

libraries/joomla/database/database/mysql.php

Importing

jimport( 'joomla.database.database.mysql' );

Source Body

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

<CodeExamplesForm />