Render form select from database

Question

Render form select from database

Stefjoe Dec '16

Created Dec '16	Last Reply Dec '16	Replies 1	Views 813	Votes 0

Stefjoe 59.9k

Dec '16

Hello,

how can i render a dropdown from database.

For example from table Users

Form.php

        $users = Users::find();

        $usersSelect =  new Select("users",array(
                 $users, array(
                "using"      =>
                    "id",
                    "name",
                ),
                "useEmpty"   => true,
                "emptyText"  => "Please, choose one...",
                "emptyValue" => "@"
            )

        );

        $this->add($users);

Volt

        {{ form.render('users') }}

Thx

Trent Ramseyer
22.7k

Accepted
answer

edited Dec '16
Dec '16

From their example (provided), looks like you may have an extra array in there


 $this->add(
            new Select(
                "telephoneType",
                TelephoneTypes::find(),
                [
                    "using" => [
                        "id",
                        "name",
                    ]
                ]
            )
        );

Stefjoe · Answer 1 · 2016-12-29T02:51:58-07:00

Stefjoe
59.9k

Dec '16

Hello Trent,

it is working, thx for that.

Rgds Stefan