Revision #205 has been created by rackycz on Jun 30, 2020, 11:21:00 PM with the memo:
FK DropDown
« previous (#204) next (#206) »
Changes
Title
unchanged
Yii v2 snippet guide
Category
unchanged
Tutorials
Yii version
unchanged
2.0
Tags
unchanged
tutorial,beginner,yii2
Content
changed
[...]
**Drop down list for foreign-key column**
--
Do you need to specify for example currency using a predefined list, but your view contains only a simple text-input where you must manually enter currency_id from table Currency?
Read how to enhance it. You only need models with predefined relations - this can be done using GII when relations are defined in MySQL. How to create relations [manually](https://www.yiiframework.com/doc/guide/2.0/en/db-active-record#relational-data).
---
```php
use yii\helpers\ArrayHelper;[...]
<?= $form->field($model, 'id_currency')->dropDownList($currencies) ?>
```
Note: In other views will need models with predefined relations to reach the correct value. Relations can be created using GII (when they are defined in MySQL) or [manually](https://www.yiiframework.com/doc/guide/2.0/en/db-active-record#relational-data).