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

Hi all,

I am trying to use / change the database for different organizations / users. In master database, I have db_name for different organizations, I am using  the following code to store the db_name in session.


Code:
$condition = "subdomain =" . "'" . $data['subdomain'] . "' AND " . "status =1";

$this->db->select('id, db_name');
$this->db->from('sublogin');
$this->db->where($condition);
$this->db->limit(1);

$db_name = $this->db->get()->row()->db_name;

// SET db_name for session
$this->session->set_userdata('db_name', $db_name);

in another model, switch the database 


PHP Code:
$db_name $this->session->userdata('db_name');

$this->db->db_select($db_name); 

Its working in localhost but not on my live server.
Whats wrong here?
Reply


Messages In This Thread
switching databases - by nadeem14375 - 10-05-2017, 04:06 AM
RE: switching databases - by ponzo - 10-05-2017, 04:33 AM
RE: switching databases - by nadeem14375 - 10-05-2017, 04:58 AM
RE: switching databases - by nadeem14375 - 10-05-2017, 06:50 AM



Theme © iAndrew 2016 - Forum software by © MyBB