Home > php教程 > PHP开发 > Simple usage example of related query in Yii2

Simple usage example of related query in Yii2

高洛峰
Release: 2016-12-23 16:40:57
Original
1392 people have browsed it

The example in this article describes the usage of associated query in Yii2. Share it with everyone for your reference, the details are as follows:

There are two tables, post and category, post.cate_id corresponds to category.id

Use Gii to increase the models of these two tables

Then the post model has the following code

public function getCate()
{
  return $this->hasOne(Category::className(), ['id' => 'cate_id']);
}
Copy after login

Add the following method at the bottom of the post model to obtain the content of the association table

public static function getPostsByCategory($cate_id)
{
  return Post::find()
    ->joinWith('cate')
    ->where(['post.cate_id'=>$cate_id])
    ->asArray()
    ->all();
}
Copy after login

I hope this article will be helpful to everyone’s PHP program design based on the Yii framework.

For more related articles on simple usage examples of related queries in Yii2, please pay attention to the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template