PHPackages danthedj/multitenant2 - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. danthedj/multitenant2 ActiveLibrary danthedj/multitenant2 ===================== Laravel Tenant Dynamic Database Solution. v1.9.0(4y ago)0376MITPHPCI failing Since Feb 7Pushed 4y ago1 watchersCompare [ Source](https://github.com/DanTheDJ/multitenant2)[ Packagist](https://packagist.org/packages/danthedj/multitenant2)[ RSS](/packages/danthedj-multitenant2/feed)WikiDiscussions 1.6 Synced 1mo ago READMEChangelogDependencies (2)Versions (21)Used By (0) Laravel MultiTenant 1.4 ----------------------- [](#laravel-multitenant-14) [![Build Status](https://camo.githubusercontent.com/1168a5d9d2028ddbde2b8fb3bb600ae00957a80ad5402bceb7a3c6be51feee8a/68747470733a2f2f7472617669732d63692e6f72672f44616e546865444a2f6d756c746974656e616e742e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/DanTheDJ/multitenant) The Laravel 5.4 MultiTenant package enables you to easily add multi-tenant capabilities to your application. This package is designed using a minimalist approach.Just drop it in, run the migration, and start adding tenants. Your applications will have access to current tenant information through the dynamically set config('tenant') values. Optionally, you can let applications reconnect to the default master database so a tenant could manage all tenant other accounts for example. And, perhaps the best part, Artisan is completely multi-tenant aware! Just add the --tenant option to any command to run that command on one or all tenants. Works on migrations, queueing, etc.! MultiTenant also offers a TenantContract, triggers Laravel events, throws a TenantNotResolvedException and TenantDatabaseNameEmptyException, so you can easily add in custom functionality and tweak it for your needs. Laravel MultiTenant was forked from @thinksaydo, who modified the original Tenantable project by @leemason. All of the main code is due to them. The difference in this project is that it allows for a database per tenant, compared to a single database with table prefixes. This allows for a more managed approach in some cases. MultiTenant relies on your ENV and Database config and stores just the connection name in the table and only allows one subdomain and domain per tenant, which is most often plenty for most apps. MultiTenant also throws a TenantNotResolvedException when tenants are not found, and a TenantDatabaseNameEmptyException when the database name could not be determined. Simple Installation & Usage ------------------------------- [](#simple-installation--usage) ### Composer install: [](#composer-install) ``` composer require danthedj/multitenant ``` ### Generate composer autoload file: [](#generate-composer-autoload-file) ``` composer dump-autoload ``` Tenants database table install (uses default database connection): ``` artisan migrate --path /vendor/danthedj/multitenant/migrations ``` ### Service provider install: [](#service-provider-install) #### Resolve every route/request [](#resolve-every-routerequest) If you want to resolve the client on every route/request add in ``` DanTheDJ\MultiTenant\TenantServiceProvider::class, ``` to the Service providers array in `config/app.php` *Note:* This is the default that Laravel 5.5 (and above) will use for auto discovery. If you want to use the middleware option please add the following to your project's composer.json file. ``` "extra": { "laravel": { "dont-discover": [ "DanTheDJ\\MultiTenant\\TenantServiceProvider" ] } } ``` #### Resolve tenants through Middleware [](#resolve-tenants-through-middleware) If you only want to resolve tenant using a Middleware on a route add in ``` DanTheDJ\MultiTenant\Providers\TenantMiddlewareServiceProvider::class, ``` to the Service providers array in `config/app.php` **instead** of the service provider above. ### Database connection: [](#database-connection) In `config/database.php` create a new connection. For the `host`, `port` ,`username` and `password`, these are picked up from the `.env` file. ``` 'tenant_db' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => '', // The database name will be filled in dynamically upon the tenant being resolved. 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'database_prefix' => '', // this can be changed and represents a database prefix e.g. 'business_acme'. 'strict' => true, 'engine' => null, ], ``` Tenant creation (just uses a standard Eloquent model): ``` $tenant = new \DanTheDJ\MultiTenant\Tenant(); $tenant->name = 'ACME Inc.'; $tenant->email = 'person@acmeinc.com'; $tenant->subdomain = 'acme'; $tenant->alias_domain = 'acmeinc.com'; $tenant->connection = 'tenant_db'; $tenant->meta = ['phone' => '123-123-1234']; $tenant->save(); ``` And you're done! Minimalist, simple. Whenever your app is visited via or the connection "tenant\_db" will be used, the database name will switch to "{prefix}\_acme", and config('tenant') will be set with tenant details allowing you to access values from your views or application. Advanced EnvTenant Usage ------------------------ [](#advanced-envtenant-usage) ### Artisan [](#artisan) ``` // migrate master database tables (in tenant database) php artisan migrate // migrate specific tenant database tables php artisan migrate --tenant=acme // migrate all tenant database tables php artisan migrate --tenant=* ``` The --tenant option works on all Artisan commands: ``` php artisan migrate:rollback --tenant=acme ``` You can also use the --tenant option when tinkering: ``` php artisan tinker --tenant=acme ``` ### Tenant [](#tenant) The `\DanTheDJ\MultiTenant\Tenant` class is a simple Eloquent model providing basic tenant settings. ``` $tenant = new \DanTheDJ\MultiTenant\Tenant(); // The unique name field identifies the tenant profile $tenant->name = 'ACME Inc.'; // The non-unique email field lets you email tenants $tenant->email = 'person@acmeinc.com'; // The unique subdomain field represents the subdomain portion of a domain and the database table prefix // Set subdomain and alias_domain field to NULL to access tenant by ID instead $tenant->subdomain = 'acme'; // The unique alias_domain field represents an alternate full domain that can be used to access the tenant // Set subdomain and alias_domain field to NULL to access tenant by ID instead $tenant->alias_domain = 'acmeinc.com'; // The non-unique connection field stores the Laravel database connection name $tenant->connection = 'db1'; // The meta field is cast to an array and allows you to store any extra values you might need to know $tenant->meta = ['phone' => '123-123-1234']; $tenant->save(); ``` ### TenantResolver [](#tenantresolver) The `\DanTheDJ\MultiTenant\TenantResolver` class is responsible for resolving and managing the active tenant during Web and Artisan access. You can access the resolver class using `app('tenant')`. ``` // get the resolver instance $resolver = app('tenant'); // check if valid tenant $resolver->isResolved(); // get the active tenant (returns Tenant model or null) $tenant = $resolver->getActiveTenant(); // get all tenants (returns collection of Tenant models or null) $tenants = $resolver->getAllTenants(); // activate and run all tenants through a callback function $resolver->mapAllTenants(function ($tenant) {}); // reconnect default connection enabling access to "tenants" table $resolver->reconnectDefaultConnection(); // reconnect tenant connection disabling access to "tenants" table $resolver->reconnectTenantConnection(); ``` If you want to use a custom model, register a custom service provider that binds a singleton to the TenantContract and resolves to an instance of your custom tenant model. EnvTenant will automatically defer to your custom model as long as you load your service provider before loading the EnvTenant\\TenantServiceProvider. Create this example service provider in your app/Providers folder as CustomTenantServiceProvider.php: ```