How to pass database result set from controller to a view

Let me write you an example



Model:

PHP Code:

<?php namespace App\Models;
use CodeIgniter\Model;


class CountriesModel extends Model{
    protected $table = 'countries';
    protected $allowedFields = [
        'country_name',
        'country_name_slug',
        'country_code'
    ];
    protected $returnType = 'object';
    protected $primaryKey = 'country_id';

    public function get_countries(){
        $db      = \Config\Database::connect();
        $builder = $db->table('countries');   
        
        $query = $builder->select('*')
                         ->get();

        return $query->getResult();
    }

    

} 

?>

Controller:

PHP Code:

<?php namespace App\Controllers;

use App\Models\CountriesModel;

class MyController extends BaseController
{
    public function __construct()
    {
        $this->CountryModel = new CountriesModel();
    }

public function countries(){

            $data['title'] = 'Countries';
            
            $data['countries'] = $this->CountryModel->get_countries();

            echo view('folder_name/assets/header', $data);
            echo view('folder_name/countries');
            echo view('folder_name/assets/footer');
        
    } //countries ends

} //basecontroller ends 


View:

PHP Code:

<ul>

  <?php foreach ($countries as $counrty) {?>
    <li><?php echo $country->country_name; ?></li>
  <?php }?>

</ul> 


I would advise you to keep it clean and simple.