class MssmModel extends RelationModel {
// 声明关联模型
protected $_link = array(
"Msst" => array(
"mapping_type" => self::BELONGS_TO,
"class_name" => "Msst",
"mapping_name" => "msst",
"foreign_key" => "tid",
"condition" => "",
"mapping_fields" => "",
"as_fields" => "status:jobs"
),
);Mssm表字段CREATE TABLE `baidu_mssm` (
`sid` int(10) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL,
`qq` int(16) NOT NULL default '0',
`tid` int(11) NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;另一张表:CREATE TABLE `baidu_msst` (
`tid` int(10) unsigned NOT NULL auto_increment,
`status` varchar(32) NOT NULL default '0',
PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;写入数据,测试代码 public function relationIn ()
{
header("Content-type:text/html;charset=utf-8;");
$mssm = D("Mssm");
$data = array();
$data['username'] = '邓超';
$data['qq'] = NOW_TIME;
$data['Msst'] = array(
'status' => '演员'
);
$result = $mssm->relation("Msst")->add($data);
//INSERT INTO `baidu_mssm` (`username`,`qq`) VALUES ('邓超','1460432783')
echo $result;
}无法写入 msst 表字段查询数据:
array
'sid' => int 13
'username' => string '邓超' (length=6)
'qq' => int 1460432783
'tid' => int 0
'jobs' => null 最佳答案