Welcome Guest, Not a member yet? Register   Sign In
Switch database based on parameter
#5

(This post was last modified: 04-22-2015, 12:56 AM by rejoan.)

not helped. Solution is change database.php as follow
PHP Code:
if (isset($_GET['cfg'])) {
    
$efg = (int) $_GET['cfg'];
} else {
    
$efg 1;
}

$dbh = new PDO('mysql:host=localhost;dbname=chat''root''');

$sql 'SELECT db_user,db_name,db_pass FROM clients WHERE id=?';

$sth $dbh->prepare($sql);
$sth->execute(array($efg));
$d_result $sth->fetchAll(PDO::FETCH_ASSOC);
//var_dump($d_result);
// We are done with PDO for this purpose so free up some resources!
$dbh null;
unset(
$dbh);

$db['default'] = array(
    
'dsn' => '',
    
'hostname' => 'localhost',
    
'username' => $d_result[0]['db_username'],
    
'password' => $d_result[0]['db_pass'],
    
'database' => $d_result[0]['db_name'],
.... 
The largest Bengali tutorial site on Web Development in this planet
Reply


Messages In This Thread
Switch database based on parameter - by rejoan - 04-21-2015, 12:40 AM
RE: Switch database based on parameter - by rejoan - 04-22-2015, 12:56 AM



Theme © iAndrew 2016 - Forum software by © MyBB