【YII2案例：中間表關聯兩張表】
路徑：http://localhost/yii23_associationtable/web/index.php?r=hello/index
主頁view/hello/index.php:
~~~
<h1>YII2中間表關聯兩張表</h1>
<h1>分類</h1>
<?php foreach ($data2 as $key => $data) : ?>
分類id：<?php echo $data->id; ?> | <?php echo $data->name; ?><br/>
<?php endforeach; ?>
<hr/>
<h1>文章</h1>
<?php foreach ($data3 as $key => $data) : ?>
文章：<?php echo $data->id; ?> | <?php echo $data->title; ?><br/>
<?php endforeach; ?>
<hr/>
<h1>中間表</h1>
<?php foreach ($data1 as $key => $data) : ?>
中間表id：<?php echo $data->id; ?> | 分類id：<?php echo $data->tags_id; ?> | 文章id：<?php echo $data->article_id; ?><br/>
<?php endforeach; ?>
<hr/>
<h1>分類為PHP的文章</h1>
<?php foreach ($filter as $key => $data) : ?>
<?php echo $data->id; ?> | <?php echo $data->title; ?><br/>
<?php endforeach; ?>
<hr/>
~~~
控制器controller/HelloController.php:
~~~
<?php
namespace app\controllers;
use yii\web\Controller;
use app\models\Article;
use app\models\Tags;
use app\models\Core;
class HelloController extends Controller {
public function actionIndex(){
$data1=Core::find()->all();
$data2=Tags::find()->all();
$data3=Article::find()->all();
$filter=Article::find()->joinWith('tags')->where(['name'=>'php'])->orderBy('article_id ASC')->all();
return $this->render('index', compact('data1', 'data2', 'data3', 'filter'));
}
}
~~~
模型model/Core:
~~~
<?php
namespace app\models;
use yii\db\ActiveRecord;
//中間表
class Core extends ActiveRecord
{
public static function tableName()
{
return 'core';
}
public function getTags(){
return $this->hasMany(Tags::className(),['id'=>'tags_id']) // 標簽ID對應中間表tags_id
->viaTable('article',['id'=>'article_id']) // 文章ID對應中間表article_id
->asArray();
}
}
~~~
模型model/Article:
~~~
<?php
namespace app\models;
use yii\db\ActiveRecord;
// 文章
class Article extends ActiveRecord
{
public static function tableName()
{
return 'article';
}
public function getTags(){
return $this->hasMany(Tags::className(),['id'=>'tags_id']) // 標簽ID對應中間表tags_id
->viaTable('core',['article_id'=>'id']) // 中間表article_id對應文章ID
->asArray();
}
}
~~~
模型model/Tags:
~~~
<?php
namespace app\models;
use yii\db\ActiveRecord;
// 標簽
class Tags extends ActiveRecord
{
}
~~~
效果：
源碼下載：
鏈接：https://pan.baidu.com/s/1uVST-9pmiUZZUlvqS91DJA 密碼：hbzp
