Home > Backend Development > PHP Tutorial > ThinkPHP3.2中关联查询

ThinkPHP3.2中关联查询

WBOY
Release: 2016-06-20 12:48:27
Original
979 people have browsed it

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);
Copy after login

如上三个表:用户头像表、产品表、用户表
怎样在模型中建立关联?
class ProModel extends RelationModel{	protected $_link=array(		'Avatar'=>array(			'mapping_type'=>self::HAS_ONE,			'class_name'=>'Avatar',			'foreign_key'=>'uid',			'mapping_fields'=>'avatar',			'as_fields'=>'avatar',		),        )}
Copy after login

试过用HAS_ONE、BELONGS_TO、HAS_MANY、MANY_TO_MANY都不行,求大神指点


回复讨论(解决方案)

Model下建立ProModelModel.class.php

class ProModelModel extends ViewModel {  			public $viewFields = array(     		'test_avatar'=>array(				'id',...			),     		'test_pror'=>array(			'id',...			'_on'=>''			),                     'test_pror'=>array(			'id',...			'_on'=>''			), 	   ); }
Copy after login

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template