ThinkPHP3.2中关联查询解决办法
ThinkPHP3.2中关联查询
CREATE TABLE `test_avatar` (<br /> `uid` int(11) unsigned NOT NULL DEFAULT '0',<br /> `avatar` varchar(255) NOT NULL DEFAULT '',<br /> PRIMARY KEY (`uid`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8;<br />INSERT INTO `test_avatar` VALUES (1,'./Uploads/admin.jpg');<br /><br />CREATE TABLE `test_pro` (<br /> `id` int(11) unsigned NOT NULL AUTO_INCREMENT,<br /> `uid` int(11) unsigned NOT NULL DEFAULT '0',<br /> `name` varchar(255) NOT NULL DEFAULT '',<br /> PRIMARY KEY (`id`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8;<br />INSERT INTO `test_pro` VALUES (1,1,'产品1'),(2,1,'产品2');<br /><br />CREATE TABLE `test_user` (<br /> `id` int(11) unsigned NOT NULL AUTO_INCREMENT,<br /> `username` varchar(50) NOT NULL DEFAULT '',<br /> `tel` int(11) unsigned NOT NULL DEFAULT '0',<br /> PRIMARY KEY (`id`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8;<br />INSERT INTO `test_user` VALUES (1,'admin',110);
如上三个表:用户头像表、产品表、用户表
怎样在模型中建立关联?
class ProModel extends RelationModel{<br /><br /> protected $_link=array(<br /> 'Avatar'=>array(<br /> 'mapping_type'=>self::HAS_ONE,<br /> 'class_name'=>'Avatar',<br /> 'foreign_key'=>'uid',<br /> 'mapping_fields'=>'avatar',<br /> 'as_fields'=>'avatar',<br /> ),<br /> )<br />}
试过用HAS_ONE、BELONGS_TO、HAS_MANY、MANY_TO_MANY都不行,求大神指点
------解决思路----------------------
Model下建立ProModelModel.class.php
<br />class ProModelModel extends ViewModel { <br /> <br /> public $viewFields = array( <br /> 'test_avatar'=>array(<br /> 'id',...<br /> ), <br /> 'test_pror'=>array(<br /> 'id',...<br /> '_on'=>''<br /> ), <br /> 'test_pror'=>array(<br /> 'id',...<br /> '_on'=>''<br /> ), <br /> ); <br />}

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Huawei is rolling out software version 5.0.0.100(C00M01) for the Watch GT 5 and the Watch GT 5 Prosmartwatchesglobally. These two smartwatches recently launched in Europe, with the standard model arriving as the company’s cheapest model. This Harmony

Katsuhiro Harada, the Tekken series director, once seriously tried to bring Colonel Sanders into the iconic fighting game. In an interview with TheGamer, Harada revealed that he pitched the idea to KFC Japan, hoping to add the fast-food legend as a g

Tesla is rolling out the latest Full Self-Driving (Supervised) version 12.5.5 and with it comes the promised Cybertruck FSD option at long last, ten months after the pickup went on sale with the feature included in the Foundation Series trim price. F

Earlier in September 2024, Anker's Zolo 140W charger was leaked, and it was a big deal since it was the first-ever wall charger with a display from the company. Now, a new unboxing video from Xiao Li TV on YouTube gives us a first-hand look at the hi

Xiaomi will shortly launch the Mijia Graphene Oil Heater in China. The company recently ran a successful crowdfunding campaign for the smart home product, hosted on its Youpin platform. According to the page, the device has already started to ship to

Garmin is ending the month with a new set of stable updates for its latest high-end smartwatches. To recap, the company released System Software 11.64 to combat high battery drain across the Enduro 3, Fenix E and Fenix 8 (curr. $1,099.99 on Amazon).

The launch of Samsung's long-awaited 'Special Edition' foldable has taken another twist. In recent weeks, rumours about the so-called Galaxy Z Fold Special Edition went rather quiet. Instead, the focus has shifted to the Galaxy S25 series, including

With a history of over one decade, Manjaro is regarded as one of the most user-friendly Linux distros suitable for both beginners and power users, being easy to install and use. Mostly developed in Austria, Germany, and France, this Arch-based distro
