dbprefix([$table = ''])

Hi,

reading the manual on dbprefix, I would have thought to get the prefix used one could write :

Code:

    $thePrefix=$this->db->dbprefix('');

However this fires up an error asking for a table name.
Considering the documentation states the table name is optional (and empty), I thought I could get the prefix that way.

Instead, I am doing:

Code:

        $thePrefix=substr($this->db->dbprefix('X'), 0, -1);

Not particularly elegant, but that works.

I would think either the documentation or the method behaviour should be changed.


Cheers,
L@u

Hi,

reading the manual on dbprefix, I would have thought to get the prefix used one could write :

Code:

    $thePrefix=$this->db->dbprefix('');

However this fires up an error asking for a table name.
Considering the documentation states the table name is optional (and empty), I thought I could get the prefix that way.

Instead, I am doing:

Code:

        $thePrefix=substr($this->db->dbprefix('X'), 0, -1);

Not particularly elegant, but that works.

I would think either the documentation or the method behaviour should be changed.


Cheers,
L@u

I think you can retrieve it with:

• $this->db->dbprefix; // Making before $this->load->database();
  
• $this->config->item('dbprefix', 'database');
  

Greetings.

Yes, the documentation is quite clear that:

Code:

$this->db->dbprefix('');

is for adding the default prefix to a table name, so a table name is required. http://www.codeigniter.com/user_guide/da...::dbprefix



And rtorralba is quite right, I just did a test to get the prefix with

Code:

$this->db->dbprefix;

And it worked fine.

Best wishes,

Paul