控制器
<?php
// 本文档自动生成,仅供测试运行
class OrderAction extends Action{
public function index(){
import("ORG.Util.Page");
$ordermod=D('orders');
$count = $ordermod->count();
$p = new Page($count,10);
$p->setConfig('header','个预约');
$p->setConfig('prev','<');
$p->setConfig('next','>');
$p->setConfig('last','>>');
$p->setConfig('first','<<');
$page = $p->show();
$list = $ordermod->relation(true)->limit($p->firstRow.','.$p->listRows)->select();
dump($list);
$this->assign('list',$list);
$this->assign('page',$page);
$this->display();
}
}
数据模型
<?php
class OrdersModel extends RelationModel{
protected $_li
nk = array(
"Doctors"=>array(
"mapping_type"=>BELONGS_TO,
"class_name"=>'Doctors',
"foreign_key"=>'did',
"mapping_name"=>'doctors',
"as_fields"=>'name:dname',
),
"Users"=>array(
"mapping_type"=>BELONGS_TO,
"class_name"=>'Users',
"foreign_key"=>'kid',
"mapping_name"=>'users',
"as_fields"=>'name:kname',
),
"Rooms"=>array(
"mapping_type"=>BELONGS_TO,
"class_name"=>'Rooms',
"foreign_key"=>'rid',
"mapping_name"=>'rooms',
"as_fields"=>'name:rname',
),
);
}
dump出的结果,只联到第一张表,后面两张表没有关联到
array(1) {
[0] => array(18) {
["id"] => string(1) "1"
["kid"] => string(2) "15"
["rid"] => string(1) "1"
["did"] => string(1) "9"
["name"] => string(9) "小燕子"
["sex"] => string(1) "0"
["age"] => string(1) "1"
["tel"] => string(11) "13656283457"
["qq"] => string(9) "254054837"
["ytime"] => string(6) "154645"
["ctime"] => string(19) "2013-01-16 14:22:17"
["way"] => string(6) "百度"
["astate"] => string(1) "1"
["areturn"] => string(1) "0"
["content"] => string(6) "阳萎"
["address"] => string(6) "xxxx"
["remarks"] => string(21) "没有什么好说了"
["dname"] => string(9) "xxxx"
}
}