thinkphp 关联查询 3张一对多的表咋弄

gygy1993 2013-07-04 02:59:10

表的关系图如图
一个酒店有多个房间，一个房间有多个价格
求 thinkphp关联查询咋写？？

...全文

2233 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

gygy1993 2013-07-04

打赏
举报

附上我的Model


class HotelListRelationModel extends RelationModel{
	protected $tableName = 'hotellist';
	public $_link=array(
			"hotelroomlist"=>array(
				 "mapping_type"=>HAS_MANY,
				 "class_name"=>"hotelroomlist",
				 "mapping_name"=>"hotelroomlist",
				 "foreign_key"=>"Room_HotelId",
				 "condition"=>"Is_Del=0",
				 "mapping_fields"=>array("Room_id","Room_Name","Room_Bed")
			   ),
			);
}

gygy1993 2013-07-04

打赏
举报

引用 6 楼 xuzuning 的回复:

嗯，他那个不适合你看看这个 http://bbs.csdn.net/topics/360168211

额我想得到这样的结果


array(2) {
  [0] => array(4) {
    ["Hotel_Id"] => string(1) "4"
    ["Hotel_Name"] => string(24) "重庆南方君临酒店"
    ["Hotel_Stars"] => string(1) "1"
    ["hotelroomlist"] => array(3) {
      [0] => array(3) {
        ["Room_id"] => string(1) "1"
        ["Room_Name"] => string(12) "豪华大房"
        ["Room_Bed"] => string(6) "大床"
      }
      [1] => array(3) {
        ["Room_id"] => string(1) "2"
        ["Room_Name"] => string(15) "豪华双人间"
        ["Room_Bed"] => string(6) "双床"
      }
      [2] => array(3) {
        ["Room_id"] => string(1) "5"
        ["Room_Name"] => string(9) "商务房"
        ["Room_Bed"] => string(6) "大床"
      }
    }
  }
  [1] => array(4) {
    ["Hotel_Id"] => string(1) "5"
    ["Hotel_Name"] => string(30) "重庆申基索菲特大酒店"
    ["Hotel_Stars"] => string(1) "1"
    ["hotelroomlist"] => array(2) {
      [0] => array(3) {
        ["Room_id"] => string(1) "3"
        ["Room_Name"] => string(15) "豪华双人房"
        ["Room_Bed"] => string(12) "双人大床"
      }
      [1] => array(3) {
        ["Room_id"] => string(1) "4"
        ["Room_Name"] => string(12) "商务大房"
        ["Room_Bed"] => string(6) "大床"
      }
    }
  }
}

这只关联了酒店表和房间表没有关联价格表