配置

illuminate/database 数据库及版本支持情况如下：

  • MySQL 5.6+
  • PostgreSQL 9.4+
  • SQLite 3.8.8+

  • SQL Server 2017+

    数据库配置文件位置为 config/database.php。

    1. return [
    2.   // 默认数据库
    3.   'default' => 'mysql',
    4.   // 各种数据库配置
    5.   'connections' => [
    7.       'mysql' => [
    8.           'driver'      => 'mysql',
    9.           'host'        => '127.0.0.1',
    10.           'port'        => 3306,
    11.           'database'    => 'webman',
    12.           'username'    => 'webman',
    13.           'password'    => '',
    14.           'unix_socket' => '',
    15.           'charset'     => 'utf8',
    16.           'collation'   => 'utf8_unicode_ci',
    17.           'prefix'      => '',
    18.           'strict'      => true,
    19.           'engine'      => null,
    20.       ],
    22.       'sqlite' => [
    23.           'driver'   => 'sqlite',
    24.           'database' => '',
    25.           'prefix'   => '',
    26.       ],
    28.       'pgsql' => [
    29.           'driver'   => 'pgsql',
    30.           'host'     => '127.0.0.1',
    31.           'port'     => 5432,
    32.           'database' => 'webman',
    33.           'username' => 'webman',
    34.           'password' => '',
    35.           'charset'  => 'utf8',
    36.           'prefix'   => '',
    37.           'schema'   => 'public',
    38.           'sslmode'  => 'prefer',
    39.       ],
    41.       'sqlsrv' => [
    42.           'driver'   => 'sqlsrv',
    43.           'host'     => 'localhost',
    44.           'port'     => 1433,
    45.           'database' => 'webman',
    46.           'username' => 'webman',
    47.           'password' => '',
    48.           'charset'  => 'utf8',
    49.           'prefix'   => '',
    50.       ],
    51.   ],
    52. ];

    使用多个数据库

    通过Db::connection('配置名')来选择使用哪个数据库，其中配置名为配置文件config/database.php中的对应配置的key。

    例如如下数据库配置：

  1.  return [
  2.      // 默认数据库
  3.      'default' => 'mysql',
  4.      // 各种数据库配置
  5.      'connections' => [
  7.          'mysql' => [
  8.              'driver'      => 'mysql',
  9.              'host'        =>   '127.0.0.1',
  10.              'port'        => 3306,
  11.              'database'    => 'webman',
  12.              'username'    => 'webman',
  13.              'password'    => '',
  14.              'unix_socket' =>  '',
  15.              'charset'     => 'utf8',
  16.              'collation'   => 'utf8_unicode_ci',
  17.              'prefix'      => '',
  18.              'strict'      => true,
  19.              'engine'      => null,
  20.          ],
  22.          'mysql2' => [
  23.               'driver'      => 'mysql',
  24.               'host'        => '127.0.0.1',
  25.               'port'        => 3306,
  26.               'database'    => 'webman2',
  27.               'username'    => 'webman2',
  28.               'password'    => '',
  29.               'unix_socket' => '',
  30.               'charset'     => 'utf8',
  31.               'collation'   => 'utf8_unicode_ci',
  32.               'prefix'      => '',
  33.               'strict'      => true,
  34.               'engine'      => null,
  35.          ],
  36.          'pgsql' => [
  37.               'driver'   => 'pgsql',
  38.               'host'     => '127.0.0.1',
  39.               'port'     =>  5432,
  40.               'database' => 'webman',
  41.               'username' =>  'webman',
  42.               'password' => '',
  43.               'charset'  => 'utf8',
  44.               'prefix'   => '',
  45.               'schema'   => 'public',
  46.               'sslmode'  => 'prefer',
  47.           ],
  48.  ];

像这样切换数据库。

  1. // 使用默认数据库，等价于Db::connection('mysql')->table('users')->where('name', 'John')->first();
  2. $users = Db::table('users')->where('name', 'John')->first();; 
  3. // 使用mysql2
  4. $users = Db::connection('mysql2')->table('users')->where('name', 'John')->first();
  5. // 使用pgsql
  6. $users = Db::connection('pgsql')->table('users')->where('name', 'John')->first();