API17

JDatabase::loadObjectList: Difference between revisions

From Joomla! Documentation

Doxiki2 (talk | contribs)
Bots
18,905 edits
Bulk upload by Doxiki2
 
m preparing for archive only
 
(7 intermediate revisions by 3 users not shown)
Line 2: Line 2:
=={{JVer|11.1}} JDatabase::loadObjectList==
=={{JVer|11.1}} JDatabase::loadObjectList==
===Description===
===Description===
Load a list of database objects.  
Method to get an array of the result set rows from the database query where each row is an object.  
 
 


{{Description:JDatabase::loadObjectList}}
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[Description:JDatabase::loadObjectList|Edit Descripton]]<nowiki>]</nowiki>
</span>
===Synopsis===
<source lang="php">
<source lang="php">
public JDatabase->loadObjectList ($key='')
public function loadObjectList (
        $key=''
        $class= 'stdClass'
)
</source>
</source>
{| class="wikitable"
{| class="wikitable"
Line 20: Line 20:
|-
|-
|$key
|$key
|string
|
|''
|''
|The field name of a primary key
|
|-
|$class
|
|'stdClass'
|
|-
|-
|}
|}
===Returns===
* '''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''' on line 707 of libraries/joomla/database/database.php
===Defined in===
libraries/joomla/database/database.php
===Referenced by===
===See also===
===See also===
<span class="editsection" style="font-size:76%;">
* {{JVer|11.1}} '''JDatabase::loadObjectList source code''' on [[jplatform:database/database.php#cl-699|BitBucket]]
<nowiki>[</nowiki>[[SeeAlso:JDatabase::loadObjectList|Edit See Also]]<nowiki>]</nowiki>
* {{JVer|11.1}} Class [[API17:JDatabase|JDatabase]]
</span>
* {{JVer|11.1}} Subpackage [[API17:Subpackage_Database|Database]]
* [[JDatabase/11.1|JDatabase]]
* [[API17:JDatabase::loadObjectList|Other versions of JDatabase::loadObjectList]]
* [[JDatabase::loadObjectList|Other versions of this method]]
 
{{SeeAlso:JDatabase::loadObjectList}}
 
===User contributed notes===
 
===Examples===
===Examples===
<CodeExamplesForm />
 
<source lang="php">
// Create a new query object.
$db = &JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('cats.description AS description, cats.title AS titel');
$query->from('#__categories AS cats');
$query->where('cats.id="1"');
$db->setQuery($query);
$Category = $db->loadObjectList();
</source>
 
 
=== Code Examples ===
<dpl>
<dpl>
noresultsheader=\n
noresultsheader=\n
category=JDatabase::loadObjectList
category=JDatabase::loadObjectList
category=CodeExample
namespace=CodeExample
category=MethodExample
category=MethodExample
include=*
include=*
namespace=CodeExample
format= ,,,
format= ,,,
</dpl>
</dpl>
<noinclude>[[Category:JDatabase]][[Category:JDatabase::loadObjectList]]</noinclude>
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>

Latest revision as of 02:34, 25 March 2017

Joomla 11.1 JDatabase::loadObjectList

Description

Method to get an array of the result set rows from the database query where each row is an object. 


public function loadObjectList (
        $key=''
        $class= 'stdClass'
)
Parameter Type Default Description
$key
$class 'stdClass'
  • Returns
  • Defined on line 707 of libraries/joomla/database/database.php

See also


User contributed notes

Examples

// Create a new query object.		
$db = &JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('cats.description AS description, cats.title AS titel');
$query->from('#__categories AS cats');
$query->where('cats.id="1"');
$db->setQuery($query);
$Category = $db->loadObjectList();


Code Examples


Retrieved from "https://docs.sandbox.joomla.org/index.php?title=API17:JDatabase::loadObjectList&oldid=384333"