Yii2关联表如何输出 SQL 语句

最新推荐文章于 2022-04-17 12:53:08 发布

shaoyang8

最新推荐文章于 2022-04-17 12:53:08 发布

阅读量223

点赞数

分类专栏： YII 文章标签： php

本文链接：https://blog.csdn.net/shaoyangzhuanyong/article/details/105436931

版权

YII 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

1.查询单个表

$order = Order::find()->where([ ‘id’ => $orderid])->asArray()->one();

echo Order::find()->where([ ‘id’ => $orderid])->asArray()->createCommand()->getRawSql();
显示
SELECT * FROM order WHERE (id=‘1’);

2.查询链表
$list = Order::find()
->select(‘g.name,o.id’)
->alias(‘o’)
->leftJoin([‘g’ => Goods::tableName()], ‘o.goods_id=g.id’)
->where([‘o.id’ => $orderid])
->asArray()
->all();
$list = Order::find()
->select(‘g.name,o.id’)
->alias(‘o’)
->leftJoin([‘g’ => Goods::tableName()], ‘o.goods_id=g.id’)
->where([‘o.id’ => $orderid])
->asArray()
->createCommand()->getRawSql();
显示
SELECT g.name, od.id FROM order o LEFT JOIN goods g ON od.goods_id=g.id WHERE (od.id=‘1’)