我试着说CkMmUsersKta.user_id=CkSetupUser.id,并在CakePhp中定义2个表之间的关系。我定义了模型并在控制器中的函数中调用了模型,但说未定义的索引
$c['CkSetupUser']['user_name']
蛋糕PHP的注意 (8):未定义的索引:CkSetupUser [APP''Controller''RealsController.php,第 67 行]
我的控制器:
class RealsController extends AppController {
public $helpers = array('Html', 'Form');
public $uses =array('CkMmUsersKta','CkSetupUser');
public function index(){
$this>loadModel('CkMmUsersKta');$this>loadModel('CkSetupUser');
ini_set('memory_limit', '2000M');
$cs=$this->CkMmUsersKta->find("all",array('fields'=>array('CkMmUsersKta.id')));
foreach($cs as $c):
echo $c['CkMmUsersKta']['id'].$c['CkSetupUser']['user_name']."<br />";
endforeach;
set_time_limit(0);
}
}
我的 CkSetupUser 模型:
public $hasMany = array(
'CkMmUsersKta' => array(
'className' => 'CkMmUsersKta',
'foreignKey' => 'user_id',
'dependent' => true
)
);
我的CkMmUsersKta模型:
public $belongsTo = array(
'CkSetupUser' => array(
'className' => 'CkSetupUser',
'foreignKey' => 'user_id'
)
);
问题是您只在以下位置获取 id 字段:
$cs=$this->CkMmUsersKta->find("all",array('fields'=>array('CkMmUsersKta.id')));
您还应该指定名称字段。
$cs=$this->CkMmUsersKta->find("all",array('fields'=>array('CkMmUsersKta.id','CkSetupUser.user_name')));