首页 文章

如何在cakephp中编写连接两个表查询

提问于
浏览 次
0
SELECT e.employee_name, e.employee_store, e.employee_phone, s.store_address
FROM  `employee` e
JOIN store s ON e.employee_store = s.store_name

如何在cakephp控制器中编写此查询以及如何在视图部分中显示结果 .

cakephp cakephp-2.0 cakephp-1.3 cakephp-2.1 cakephp-2.3

3 回答

  • 0
    $this->employee->bindModel(
    array('hasMany' => array(
        'Store' => array(
            'className' => 'Principle'
                )
            )
        )
    );
    回复于
  • 0

    尝试 -

    $this->Model->find(
'all',
array(
 'fields' => array('table.employee_name', 'table.employee_store', ....),
 'joins' => array(
                'table' => 'store',
                'conditions' => array('employee_store' => 'store_name')
            )
)
)
    回复于
  • 0

    您应该尝试这个员工是您的模型名称，商店是您的表名称，类型是您的加入左，右和内

    $details=$this->Employee->find('all',array('fields' => array('Employee.*','stores.*'),
        'joins'=>array(
                array(
                    'table'=>'store',
                    'type'=>'inner',
                    'conditions'=>array('Emmployee.employee_store=stores.store_name')
                    )
                )
            )
      );
    回复于

相关问题