[FIXED] Get one column in CakePHP 3.x controller

Issue

How to get one colum with sql and convert it in array and use in controller?

$allid = $this ->TabelName
            ->find('list',array(
                'fields' => array('id'),
                'conditions' => array(
                    'User_id' => '1'
                )
            ));
        $this->set(compact('allid'));



        $data = $allid->toArray();
        echo $data;

What i need is to have in controller this $data=array("1","2","3"); and this are all ids from TableName. Can someone tell me how can i do this?

Solution

In cake 3 you can use Collections

$allid = $this ->TableName->find()
    ->select(['id'])
    ->where(['User_id' => '1']);

$allid = $allid
    ->extract('id')
    ->toArray();

see the manual here

instead of extract - if you need to obtain a string representing the array - you can use map and reduce()

$allid = $allid
   ->map(function ($value, $key) {
        return '"'.$value->id.'"';
    })
    ->reduce(function ($accumulated, $value) {
        return $accumulated.", " .$value;
    });

Answered By - arilia