Difference between #204 and #205 of
Yii v2 snippet guide

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).
7 0
4 followers
Viewed: 274 925 times
Version: 2.0
Category: Tutorials
Written by: rackycz
Last updated by: rackycz
Created on: Sep 19, 2019
Last updated: a year ago
Update Article

Revisions

View all history