Using relations in views

本文介绍如何通过在数据库中设置外键并使用Yii框架的Gii工具自动生成模型间的关联,来简化数据展示过程。此外还介绍了手动设置关联的方法及如何在视图中显示关联数据。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Relations are easier if you setup a foreign key in your database first. To do this you need to use MySQL (not SQLite) with the InnoDB engine (not MyISAM), and the field in question needs an index and foreign key on it. Then, Gii will setup the relations function for you automatically. Otherwise, you'll have to do it manually in the relations() function of the model in question.

Imagine if you will, you have an integer field "status_id" on an order table, that relates to a status table "status_table", that has a column "name". You want to show the related "name", and not the status id.

To use a related value in a View: 

In protected/views/[model name]/view.php, in the CDetailView attributes array, change

'status_id'

to

array('label'=>'Status', 'value'=>$model->status_relation->name)

where status_relation is the name of the relation defined in the model

To use a related value in an Index view, change protected/views/[model name]/_view.php (note the underscore):

$data->status_id

to

$data->status_relation->name

To use a related value in an Admin view, in the CGridView widget function, in the columns array, replace

'status_id'

with

array('name'=>'status_id', 'header'=>'Status', 'value'=>'$data->status_relation->name')

(note the use of the variable $data, and not say $model or $dataProvider, and the quotes around $data).

In your model's search function:

public function search()
{

  $criteria=new CDbCriteria;

  //add the magic letter 't' to refer to the 'main' (not the related) table:
  $criteria->compare('t.id',$this->id);
  $criteria->compare('status_relation.name',$this->status_id, true);

  //load the related table at the same time:
  $criteria->with=array('status_relation');

  return new CActiveDataProvider(get_class($this), array('criteria'=>$criteria,));
}
To use a drop-down menu, in protected/views/[model name]/_form.php:

change

$form->textField($model,'status_id');

to

$form->dropDownList($model,'status_id', CHtml::listData(StatusModel::model()->findAll(), 'status_id', 'name'));

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值