How to get value from Yii2 ActiveQuery array

Question

I have a table containing fields

id, vehicle_id, vehicle_rating_type, vehicle_rating, rating_time

I want to get values based in vehicle_id, so I fired query

$id = Yii::$app->getRequest()->getQueryParam('id');
$data = VehicleRating::find()->where(['vehicle_id' => $id]);

Now when I prints $data array in view file using print_r function I get following result.

yii\db\ActiveQuery Object ( 
    [sql] => 
    [on] => 
    [joinWith] => 
    [select] => 
    [selectOption] => 
    [distinct] => 
    [from] => 
    [groupBy] => 
    [join] => 
    [having] => 
    [union] => 
    [params] => Array ( ) 
    [_events:yii\base\Component:private] => Array ( ) 
    [_behaviors:yii\base\Component:private] => Array ( ) 
    [where] => Array ( 
        [vehicle_id] => 1 
    ) 
    [limit] => 
    [offset] => 
    [orderBy] => 
    [indexBy] => 
    [modelClass] => backend\models\VehicleRating 
    [with] => 
    [asArray] => 
    [multiple] => 
    [primaryModel] => 
    [link] => 
    [via] => 
    [inverseOf] => 
)

How to retrive values from this array to show in view file? Say I want to say vehicle_id and vehicle_rating. How to print it?

soju · Accepted Answer · 2015-09-28 11:17:17Z

1

You should simply execute the query, e.g. :

$rating = VehicleRating::find()->where(['vehicle_id' => $id])->one();
echo $rating->vehicle_rating;

Or if you want array instead of object :

$rating = VehicleRating::find()->where(['vehicle_id' => $id])->asArray()->one();
echo $rating['vehicle_rating'];

Read more : http://www.yiiframework.com/doc-2.0/guide-db-active-record.html#querying-data

edited Sep 28, 2015 at 11:17

answered Sep 28, 2015 at 11:05

soju

25.4k3 gold badges70 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Onedev_Link · Accepted Answer · 2015-09-28 10:53:04Z

0

Use query params.

$vehicleRatingQuery = VehicleRating::find()->where('vehicle_id = :vehicleId', [
    ':vehicleId' => $id
]);

$vehicleRatingQueryParams = $vehicleRatingQuery->params;

answered Sep 28, 2015 at 10:53

Onedev_Link

2,01215 silver badges27 bronze badges

Comments

user2732844 · Accepted Answer · 2015-09-28 11:10:09Z

0

found the solution i added ->one() at the end of query and it works

$data = VehicleRating::find()->where(['vehicle_id' => $id])->one();

answered Sep 28, 2015 at 11:10

user2732844

Collectives™ on Stack Overflow

How to get value from Yii2 ActiveQuery array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related