Hello friends, In this example we show how to connect multiple database in laravel 8. We will show laravel 8 multiple database connections. In this post we will step by step to implementation of how to use laravel 8 multiple database connections.
Sometimes we need to use multiple database connection such as MySQL, MongoDB, PostgreSQL etc. Here, we will show laravel 8 multiple database connection, manage multiple database connection in laravel 8, one or more database connection in single laravel 8 application.
Read also : Laravel 8 cURL HTTP Request Example
Set .env Variable For Laravel 8 Multiple Database Connections
// Database 1 DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database_1 DB_USERNAME=root DB_PASSWORD= // Database 2 DB_CONNECTION_SECOND=mysql DB_HOST_SECOND=127.0.0.1 DB_PORT_SECOND=3306 DB_DATABASE_SECOND=database_2 DB_USERNAME_SECOND=root DB_PASSWORD_SECOND=
Use .env Variable :
<?php use Illuminate\Support\Str; return [ 'default' => env('DB_CONNECTION', 'mysql'), 'connections' => [ ..... 'mysql' => [ 'driver' => 'mysql', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => true, 'engine' => null, 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), ]) : [], ], 'mysql2' => [ 'driver' => env('DB_CONNECTION_SECOND'), 'host' => env('DB_HOST_SECOND', '127.0.0.1'), 'port' => env('DB_PORT_SECOND', '3306'), 'database' => env('DB_DATABASE_SECOND', 'forge'), 'username' => env('DB_USERNAME_SECOND', 'forge'), 'password' => env('DB_PASSWORD_SECOND', ''), 'unix_socket' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => true, 'engine' => null, ], .....
Use Laravel 8 Multiple Database Connections :
Here, I will give you simple example of how to use as multiple connection with migration.
Default Database :
public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('email'); $table->timestamps(); }); }
Second Database :
public function up() { Schema::connection('mysql2')->create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('email'); $table->timestamps(); }); }
Use Multiple Database Connection with Model
In this step we will see multi database with model.
Default :
<?php namespace App; use Illuminate\Database\Eloquent\Model; class Users extends Model { .... }
Second :
<?php namespace App; use Illuminate\Database\Eloquent\Model; class Users extends Model { protected $connection = 'mysql2'; ... }
Use Multiple Database Connection in Controller
class UsersController extends BaseController { public function getRecord() { $users = new Users; $find = $users->find(1); return $find; } }
Second :
class UsersController extends BaseController { public function getRecord() { $users = new Users; $users->setConnection('mysql2'); $find = $users->find(1); return $find; } }
Use Multiple Database Connection with Query Builder
$users = DB::table("users")->get(); print_r($users);
Second :
$users = DB::connection('mysql2')->table("users")->get(); print_r($users);
I hope you understand of multiple database connection in laravel 8 and it can help you…