need to use concat with list of find method in cakephp 3.x

Question

i am using cakephp 3.1. in that i need to use concat the firstname and lastname with space using list of find method..

I tried below code it return with semi columns but i need space instead of semi columns.

Code:

 $query = $articles->find('list', [
        'keyField' => 'id',
        'valueField' => ['firstname','lastname']
    ]);
    $data = $query->toArray();

I got below result :

 $data = [
        1 => 'rahul;patel',
        2 => 'raj;patel',
    ];

But i need space instead of semi column (;).

Please guys help me.

Thanks in advance.

You put the output of `$query->toArray();` but not just `$query` — Perspective, Sep 03 '16 at 13:41
actually $query return object..but output is same only object and array diff — Kamlesh Gupta, Sep 03 '16 at 13:43
Not sure if this will help you but you can check, http://pritomkumar.blogspot.sg/2013/09/concat-two-different-fields-in-cakephp.html — user1149244, Sep 03 '16 at 13:52
@KamleshGupta I've just added a third option to my answer that I've overlooked initially (someone else mentioned it in another answer) — ndm, Sep 03 '16 at 14:36

Perspective · Answer 1 · 2016-09-03T14:26:49.990

0

Currently in the documentation for 3.0 I don't see the support to add parameters in the find function, but I'm not very familiar with cakephp http://book.cakephp.org/3.0/en/orm/query-builder.html

I would try something along these lines. I've commented out an alternative possible return in the array_map. I hope this helps.

  $query = $articles
    ->find()
    ->select(['id','firstname', 'lastname'])
    ->order(['created' => 'DESC']);

  $data = array_reduce($query, function($carry, $item) {
    $carry[$item->id] = $item->firstname.' '.$item->lastname;
    return $carry;
  }, []);

edited Sep 03 '16 at 14:26

answered Sep 03 '16 at 13:50

Perspective

642
5
12

Thanks for answer but i don't need using like this i know about this...i want in list – Kamlesh Gupta Sep 03 '16 at 13:54
@KamleshGupta does this help? https://github.com/cakephp/cakephp/issues/3597 – Perspective Sep 03 '16 at 14:07
no actually i want key as id and value as first name and lastname with space between fname and lname – Kamlesh Gupta Sep 03 '16 at 14:14
@KamleshGupta I've updated the code to give you your desired result. I understand this doesn't use the exact process you'd like to use within CakePHP. – Perspective Sep 03 '16 at 14:28
thanks for your time dude – Kamlesh Gupta Sep 03 '16 at 14:36
You're welcome @KamleshGupta – Perspective Sep 03 '16 at 14:37

need to use concat with list of find method in cakephp 3.x

1 Answers1