BoostCake

//File : src\Model\Table\ArticlesTable.php
<?php namespace="" app\model\table;="" use="" cake\orm\table;="" use="" cake\datasource\connectionmanager;="" class="" articlestable="" extends="" table="" {="" var="" $conn;="" public="" function="" initialize(array="" $config)="" {="" $this-=""?>conn = ConnectionManager::get('default');
    }
    function get_all_users($id) {
        $stmt = $this->conn->prepare('SELECT * from users WHERE id>= :id');
        $stmt->bind( ['id' => $id], ['id' => 'integer']);
        $stmt->execute();
        return $stmt->fetchAll('assoc');
     }  
}
?>

//File: src\Controller\ArticlesController.php 
<?php namespace="" app\controller;="" use="" cake\core\configure;="" use="" cake\network\exception\notfoundexception;="" use="" cake\view\exception\missingtemplateexception;="" use="" cake\orm\tableregistry;="" use="" cake\datasource\connectionmanager;="" use="" myclass\myclass;="" use="" mylib\utilclass;="" class="" articlescontroller="" extends="" appcontroller="" {="" public="" $helpers="array('Html'," 'form');="" public="" function="" index()="" {="" }="" public="" function="" showarticles(){="" $data="$this-"?>Articles->get_all_users(3);
         $this->set('data',$data);
    }
}

//File: src\Template\Articles\showarticles.ctp
<?php foreach="" ($data="" as="" $row){="" echo=""?>  
'.$row['username']. '-------' . $row['password'];
         }
?>