Yii2: How to select multiple fields from different tables

Question

My tables

Category
id_category
name

Post
id_post
category_id
title

My query:

Post::find()
->select('post.*, c.name AS catname')
->leftJoin('category c', 'c.id_category = category_id')
->all();

The output just shown the table fields Post, is not the field catname.

"Getting unknown property: app\models\Post::catname" I have "$posts = Post::find()..." and error is at line: "foreach ($posts as $post) { $post->catname; } — Giest
– Giest, Commented Jan 4, 2016 at 22:10

Fabrizio Caldarelli · Accepted Answer · 2016-01-04 23:11:38Z

2

1) Define a relation in Post model named 'category', so:

public function getCategory() { 
     return $this->hasOne(Category::className(), ['id_category' => 'category_id']); 
}

2) Then when you query the posts, use 'with' if you need to get category name for each post:

$posts = Post::find()
->with('category')
->all();

3) You can access to category name with:

$post->category->name

answered Jan 4, 2016 at 23:11

3,00813 silver badges14 bronze badges

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

1 Answer 1