Welcome Guest, Not a member yet? Register   Sign In
Call $this->db from initController in __construct?
#1

Hi,

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.
Reply
#2

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.
Simpler is always better
Reply
#3

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:

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




Theme © iAndrew 2016 - Forum software by © MyBB