Models -> Combining columns from result set into key => value array

Question

Models -> Combining columns from result set into key => value array

baychae Jan '15

Created Jan '15	Last Reply Apr '16	Replies 2	Views 1142	Votes 0

baychae 47.7k

Jan '15

In my action controller I have:

$user_groups = UserGroup::find(array('columns' => 'id,label'));
$form = new ProductReviewForm($user_groups);

In the form initialize I have:

public function initialize($user_groups) {

    $user_groups_array = $user_groups->toArray();
    $user_groups_name = array_column($user_groups_array,'id');
    $user_groups_label = array_column($user_groups_array, 'label'); 
    $user_group_options = array_combine($user_groups_name, $user_groups_label);

    $user_group_element = new \Phalcon\Forms\Element\Select("User Group", $user_group_options);
    $user_group_element->setLabel("<label for='User Group' >User Group: </label>");
}

My question? Is there a way to do transform a resultset into an \Phalcon\Forms\Element\Select in less lines?

RompePC
33.8k

Accepted
answer

edited Jan '15
Jan '15

Maybe:

$form = new ProductReviewForm(UserGroup::find(array('columns' => 'id,label')));

...

public function initialize($user_groups)
{
    $user_group_options = [];

    foreach($user_groups as $userGroup)
    {
        $user_group_options[$userGroup->id] = $userGroup->label;
    }

    $user_group_element = new \Phalcon\Forms\Element\Select("User Group", $user_group_options);
    $user_group_element->setLabel("<label for='User Group' >User Group: </label>");
}

baychae · Answer 1 · 2015-01-27T10:06:22-07:00

baychae
47.7k

edited Jan '15
Jan '15

RompePC - This looks less expensive to me. The way to go. Thanks.

RompePC · Answer 2 · 2015-01-28T04:58:44-07:00

Also I think

$user_group_element = new \Phalcon\Forms\Element\Select(
    'User Group',
    UserGroup::find(['columns' => 'id, label']),
    'using' => ['id', 'label']
);

should do the trick.