Cakephp 3.0 $ query-> toArray(); [英] Cakephp 3.0 $query->toArray();
本文介绍了Cakephp 3.0 $ query-> toArray();的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嘿,我试图找到一个解决方案,我正在使用以下命令从mysql检索数据:
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();
这是使用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']
]) ;
如何使用foreach来获取ID和用户名作为任何快速解决方案的名称
How to use foreach to get value as id and usernmae as name any quick solution
推荐答案
使用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
这篇关于Cakephp 3.0 $ query-> toArray();的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文