Breaking News: Grepper is joining You.com. Read the official announcement!

DB::connection('local')->create() laravel

Depressed Dotterel answered on August 24, 2021 Popularity 9/10 Helpfulness 3/10

answer DB::connection('local')->create() laravel

related laravel database connection

DB::connection('local')->create() laravel

Comment

$users = DB::connection('foo')->select(...);

Popularity 9/10 Helpfulness 3/10 Language php

Source: laravel.com

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Aug 24 2021

Depressed Dotterel

0 Answers Avg Quality 2/10

Closely Related Answers

laravel database connection

Comment

// config/database.php

'connections' => [
    'mysql' => [
        'driver' => 'mysql',
        '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' => '',
        'strict' => true,
        'engine' => null,
    ],
    'mysql2' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST_SECONDARY', '127.0.0.1'),
        'port' => env('DB_PORT_SECONDARY', '3306'),
        'database' => env('DB_DATABASE_SECONDARY', 'forge'),
        'username' => env('DB_USERNAME_SECONDARY', 'forge'),
        'password' => env('DB_PASSWORD_SECONDARY', ''),
        'unix_socket' => env('DB_SOCKET_SECONDARY', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],
],

// config/session.php

'driver' => env('SESSION_DRIVER', 'file'),
(or) 'driver' => env('SESSION_DRIVER', 'database')

'connection' => env('SESSION_CONNECTION', null),

// .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_main_database
DB_USERNAME=your_main_db_user
DB_PASSWORD=your_main_db_password

DB_CONNECTION_SECONDARY=mysql2
DB_HOST_SECONDARY=127.0.0.1
DB_PORT_SECONDARY=3306
DB_DATABASE_SECONDARY=your_session_database
DB_USERNAME_SECONDARY=your_session_db_user
DB_PASSWORD_SECONDARY=your_session_db_password

SESSION_DRIVER=database
SESSION_CONNECTION=mysql2


//// migrate session table

php artisan session:table
php artisan migrate --database=mysql2

Popularity 9/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: database-connection data

Link to this answer
Share Copy Link

Contributed on May 31 2024

Poor Pygmy

0 Answers Avg Quality 2/10

DB::connection('local')->create() laravel

Contents

More Related Answers

DB::connection('local')->create() laravel

Closely Related Answers

laravel database connection

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.