多对多关联模型查询附表为null

浏览:1323 发布日期:2014/12/20 分类:求助交流
角色表
+--------+----------------------+------+-----+---------+----------------+
| Field  | Type                 | Null | Key | Default | Extra          |
+--------+----------------------+------+-----+---------+----------------+
| id     | smallint(6) unsigned | NO   | PRI | NULL    | auto_increment |
| name   | varchar(20)          | NO   |     | NULL    |                |
| pid    | smallint(6)          | YES  | MUL | NULL    |                |
| status | tinyint(1) unsigned  | YES  | MUL | NULL    |                |
| remark | varchar(255)         | YES  |     | NULL    |                |
+--------+----------------------+------+-----+---------+----------------+
+---------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------------------+------+-----+---------+-------+
| role_id | mediumint(9) unsigned | YES | MUL | NULL | |
| user_id | char(32) | YES | MUL | NULL | |
+---------+-----------------------+------+-----+---------+-------+中间表
+---------+-----------------------+------+-----+---------+-------+
| Field   | Type                  | Null | Key | Default | Extra |
+---------+-----------------------+------+-----+---------+-------+
| role_id | mediumint(9) unsigned | YES  | MUL | NULL    |       |
| user_id | char(32)              | YES  | MUL | NULL    |       |
+---------+-----------------------+------+-----+---------+-------+
用户表
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| id        | int(11)     | NO   | PRI | NULL    | auto_increment |
| uname     | varchar(20) | YES  |     | NULL    |                |
| password  | varchar(40) | YES  |     | NULL    |                |
| logintime | date        | YES  |     | NULL    |                |
| loginip   | varchar(20) | YES  |     | NULL    |                |
| locks     | int(11)     | YES  |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+
<?php
namespace Admin\Model;
use Think\Model\RelationModel;

class UserModel extends RelationModel{
protected $tableName="user";
    protected $_link=array(
    "think_role"=>array(
     "mapping_type" => MANY_TO_MANY,
    'relation_table' => 'think_role_user',
    
     'mapping_name'=>'think_role',
    'foreign_key' => 'user_id',
    
    'relation_key' => 'role_id',
    
    "mapping_field" =>"id,name,remark"
    )
    );
}
public function user(){
    
        $user=D("user")->relation(true)->select();
        
        $this->display();
    }
  [0] => array(7) {
    ["id"] => string(1) "1"
    ["uname"] => string(4) "dada"
    ["password"] => string(32) "e10adc3949ba59abbe56e057f20f883e"
    ["logintime"] => string(10) "0000-00-00"
    ["loginip"] => string(9) "127.0.0.1"
    ["locks"] => NULL
    ["think_role"] => NULL
  }
  [1] => array(7) {
    ["id"] => string(1) "2"
    ["uname"] => string(6) "sdadas"
    ["password"] => string(32) "e10adc3949ba59abbe56e057f20f883e"
    ["logintime"] => string(10) "0000-00-00"
    ["loginip"] => string(9) "127.0.0.1"
    ["locks"] => NULL
    ["think_role"] => NULL
  }
附表think_role=>null,这是怎么回事???????????
最佳答案
评论( 相关
后面还有条评论,点击查看>>