Welcome Guest, Not a member yet? Register   Sign In
multiple databases connectivity
#1

I have the following code in model to connect to another database.


PHP Code:
        $db_name $this->session->userdata('db_name');
        $this->anotherDb $this->load->database($db_nameTRUE); 

but if I try to query in another model using the anoterDb using the following:

PHP Code:
        $query=$this->anotherDb->query("SELECT fieldValue
                                 FROM settings
                                 WHERE fieldName ="
."'".$fieldName."'"
                                 )->row_array();
                      $fieldValue $query['fieldValue']; 

error:
Quote:Message: Undefined property: Users::$anotherDb

to remove this error I need to reconnect to above database "anotherDb" in every model.
How can I solve this?


How can I make some global variable to be used in every model?
Reply


Messages In This Thread
multiple databases connectivity - by nadeem14375 - 10-12-2017, 07:13 PM



Theme © iAndrew 2016 - Forum software by © MyBB