How to pass database result set from controller to a view

Firstly, please try to make your query works in Models.

Secondly  :

Code:

<li><?= $row ?></li>

$row what? $row->user_name  ?? or $row->phone_number  ?? or $row->blog_title ??

Hi demyr:

The issue is passing the database result set to the view.

The following code works just fine in the Controller:

Code:

$db = \Config\Database::connect();

$query = $db->query('SELECT name, title, email FROM my_table');
$data = $query->getResult();

foreach ($results as $row)
{
      echo $row->title . " ";
      echo $row->name . " ";
      echo $row->email . " ";
      echo "<br>";
}

echo 'Total Results: ' . count($results);