CODEWITHSUNDEEP
phpsearchyii2
vjdj
vjdj

Reputation: 95

Search id by text and foreign key in Yii framework

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

Upvotes: 0

Views: 354

Answers (1)

Beowulfenator
Beowulfenator

Reputation: 2300

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:

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

Upvotes: 1

Related Questions