Codeigniter database prefix add in table

Question

I have one database in which all table names like below

configuration_dst,
developer_dst,
application_dst

Now I want to manage my query in which want to add database prefix after table name instead of before. For example :

{TABLE NAME}{PREFIX}

is it possible to manage using CI 3.0 ?

I have tried like below in Application/configuration/database.php

$db['default']['dbprefix']="_dst";
$db['default']['swap_pre']="{POST}";

Current Query :

$this->db->get('templates');

Current Table Name :

 tablename : _dsttemplates

Expected Table Name :

tablename : templates_dst

I need prefix after table Name not before but didn't get any solution.

$db['default']['swap_pre'] "{POST}"; should be $db['default']['swap_pre']="{POST}"; — Abdulla Nilam
– Abdulla Nilam, Commented Sep 17, 2015 at 4:48
sorry for forgot to add =(Equal sign) I want like below $this->db->get('developer') and prefix will add _mst so table name like developer_mst currently it is add prefix like _mstdeveloper and its not correct — Ankit Doshi
– Ankit Doshi, Commented Sep 17, 2015 at 4:50

Dekker1 · Accepted Answer · 2017-07-28 09:30:12Z

1

The only option is to change in driver files. You can do this using the following steps:

Go to /system/database/DB_query_builder.php
Search public function dbprefix

Replace

return $this->dbprefix.$table;

with

return $table.$this->dbprefix;

If it also interferes in any other places in your project then create a new function with replaced code like:

public function dbsuffix($table = '')
{
    if ($table === '')
    {
        $this->display_error('db_table_name_required');
    }

    return $table.$this->dbprefix;
}

edited Jul 28, 2017 at 9:30

Dekker1

5,83627 silver badges34 bronze badges

answered Jul 28, 2017 at 9:13

Pawnesh Kumar

4942 silver badges10 bronze badges

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

Comments

Abdulla Nilam · Accepted Answer · 2015-09-17 04:59:49Z

0

Working with Database prefixes manually

if you use

$this->db->set_dbprefix('newprefix');
$this->db->dbprefix('tablename'); // outputs newprefix_tablename

its always gives the table name as

newprefix_tablename

Because this is Codeigniter pastern.

Codeigniter Prefix

answered Sep 17, 2015 at 4:59

Abdulla Nilam

39.8k18 gold badges85 silver badges115 bronze badges

4 Comments

Ankit Doshi Over a year ago

I know this but i need tablename_prefix

Abdulla Nilam Over a year ago

so that you cant use Codeigniter dbprefix function.

Ankit Doshi Over a year ago

How can i achieve this any help ?

Abdulla Nilam Over a year ago

@AnkitDoshi check this

Collectives™ on Stack Overflow

Codeigniter database prefix add in table

2 Answers 2

Comments

Working with Database prefixes manually

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Working with Database prefixes manually

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related