在Yii框架中按文本和外键搜索id

Question

I have form:

<?= $form->field($model, 'id')->textInput() ?>

<?= $form->field($model, 'occurrence')->textInput() ?>

<?= $form->field($model, 'probability')->textInput(['maxlength' => true]) ?>

First input is a foreign key where table have names.

I don't know how to do If I type "aaa" get id foreign key. Normally I use array helper and dropDownlist, but I can't here because first table have 400000 record. I don't know how to do? How to search in input form and return id in this input. I'm using Yii 2 framework

Answer 1

You're right, using a dropdown list for all 400K elements would be a disaster. What you should use is one of many enhanced select controls:

• Select2
• Selectize
• Chosen
• Typeahead, another version

You will also need to create a controller action that this widget will use for searching. Here is a good example (for Select2):

http://demos.krajee.com/widget-details/select2#usage-ajax