3

How can a database connection be changed when user is admin role? Admin database contains information that must not be accessible to other user's and requirement also is that database must be located on own server. I do have currently separate configuration for admin connection.

'mysql' => [
    'host'      => 'admin.psa44.localhost'
    'driver'    => 'mysql',
    'database'  => 'database',
    'username'  => 'root',
    'password'  => 'secretpassword',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix'    => '',
],

I want that no hardcoding is in application so how can Laravel do the switch when necessary? Thanks for any help.

Improve this question
0

1 Answer 1

Reset to default
4

You need to create new database config rule in appconfig.

'mysql' => [
    'host'      => 'admin.psa44.localhost'
    'driver'    => 'mysql',
    'database'  => 'database',
    'username'  => 'root',
    'password'  => 'secretpassword',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix'    => '',
],
'mysql_admin' => [
    'host'      => 'admin.psa44.localhost'
    'driver'    => 'mysql',
    'database'  => 'admindatabase',
    'username'  => 'root',
    'password'  => 'secretpassword1',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix'    => '',
],

I named mysql_admin. In migration when use 

Schema::create('some_table', function($table)

to create table ,use

Schema::connection('mysql_admin')->create('some_table', function($table)

to create that table in other database.

For query to that database do something like this

$admins = DB::connection('mysql_admin')->select(...);

And you can to define connection for model

class AdminModel extends Eloquent {

    protected $connection = 'mysql_admin';

}
Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

all very good but why not name it mysql_admin or something :P
@Andrew that's very nice help thank you I update my answer :)