
不废话了,直接给大家贴代码了,代码很简单,都是比较常见的sql语句,具体内容请看下文。
CREATE TABLE `test_avatar` (
`uid` int(11) unsigned NOT NULL DEFAULT 0,
`avatar` varchar(255) NOT NULL DEFAULT ,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `test_avatar` VALUES (1,./Uploads/admin.jpg);
CREATE TABLE `test_pro` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) unsigned NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL DEFAULT ,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `test_pro` VALUES (1,1,产品1),(2,1,产品2);
CREATE TABLE `test_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL DEFAULT ,
`tel` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `test_user` VALUES (1,admin,110);
如上三个表:用户头像表、产品表、用户表
怎样在模型中建立关联?
class ProModel extends RelationModel{
protected $_link=array(
Avatar=