PHP

laravel 8 app with more than one database

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

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

laravel 8 app with more than one database

<?php   namespace App;  use IlluminateDatabaseEloquentModel;   class Blog extends Model{}

laravel 8 app with more than one database

<?php   namespace App;  use IlluminateDatabaseEloquentModel;   class Blog extends Model{    protected $connection = 'mysql2';}

laravel 8 app with more than one database

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