I made my form:
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
/* @var $this yii\web\View */
/* @var $model app\models\FuelEnter */
/* @var $form ActiveForm */
?>
<div class="enterfuel">
<?php $form = ActiveForm::begin(); ?>
<?= $form->dropDownLst($model, Html::listData(Forms::model()->findAll(),'trans_id','id'))
//I want to make 'name' be selected from table Transport
?>
<?= $form->field($model, 'average') ?>
<?= $form->field($model, 'urban') ?>
<?= $form->field($model, 'comb') ?>
<div class="form-group">
<?= Html::submitButton('Submit', ['class' => 'btn btn-primary']) ?>
</div>
<?php ActiveForm::end(); ?>
</div><!-- enterfuel -->
I want to use drop down list and select values from database. I have 2 tables Transport and fuel_usage.
How to fill dropDownList
from Transport column 'name' values? And save form results to Fuel_usage table giving Transport's 'id' +3 input fields?
Transport {transID, name}
and
Fuel {id,average, comb, urban}