Trait yii\db\ActiveQueryTrait

Implemented byyii\db\ActiveQuery, yii\elasticsearch\ActiveQuery, yii\mongodb\ActiveQuery, yii\mongodb\file\ActiveQuery, yii\redis\ActiveQuery, yii\sphinx\ActiveQuery
Available since version2.0
Source Code https://github.com/yiisoft/yii2/blob/master/framework/db/ActiveQueryTrait.php

ActiveQueryTrait implements the common methods and properties for active record query classes.

Public Properties

Hide inherited properties

PropertyTypeDescriptionDefined By
$asArray boolean Whether to return each record as an array. yii\db\ActiveQueryTrait
$modelClass string The name of the ActiveRecord class. yii\db\ActiveQueryTrait
$with array A list of relations that this query should be performed with yii\db\ActiveQueryTrait

Public Methods

Hide inherited methods

MethodDescriptionDefined By
asArray() Sets the asArray() property. yii\db\ActiveQueryTrait
findWith() Finds records corresponding to one or multiple relations and populates them into the primary models. yii\db\ActiveQueryTrait
with() Specifies the relations with which this query should be performed. yii\db\ActiveQueryTrait

Protected Methods

Hide inherited methods

MethodDescriptionDefined By
createModels() Converts found rows into model instances yii\db\ActiveQueryTrait

Property Details

$asArray public property

Whether to return each record as an array. If false (default), an object of $modelClass will be created to represent each record.

public boolean $asArray null
$modelClass public property

The name of the ActiveRecord class.

public string $modelClass null
$with public property

A list of relations that this query should be performed with

public array $with null

Method Details

asArray() public method

Sets the asArray() property.

public $this asArray ( $value true )
$value boolean

Whether to return the query results in terms of arrays instead of Active Records.

return $this

The query object itself

createModels() protected method (available since version 2.0.11)

Converts found rows into model instances

protected array|yii\db\ActiveRecord[] createModels ( $rows )
$rows array
findWith() public method

Finds records corresponding to one or multiple relations and populates them into the primary models.

public void findWith ( $with, &$models )
$with array

A list of relations that this query should be performed with. Please refer to with() for details about specifying this parameter.

$models array|yii\db\ActiveRecord[]

The primary models (can be either AR instances or arrays)

with() public method

Specifies the relations with which this query should be performed.

The parameters to this method can be either one or multiple strings, or a single array of relation names and the optional callbacks to customize the relations.

A relation name can refer to a relation defined in $modelClass or a sub-relation that stands for a relation of a related record. For example, orders.address means the address relation defined in the model class corresponding to the orders relation.

The following are some usage examples:

// find customers together with their orders and country
Customer::find()->with('orders', 'country')->all();
// find customers together with their orders and the orders' shipping address
Customer::find()->with('orders.address')->all();
// find customers together with their country and orders of status 1
Customer::find()->with([
    'orders' => function (\yii\db\ActiveQuery $query) {
        $query->andWhere('status = 1');
    },
    'country',
])->all();

You can call with() multiple times. Each call will add relations to the existing ones. For example, the following two statements are equivalent:

Customer::find()->with('orders', 'country')->all();
Customer::find()->with('orders')->with('country')->all();
public $this with ( )
return $this

The query object itself