Database query in a controller method?

What you did works perfectly fine. If you just need it in the one method, though, no need to set it at the class level.

Code:

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

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials