Multi-tenant in Laravel4

Question

I'm building a multi-tenant app, using the subdomain to separate the users. e.g. .myapp.com

I want to give each tenant their own database too.

How can I detect the subdomain and set the database dynamically?

Also, the code below is from the official documentation and shows us how we can get the subdomain when setting up a route. But how do we pass the subdomain value to a controller function?

Route::group(array('domain' => '{account}.myapp.com'), function()
{

    Route::get('user/{id}', function($account, $id)
    {
        //
    });

});

Jason Lewis · Accepted Answer · 2013-06-02 11:17:14Z

2

The best way to achieve this would be in a before filter that you apply to the route group.

Route::group(['domain' => '{account}.myapp.com', 'before' => 'database.setup'], function()
{
    // Your routes...
}

This before filters gets a $route parameter and a $request parameter given to it, so we can use $request to get the host.

Route::filter('database.setup', function($route, $request)
{
    $account = $request->getHost();
}

You could then use the account to adjust the default database connection using Config::set in the filter. Perhaps you need to use the default connection first up to fetch the users database details.

$details = DB::details()->where('account', '=', $account)->first();

// Make sure you got some database details.

Config::set('database.connections.account', ['driver' => 'mysql', 'host' => $details->host, 'database' => $details->database, 'username' => $details->username, 'password' => $details->password]);

Config::set('database.connections.default', 'account');

During runtime you create a new database connection and then set the default connection to that newly created connection. Of course, you could leave the default as is and simply set the connection on all your models to account.

This should give you some ideas. Please note that none of this code was tested.

Also, each method on your controllers will receive the domain as the first parameter. So be sure to adjust for that if you're expecting other parameters.

edited Jun 2, 2013 at 11:17

answered Jun 2, 2013 at 4:53

Jason Lewis

18.7k4 gold badges63 silver badges65 bronze badges

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

2 Comments

wyred Over a year ago

In the second part of your code, $route->getHost(); returned the string "{account}.myapp.com" instead of the value of the subdomain. Where could I have done wrong?

Jason Lewis Over a year ago

Ah, you might have better luck with $request->getHost().

Collectives™ on Stack Overflow

Multi-tenant in Laravel4

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related