Re: cakephp-3 - lists records in drop down

You have a few ways of doing this, but I would say the easiest is this one:

$list = $degrees->find()->combine('id', function($entity) {

  return $entity->name . $entity->degree;

});

You can also use find('list'), but in that case I would suggest reading its documentation so you understand how fields are passed to it.

Cheers!

On Monday, June 16, 2014 1:21:47 PM UTC+2, archana goyal wrote:

My code for array is

        $degrees = TableRegistry::get('Degrees');
        $degreelist = $degrees->find('list', ['fields' => ['id', 'concat(name,degree) as name']]);

not created dropdown but if I create query

        $degrees = TableRegistry::get('Degrees');
        $degreelist = $degrees->find('list', ['fields' => ['id', 'name']]);
dropdown created but I need first one.

in mysql query will be :-
       SELECT id,concat(name,degree) FROM `degrees`

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.