API15

JDatabaseMySQLi/loadRowList

From Joomla! Documentation

< API15:JDatabaseMySQLi
Revision as of 17:15, 22 March 2010 by Doxiki (talk | contribs) (New page: ===Description=== Load a list of database rows (numeric column indexing) <span class="editsection" style="font-size:76%;"> <nowiki>[</nowiki>[[Description:JDatabaseMySQLi/loadRowList|...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

The "API15" 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 list of database rows (numeric column indexing)

[Edit Descripton]

Template:Description:JDatabaseMySQLi/loadRowList

Syntax[edit]

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

Returns[edit]

array If is empty as sequential list of returned records.

Defined in[edit]

libraries/joomla/database/database/mysqli.php

Importing[edit]

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

Source Body[edit]

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

[Edit See Also] Template:SeeAlso:JDatabaseMySQLi/loadRowList

Examples[edit]

<CodeExamplesForm />