jeudi 12 juillet 2018

Undefined Index Driver

I have two different database and i connect to another database to get the data. It works fine but when i continuously press refresh it throws Undefined Index Driver. below is my code

CONNECTION TO ANOTHER DATABASE

// Disconnect old connection and connect to other database
$dm = app("Illuminate\Database\DatabaseManager");
$dm->disconnect();
$model = Config::set("database.connections.pgsql", [
  'driver'    => 'pgsql',
  'host'      => '127.0.0.1',
  'port'      => '5432',
  'database'  => 'jobseeker',
  'username'  => 'postgres',
  'password'  => 'root',
  'charset'   => 'utf8',
]);
DB::setDefaultConnection('pgsql');
DB::reconnect($model);

//End RE CONNECTION TO CURRENT DATABASE

// Disconnect old connection and connect to original database
$model = Config::set("database.connections.".env('DB_CONNECTION'), [
    'driver'    => env('DB_CONNECTION'),
    'host'      => env('DB_HOST'),
    'port'      => env('DB_PORT'),
    'database'  => env('DB_DATABASE'),
    'username'  => env('DB_USERNAME'),
    'password'  => env('DB_PASSWORD'),
    'charset'   => 'utf8',
]);
DB::setDefaultConnection(env('DB_CONNECTION'));
DB::reconnect($model);
//End

The reason behind the error is, i called credential from env file and on refresh it sometime dosent get value from env. I dont want to use hardcore values to reconnect to current database. Is there any solution for this



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire