Welcome Guest, Not a member yet? Register   Sign In
dbprefix([$table = ''])
#1

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,
[email protected]
Reply
#2

(10-25-2015, 07:59 AM)ComputingFroggy Wrote: 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,
[email protected]

I think you can retrieve it with:
  • $this->db->dbprefix; // Making before $this->load->database();
  • $this->config->item('dbprefix', 'database');
Greetings.
Reply
#3

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
Reply




Theme © iAndrew 2016 - Forum software by © MyBB