<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                【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 { } ~~~ 效果: ![](images/20180824023540.png) 源碼下載: 鏈接:https://pan.baidu.com/s/1uVST-9pmiUZZUlvqS91DJA 密碼:hbzp
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看