duanbodai5166
2017-02-08 03:31
浏览 12
已采纳

如何正确执行CakePHP 3中的LEFT连接?

I have been attempting to use CakePHP 3's query builder format in order to learn how to better use it. However, at the moment I cannot seem to get a left join working.

There is information available in both tables that I would like to collect in the result:

    $query = $this->find()->where(['userID' => $UID])->hydrate(false)->join([
        'table' => 'authgroups',
        'alias' => 'a',
        'type' => 'LEFT',
        'conditions' => 'a.id = userGroup'
    ]);

    return $query->toArray();

If I'm reading the CookBook correctly, this should work - however, it is being used in a model which differs from the example, and the result only returns from that table, seemingly ignoring the join. Do I need to execute this in the controller instead?

图片转代码服务由CSDN问答提供 功能建议

我一直在尝试使用CakePHP 3的查询构建器格式,以便学习如何更好地使用它。 但是,目前我似乎无法让左连接工作。

我希望在结果中收集两个表中的信息:

  $ query = $ this->  find() - > where(['userID'=> $ UID]) - > hydrate(false) - > join([
'table'=>'authgroups',
'alias'=  >'a',
'type'=>'LEFT',
'条件'=>'a.id = userGroup'
]); 
 
返回$ query-> toArray(  ); 
   
 
 

如果我正确读取CookBook,这应该可行 - 但是,它在一个与示例不同的模型中使用,结果 只返回该表,似乎忽略了连接。 我需要在控制器中执行此操作吗?

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • doumu1212 2017-02-08 04:12
    已采纳

    This works in model:

    What I guess is your join query might working well.The important thing in cakephp join is that:

    If you are joining table 'A' with table 'B' from table 'A' ,
    By default it will select all fields from table A and no fields from table B.
    

    You need to select some fields from another table as well:

    $query = $this->find()->where(['userID' => $UID])->hydrate(false)->join([
        'table' => 'authgroups',
        'alias' => 'a',
        'type' => 'LEFT',
        'conditions' => 'a.id = userGroup'
     ])->autoFields(true) // selecting all fields from current table
       ->select(["a.field1,a.field2"]); // selecting some fields from table authgroups
    
    return $query->toArray();
    }
    

    And I don't know if these things are provided well in cakephp documentation.

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题