How to use multiple database in Laravel ?

In this tutorial i’m going to learn how to configure multiple database from one project to another project so follow this tutorial i have mentioned in very easy way.

1st go to below file

config / database.php
'payments' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST_STATS_TYPE_COUNT', 'localhost'),
            'port' => env('DB_PORT_STATS_TYPE_COUNT', '3306'),
            'database' => env('DB_DATABASE_STATS_SHOW_COUNT', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
        ],

Next go to first project .env file and put below code

DB_CONNECTION_STATS_COUNT=mysql
DB_HOST_STATS_TYPE_COUNT=127.0.0.1
DB_PORT_STATS_TYPE_COUNT=3306
DB_DATABASE_STATS_SHOW_COUNT=wz_stats_show
DB_USERNAME_USER_COUNT=root
DB_PASSWORD_STATS_TYPE_COUNT=
DB_CONNECTION_STATS_COUNT=mysql
DB_HOST_STATS_TYPE_COUNT=127.0.0.1
DB_PORT_STATS_TYPE_COUNT=3306

Next go to model and paste below code

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class payments extends Model
{
    protected $connection = 'payments';
    protected $table = 'payments';
}

Now all configuration has been setup successfully, now you can use it for insert data update or delete.

Hi I am Amit Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.

Related Posts

Top 25 Linux Commands for Users ?

In this tutorial i’m going to share Top 50 Important Linux Command for users with example. 1. Use of ls -la command. The ls -la command is…

XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not foundfail.

In this tutorial we’re going to solve the error XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not foundfail. Solution :- Next to restart the server

SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into `oauth_clients` (`user_id`, `name`, `secret`

In this tutorial we are going to solve error SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into oauth_clients (user_id, name, secret error: –…

The Go-To Influencer Platforms for 2024

In the ever-evolving landscape of influencer marketing, one platform has risen above the rest to claim its throne as the reigning champion in 2024: WizBrand. With its…

Medical Tourism: A Distinguished Name in Worldwide Healthcare Travel

In the expanding world of medical tourism, certain websites have established themselves as distinguished names, offering unparalleled access to global healthcare services. These platforms serve as crucial…

Call to a member function getClientOriginalExtension() on null

In this tutorial i’m going to learn how to solve this issue Call to a member function getClientOriginalExtension() on null. This error usually occurs when you try…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x