Laravel 8 Multiple Database Connection Example

Hi there,

Immediately, i we’ll present you laravel eight a number of database connection instance. This text gives you easy instance of laravel eight a number of database connection instance.

you’ll laravel eight a number of database connection instance. On this article, we’ll implement a laravel eight a number of database connection instance.

So let’s observe few step to create instance of laravel eight a number of database connection instance.

Set ENV File

it’s essential set configuration variable on .env file.
.env


DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=mydatabase
DB_USERNAME=root
DB_PASSWORD=root


DB_CONNECTION_SECOND=mysql
DB_HOST_SECOND=127.0.0.1
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=mydatabase2
DB_USERNAME_SECOND=root
DB_PASSWORD_SECOND=root

Use ENV Variable

config/database.php


<?php

use IlluminateSupportStr;

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 Database A number of Connection:

Database Reference to migration
Default:


<?php

public operate up()
{
    Schema::create('weblog', operate (Blueprint $desk) {
        $table->increments('id');
        $table->string('title');
        $table->string('physique')->nullable();
        $table->timestamps();
    });
}

Second Database Connection:


<?php

public operate up()
{
    Schema::connection('mysql2')->create('weblog', operate (Blueprint $desk) {
        $table->increments('id');
        $table->string('title');
        $table->string('physique')->nullable();
        $table->timestamps();
    });
}

Database Reference to mannequin

Default:


<?php
namespace App;
use IlluminateDatabaseEloquentModel;

class Weblog extends Mannequin
{
}

Second:


<?php
namespace App;
use IlluminateDatabaseEloquentModel;

class Weblog extends Mannequin
{
    protected $connection = 'mysql2';
}

Database Connection in Controller
Default:


<?php
class BlogController extends BaseController
{
    public operate getRecord()
    {
        $blogModel = new Weblog;
        $discover = $blogModel->discover(1);
        return $discover;
    }
}

Second:


<?php

class BlogController extends BaseController
{
    public operate getRecord()
    {
        $blogModel = new Weblog;
        $blogModel->setConnection('mysql2');
        $discover = $blogModel->discover(1);
        return $discover;
    }
}

Database Reference to Question Builder
Default:


$blogs = DB::desk("weblog")->get();
print_r($blogs);

Second:


$blogs = DB::connection('mysql2')->desk("weblog")->get();
print_r($blogs);

I hope it is going to help you…

Komentar

Posting Komentar

Postingan populer dari blog ini

Laravel 8 Get HTTP Hostname

This put up was final up to date on December 2nd, 2021 at 01:32 am Hello Dev, Right this moment, i we’ll present you laravel eight get HTTP hostname. This text provides you with easy instance of laravel eight get HTTP hostname. you’ll laravel eight get HTTP hostname. On this article, we’ll implement a laravel eight get HTTP hostname. get http host title from request object and helper that approach you possibly can simply get area title or sub area title too. request present two strategies to get hostname as getHttpHost() and getHost(). So let’s comply with few step to create instance of laravel eight get HTTP hostname. Instance: 1 $host = request()->getHttpHost(); Instance: 2 $host = request()->getHost(); Instance: 3 public perform yourControllerFun(Request $request) { $host = $request->getHttpHost(); dd($host); } I hope it would help you…
Baca selengkapnya

PHP 8 Multiple Select Dropdown Example

Gambar
by admin Writer Printed – August 10, 2021 10:51 am | Up to date – August 10, 2021 11:00 am 36 Views Hello Dev, Right this moment, i we are going to present you php Eight a number of choose dropdown instance. This text gives you easy instance of php Eight a number of choose dropdown instance. you’ll study get php Eight a number of choose dropdown instance. So let’s observe few step to create instance of php Eight a number of choose dropdown instance. Instance: index.php <html lang="en"> <head> <meta charset="utf-8"> <title>php Eight A number of Choose Dropdown Instance</title> <meta title="viewport" content material="width=device-width, initial-scale=1, shrink-to-fit=no"> <hyperlink rel="preconnect" href="https://fonts.gstatic.com"> <hyperlink href="https://fonts.googleapis.com/css2?household=JetBrains+Mono:wght@200&show=swap" rel="sty...
Baca selengkapnya

Class ‘NumberFormatter’ Not Found In Laravel 8

Hello Dev, Right this moment, i we are going to present you class ‘NumberFormatter’ not present in laravel 8. This text offers you easy instance of sophistication ‘NumberFormatter’ not present in laravel 8. you’ll class ‘NumberFormatter’ not present in laravel 8. On this article, we are going to implement a category ‘NumberFormatter’ not present in laravel 8. So let’s comply with few step to create instance of sophistication ‘NumberFormatter’ not present in laravel 8. Instance: 1 You simply must allow this extension in php.ini by uncomment this line: extension=ext/php_intl.dll Instance: 1 We have to set up PHP Intl Extension for it. So let’s open terminal run bellow command: sudo apt-get set up php7.4-intl I hope it is going to help you…
Baca selengkapnya