API15

JDatabaseMySQL/loadRowList: Difference between revisions

From Joomla! Documentation

m removing red link to edit, no existant pages
m preparing for archive only
 
Line 56: Line 56:


===Examples===
===Examples===
<CodeExamplesForm />
=== Code Examples ===
<dpl>
<dpl>
  noresultsheader=\n
  noresultsheader=\n
  category=loadRowList
  category=loadRowList
  category=JDatabaseMySQL
  category=JDatabaseMySQL
  category=CodeExample
  namespace=CodeExample
  category=MethodExample
  category=MethodExample
  include=*
  include=*

Latest revision as of 00:28, 25 March 2017

Description

Load a list of database rows (numeric column indexing)

[<! removed edit link to red link >]

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

Syntax

loadRowList($key=null)
Parameter Name Default Value Description
$key null The field name of a primary key

Returns

array If is empty as sequential list of returned records. If is not empty then the returned array is indexed by the value the database key. Returns if the query fails.

Defined in

libraries/joomla/database/database/mysql.php

Importing

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

Source Body

function loadRowList( $key=null )
{
        if (!($cur = $this->query())) {
                return null;
        }
        $array = array();
        while ($row = mysql_fetch_row( $cur )) {
                if ($key !== null) {
                        $array[$row[$key]] = $row;
                } else {
                        $array[] = $row;
                }
        }
        mysql_free_result( $cur );
        return $array;
}

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

Examples

Code Examples