两张表:
CREATE TABLE `think_user` (
`id` mediumint(6) NOT NULL auto_increment,
`name` varchar(25) NOT NULL,
`dept_id` smallint(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
CREATE TABLE `think_dept` (
`id` smallint(3) NOT NULL auto_increment,
`name2` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
Model文件:
<?php
class NewuserModel extends RelationModel{
protected $_li
nk=array(
'Dept'=>array(
'mapping_type'=>HAS_ONE,
'foreign_key'=>'id',
),
);
}
?>
Aciotn文件
public function relations(){
$rs=D('User');
$data=$rs->relation('Dept')->select();
$f['name']='晓梅1008';
$f['pid']=50;
$f['dept']=array(
'name2' => 'deptname',
);
$data=$rs->relation('Dept')->add($f);
}
发现只能插入user表 dept表插入不成功,可以关联查询,请教下。
附件
new.rar
( 687 B 下载:4 次 )