get data from multiple database in laravel code example

Example 1: laravel 8 app with more than one database

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

Example 2: laravel 8 app with more than one database

DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=mydatabaseDB_USERNAME=rootDB_PASSWORD=root   DB_CONNECTION_SECOND=mysqlDB_HOST_SECOND=127.0.0.1DB_PORT_SECOND=3306DB_DATABASE_SECOND=mydatabase2DB_USERNAME_SECOND=rootDB_PASSWORD_SECOND=root

Example 3: laravel 8 app with more than one database

<?php.....public function up(){    Schema::connection('mysql2')->create('blog', function (Blueprint $table) {        $table->increments('id');        $table->string('title');        $table->string('body')->nullable();        $table->timestamps();    });}.....

Tags:

Sql Example