Dynamic Database in Codeigniter

Question

I get the database information:

$data4shop['webshops'] = $this->Product_shop_model->getWebshop($businessId)->result();

I only need to insert it into the database.php. I want it to look like this, but it doesn't work:

$db['shop'] = array(
'dsn'      => '',
'hostname' => $hostname,
'username' => $username,
'password' => $password,
'database' => $database,

I don't know how to pass the variables into database.php. How can I do that?

check this : stackoverflow.com/questions/25457241/…

Saranya Rajendran
– Saranya Rajendran

2018-03-07 10:44:04 +00:00
Commented Mar 7, 2018 at 10:44 — Saranya Rajendran
– Saranya Rajendran, Commented Mar 7, 2018 at 10:44
I have read that but its not what I want

Dogelismoツ
– Dogelismoツ

2018-03-07 11:16:55 +00:00
Commented Mar 7, 2018 at 11:16 — Dogelismoツ
– Dogelismoツ, Commented Mar 7, 2018 at 11:16

Dogelismoツ · Accepted Answer · 2018-03-21 08:38:44Z

0

this is in the controller:

    $db_hostname = $databaseInfo['Hostname'];
    $db_username = $databaseInfo['Username'];
    $db_password = $databaseInfo['Password'];
    $db_database = $databaseInfo['Database'];

    $config_app = switch_db_dinamico($db_hostname, $db_username, $db_password, $db_database);

    $this->Product_shop_model->shop_db = $this->load->database($config_app, TRUE);

This is the helper(db_dinamic_helper):

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
function switch_db_dinamico($hostname, $username, $password, $name_db)
{
    $config_app['hostname'] = $hostname;
    $config_app['username'] = $username;
    $config_app['password'] = $password;
    $config_app['database'] = $name_db;
    $config_app['dbdriver'] = 'mysqli';
    $config_app['dbprefix'] = '';
    $config_app['pconnect'] = FALSE;
    $config_app['db_debug'] = FALSE;
    return $config_app;
}

edited Mar 21, 2018 at 8:38

Dogelismoツ

1910 bronze badges

answered Mar 14, 2018 at 13:46

ZeroStriker X

268 bronze badges

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

Collectives™ on Stack Overflow

Dynamic Database in Codeigniter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related