Cakephp 3.0 $query->toArray();

Question

Hey I am trying to find a solution I am retrieving the data from mysql using this command :

$meals = TableRegistry::get('Users');
$query = $meals
->find()
->select(['id' ,'username'])
->where(['role' => 'patient']);
 $data = $query->toArray();

This is my code after using query->toarray() I am getting this value

 { "id": 4, "username": "s2" }

I want to put this value in my form which is like this :

   echo $this->Form->input('user_id', [
        'options' => [1 => 'Admin', 2 => 'Author']
    ]) ;

How to use foreach to get value as id and usernmae as name any quick solution

book.cakephp.org/3.0/en/orm/…

ndm
– ndm

2015-03-31 07:03:36 +00:00
Commented Mar 31, 2015 at 7:03 — ndm
– ndm, Commented Mar 31, 2015 at 7:03

José Lorenzo Rodríguez · Accepted Answer · 2015-03-31 07:30:46Z

3

Use find('list')

$users = TableRegistry::get('Users')
    ->find('list', ['valueField' => 'username'])
    ->select(['id' ,'username'])
    ->where(['role' => 'patient']);

$this->set('users', $users);

echo $this->Form->input('user_id', [
    'options' => $users
]);

http://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#finding-key-value-pairs

answered Mar 31, 2015 at 7:30

José Lorenzo Rodríguez

9,62437 silver badges32 bronze badges

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

1 Comment

Nilay Healthy World Over a year ago

hey jose I have some issue I am trying to add a hidden input can you suggest me in this where d_id I want to update this column here uer_id get updated but in hidden form it is not doing any action

Collectives™ on Stack Overflow

Cakephp 3.0 $query->toArray();

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related