How to get select tab in volt

Question

How to get select tab in volt

jaikumar002 Oct '16

Created Oct '16	Last Reply Oct '16	Replies 3	Views 716	Votes 0

jaikumar002 65.1k

Oct '16

i want to show db values as dropdown list in a table...but i am not able to do the same...can anyone help??

below is my code

<tr>
            <td>{{ table.id }}</td>
            <td>{{ table.name }}</td>
                <td> {{ select("name","role","using": ["id", "name"])}} </td> 

<td width="7%">{{  radio_field("access", "value": "grant") }}   Grant  </td>
<td width="7%">{{  radio_field("access", "value": "deny") }}   Deny  </td>              

        </tr>

when i tried the above code ... iam got the following error...

            Invalid data provided to SELECT helper
#0 [internal function]: Phalcon\Tag\Select::selectField(Array, NULL)
#1 C:\wamp64\www\project\cache\volt\c%%%%wamp64%%www%%corporate_reimbursement%%app%%views%%permission%%assign.volt.php(26): Phalcon\Tag::select(Array)
#2 [internal function]: unknown()
#3 [internal function]: Phalcon\Mvc\View\Engine\Volt->render('C:\\wamp64\\www\\c...', Array, true)
#4 [internal function]: Phalcon\Mvc\View->_engineRender(Array, 'permission/assi...', true, true, NULL)
#5 [internal function]: Phalcon\Mvc\View->render('permission', 'assign', Array)

baychae · Answer 1 · 2016-10-06T03:53:19-07:00

Your params need to be wrapped in an array?

https://docs.phalcon.io/en/latest/reference/tags.html#making-select-boxes

le51 · Answer 2 · 2016-10-06T08:37:48-07:00

Hi,

Invalid data provided to SELECT helper

[internal function]: Phalcon\Tag\Select::selectField(Array, NULL)

from the controller, you have to provide role list to the view :


// in your controller action
$roles = Role::find([  // I find more convenient to use plural here
    'columns' => 'id, name',
    'order' => 'name ASC'
]);
$this->view->setVar('roles', $roles);

// in your view
 <td> {{ select("name","roles","using": ["id", "name"])}} </td>

baychae · Answer 3 · 2016-10-07T06:07:41-07:00

@le51

I think you have a typo:

// in your controller action
$roles = Role::find([  // I find more convenient to use plural here
    'columns' => 'id, name',
    'order' => 'name ASC'
]);
$this->view->setVar('roles', $roles);

// in your view
 <td> {{ select("name", roles ,"using": ["id", "name"])}} </td>