Codeigniter query profiler with multiple database connection

Question

I'm using codeigniter 2.0++ or specifically 3.0-dev. The thing is I have multiple database connection and the profiler only shows query from the default connection $this->db.

class table_m extends CI_Model
{

    function __construct()
    {
        parent :: __construct(); 
        $this->db2 = $this->load->database('production', TRUE);
    }

    function sel_pameran($ukmper=NULL)
    {
        $sql = "SELECT * from table1";

        $query = $this->db2->query($sql);
        return $query->result();
    }
}

This query won't be shown in the profiler because it uses $this->db2. So how do make the profiler shows every query that is executed, doesn't matter from which database?

Community · Accepted Answer · 2017-05-23 11:52:27Z

5

See this question. It's a much simpler solution. How can I display my database queries in the Codeigniter Profiler when I load my databases in my models?

Simply store your databases to the main CI class and the profiler will be able to access them.

function __construct()
{

    parent::__construct();

    $CI =& get_instance();
    if( is_null( $CI->Companies_db ) )
        $CI->Companies_db =& $this->load->database( 'companies', TRUE, TRUE );          

}

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jul 11, 2012 at 16:20

T. Brian Jones

13.7k26 gold badges85 silver badges121 bronze badges

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

1 Comment

AeroCross Over a year ago

If you're lucky, without further tweaking, this will work flawlessly. And it's 2.X compatible.

Mr Wednesday · Accepted Answer · 2012-05-07 02:01:28Z

1

I had a similar problem. I was using a local mysql database and also accessing a remote Oracle database. The Oracle queries were not being shown in the profiler.

This article helped me to fix the problem:

http://www.gotphp.com/codeigniter-multiple-database-support/5468/

answered May 7, 2012 at 2:01

Mr Wednesday

5524 silver badges18 bronze badges

1 Comment

T. Brian Jones Over a year ago

Here is an updated version of the post that fixes this for newer versions of Codeigniter: gotphp.com/codeigniter-profiler-extended/54358

Collectives™ on Stack Overflow

Codeigniter query profiler with multiple database connection

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related