mysql level env_流明使用.env中的DB_连接连接到多个数据库-可能吗？

首先,您需要配置连接.您需要在项目中创建一个config目录,并添加文件config / database.php.像这样：

return [

'default' => 'mysql',

'connections' => [

'mysql' => [

'driver' => 'mysql',

'host' => 'localhost',

'database' => 'homestead',

'username' => 'root',

'password' => 'secret',

'charset' => 'utf8',

'collation' => 'utf8_unicode_ci',

'prefix' => '',

'strict' => false,

],

'mysql2' => [

'driver' => 'mysql',

'host' => 'localhost',

'database' => 'homestead2',

'username' => 'root',

'password' => 'secret',

'charset' => 'utf8',

'collation' => 'utf8_unicode_ci',

'prefix' => '',

'strict' => false,

],

],

添加连接配置后,可以通过将数据库管理器对象移出容器并调用-> connection(‘connection_name’)来访问它们.请参阅下面的完整示例.

namespace App\Http\Controllers;

use Illuminate\Database\DatabaseManager;

class StatsController extends Controller

{

/**

* @return array

*/

public function getLatest()

{

// Resolve dependencies out of container

/** @var DatabaseManager $db */

$db = app('db');

$database1 = $db->connection('mysql');

$database2 = $db->connection('mysql2');

// Look up 3 newest users and 3 newest blog posts

$threeNewestUsers = $database1->select("SELECT * FROM users ORDER BY created_at DESC LIMIT 3");

$threeLatestPosts = $database2->select("SELECT * FROM blog_posts ORDER BY created_at DESC LIMIT 3");

return [

"new_users" => $threeNewestUsers,

"new_posts" => $threeLatestPosts,

];

}

}