Setting Database in codeigniter based on the URL (dynamically)

Question

I am using codeigniter to develop my web based application. This will be used by various different clients and each will have there own database but same codebase.

I want to be able to set the name of database in database.php based on the clients who access it i.e based on the url. So if clientA.com access its then it should set the database name to clintA and if clientB.com access it then it should set it to clientB.com.

Any idea as how should I approch this.

davidethell · Accepted Answer · 2012-10-11 11:15:36Z

4

There are several possible ways, but probably the easiest is to use database groups in your config file. In your application/config/database.php file use a multi-dimensional array to create different groups for each of your clients. So you could have:

$db['clientA']['hostname'] = ...
$db['clientA']['username'] = ...
etc...
$db['clientB']['hostname'] = ...
$db['clientB']['username'] = ...
etc...

Now in your application you can just pass the desired group to your load command:

$this->load->database('clientA');

Now combine that with getenv to grab the host name and you should be all set:

$clientHost = getenv('HTTP_HOST');
$this->load->database($clientHost);

Of course there could be more logic needed, but that should get you started.

answered Oct 11, 2012 at 11:15

davidethell

12.1k6 gold badges47 silver badges67 bronze badges

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

1 Comment

nasaa Over a year ago

Thanks David. I will work on the line you suggested and see how it goes.

Collectives™ on Stack Overflow

Setting Database in codeigniter based on the URL (dynamically)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related