laravel 链接多库方案

1.配置 config/database.php 文件

        将要添加的新数据库添加到 database.php文件的 connections 中

'connections' => [

        'sqlite' => [
            'driver' => 'sqlite',
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
        ],
        'ceshi' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST_ESTATE', '127.0.0.1'),
            'port' => env('DB_PORT_ESTATE', '3306'),
            'database' => env('DB_DATABASE_ESTATE', 'xxxxx'),
            'username' => env('DB_USERNAME_ESTATE', 'root'),
            'password' => env('DB_PASSWORD_ESTATE', '*****'),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_general_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
        ],
    ],

2.链接数据库

        开发中链接数据库一般有两种方式，一种是Model 链接，一种是 DB直接链接数据库

        Model 链接稍微麻烦点，DB较简单方便，先介绍DB链接方法

DB链接数据库

<?php

namespace App\Http\Controllers\Ceshi;


use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class CeshiController extends Controller
{

    public function find()
    {
        $data = DB::connection('ceshi')->table('表名')
                       ->where('sequenceNo',$sno)
                       ->select()->get()->toArray();
    }
}