How do I get values from database table as an array and return it in dropdownlist?

Question

I have a table with columns (id, name) whereas in name, I have name of months (january, february...) I want to take all this name and return it in dropdownlist where I can take one of month. I have this function in my model:

public function getMonths()
{
    $month= Months::find()
->asArray()
->all();

     for($monthNum = self::MY_START; $monthNum <= self::MY_MONTH; $monthNum++){
   return $month[$monthNum];
    }

}

Now it only returns me one month (2 february ). What should I do to return in this dropdown list only name of these months?

Possible duplicate of Generate drop-down list input with values from DB table — miken32
– miken32, Commented Jan 20, 2016 at 19:25

ScaisEdge · Accepted Answer · 2016-01-20 19:28:09Z

0

If you are using Yii2 you can simply use the dropdownlist in view

<?php
 use yii\helpers\ArrayHelper;
?>

<?= Html::activeDropDownList($model, 'your_month_id',
   ArrayHelper::map(Months::find()->all(), 'id', 'name')) ?>

answered Jan 20, 2016 at 19:28

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I get values from database table as an array and return it in dropdownlist?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related