孤寡老人
- 孤寡老人 赞了源码yii2底层源码分析
$customers = Customer::find() ->select('customer.*') ->leftJoin('order', '`order`.`customer_id` = `customer`.`id`') ->where(['order.status' => Order::STATUS_ACTIVE]) ->with('orders') ->all();
http://www.yiiframework.com/doc-2.0/guide-db-active-record.html#relational-data 多看文档
@lcn 我目的不是建model,目的是用ActiveRecord,我想问的是不建model怎么可以用ActiveRecord?
$customers = Customer::find() ->select('customer.*') ->leftJoin('order', '`order`.`customer_id` = `customer`.`id`') ->where(['order.status' => Order::STATUS_ACTIVE]) ->with('orders') ->all();
http://www.yiiframework.com/doc-2.0/guide-db-active-record.html#relational-data 多看文档
我不是说的表连接,我是说的像这样
$command = $connection->createCommand('SELECT * FROM post'); $posts = $command->queryAll(); $command = $connection->createCommand('SELECT * FROM post1 where id =1'); $posts = $command->queryAll(); .....
随意的去查询任何一张表
我按你说的走咋到这里就报错了啊?$query->joinWith(['customer']);<=====加入这句
报错内容 : Caused by: Unknown Method – yii\base\UnknownMethodException
Calling unknown method: app\models\Bug::get{{%user}}()- 孤寡老人 发布了话题Yii2 怎么格式化时间啊?