如何在laravel中获取当前查询db\u host值

z6psavjg  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(401)

在此位置:..\config\database.php

  1. 'mysql' => [
  2. 'read' => [
  3. 'host' => env('DB_HOST_READ', '127.0.0.2'),
  4. ],
  5. 'write' => [
  6. 'host' => env('DB_HOST_WRITE', '127.0.0.1'),
  7. ],
  8. 'driver' => 'mysql',
  9. // 'host' => env('DB_HOST', '127.0.0.1'),
  10. 'port' => env('DB_PORT', '3306'),
  11. 'database' => env('DB_DATABASE', 'forge'),
  12. 'username' => env('DB_USERNAME', 'forge'),
  13. 'password' => env('DB_PASSWORD', ''),
  14. 'unix_socket' => env('DB_SOCKET', ''),
  15. 'charset' => 'utf8mb4',
  16. 'collation' => 'utf8mb4_unicode_ci',
  17. 'prefix' => '',
  18. 'strict' => false,
  19. 'engine' => null,
  20. ],

添加的.env文件:

  1. DB_HOST_READ=127.0.0.2
  2. DB_HOST_WRITE=127.0.0.1

查看读写主机值。我想验证用于当前运行的读写查询的主机。
我用的是Laravel5.5。那么,如何为每个查询获取db\u host值呢?

epggiuax

epggiuax1#

  1. env('DB_HOST_READ');
  2. env('DB_HOST_WRITE');

相关问题