CodeIgniter Forums

Full Version: Call $this->db from initController in __construct?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

is it possible to use $this->db in controller in __construct function from BaseController?
This is my code:

PHP Code:
    public function __construct()

$data = [];

$dbData $this->db->query("SELECT * FROM myTable");
$resultBots $dbData->getResultArray();


However, I get a "We hit a snag" error.
rename the env file to .env. Edit the file and set CI_ENVIRONMENT to development.

Then you'll get an error message describing what went wrong that will answer your question.
donpwinston is right. That way you'll be able to see the errors. However I can tell you one right off the bat.

The $this->db doesn't work like you're used to in previous versions of CI. There is no more CI "superobject". You need to instantiate the things you need by calling new ClassName() and the like. For databases, there's the quick connection method of:

$db = db_connect();
$dbData = $db->query("SELECT * FROM myTable");