Connecting to another MySQL DB from within a plugin

Sean -

Here’s a copy of the __construct() from a test plugin I threw together to do what you’re looking for. I’ve tested it and it seems to work:

public function __construct()
    {
        $this->EE =& get_instance();
        
        $this->alt_db = mysql_connect($this->EE->db->hostname,$this->EE->db->username,$this->EE->db->password);
        mysql_select_db('pi_test_db',$this->alt_db);
        
        $out = array();
        $q = mysql_query("SELECT * FROM `pi_test_tab`;",$this->alt_db);
        while ($row = mysql_fetch_assoc($q))
        {
            $out[$row];
        }
        
        $this->return_data = print_r($out,TRUE);
    }

Is it the best way to do it? Probably not. But it works.

Hi Mark,

Thank you so much for the code snippet. It worked first time after I swapped your example details with mine…

Sean

You could also try:

$this->EE = get_instance();
$this->EE->load->database(‘xxx’);

Thanks for your input also Shawn! Always good to have more example. 😊

You could also try:

$this->EE = get_instance();
$this->EE->load->database(‘xxx’);

Interested, would this trump the default EE loaded DB or create a new DB object which can be queried alongside the standard EE DB connection? 😊

http://ellislab.com/forums/viewthread/195522/

Works for me. Helps if you are familiar with Code ignitor.

You could also try:

$this->EE = get_instance();
$this->EE->load->database(‘xxx’);

Interested, would this trump the default EE loaded DB or create a new DB object which can be queried alongside the standard EE DB connection? 😊

Correct, it won’t trump the default DB instance as we are selecting another DB object.