Get data from another Database in Codeigniter MySQL

Question

I want to get data from another DB in MySQL except the defualt DB. I added the following line into my model in addition to the excisting code. Another DB as 'storesDB'.

$this->load->database('storesDB', TRUE);

My model as follows :

public function getEquipment($id = null)
    {  
        $this->db->select('*');
        $this->db->from('tbl_equipment');
        $this->db->join('tbl_equipment_category', 'tbl_equipment.eq_cat=tbl_equipment_category.id_cat');
        $this->db->where("tbl_equipment.status", '1');
        if ($id)
            $this->db->where("tbl_equipment.id", $id);        
            $query = $this->db->get();
        return $query->result();
    }

The code is working properly. But the code got data from defualt DB not the by the 'storesDB'.

Modified code is as follows :

public function getEquipment($id = null)
    {       
        $this->load->database('storesDB', TRUE);
        $this->db->select('*');
        $this->db->from('tbl_equipment');
        $this->db->join('tbl_equipment_category', 'tbl_equipment.eq_cat=tbl_equipment_category.id_cat');
        $this->db->where("tbl_equipment.status", '1');
        if ($id)
            $this->db->where("tbl_equipment.id", $id);        
            $query = $this->db->get();
        return $query->result();
    }

What may be the reason?

Vickel · Accepted Answer · 2022-10-06 18:24:55Z

1

The reason is that you don't assign the second database properly. You also need to setup the correct config for the 2nd database

$config['hostname'] = "host";
$config['username'] = "user";
$config['password'] = "pass";
$config['database'] = "storesDB";
// etc..

then you load the database:

$this->db2 = load->database($config, TRUE);

now you have $this->db, the default database and $this->db2, the second database

and continue your code like:

$this->db2->select('*');
$this->db2->from('tbl_equipment');
// etc...

edited Oct 6, 2022 at 18:24

answered Oct 6, 2022 at 17:42

Vickel

7,9906 gold badges40 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

camaleongdl · Accepted Answer · 2022-10-06 17:49:32Z

1

I have no experience in Codeigniter, but in a standar sql query you can add the database name in front of the table to get info from another db like:

SELECT * FROM sakila.actor;

Assuming you are not connected to sakila db.

Using this aproach both databases must have same credentials

answered Oct 6, 2022 at 17:49

camaleongdl

234 bronze badges

Collectives™ on Stack Overflow

Get data from another Database in Codeigniter MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related