laravel配置sqlsrv

1。在 config 下 database.php 里添加以下代码

    'sqlsrv' => [
        'driver' => 'sqlsrv',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST_SRV', 'localhost'),
        'port' => env('DB_PORT_SRV', '1433'),
        'database' => env('DB_DATABASE_SRV', 'forge'),
        'username' => env('DB_USERNAME_SRV', 'forge'),
        'password' => env('DB_PASSWORD_SRV', ''),
        'charset' => 'utf8',
        'prefix' => '',
        'prefix_indexes' => true,
    ],

2.在.env 添加配置

DB_HOST_SRV=172.0.0.1
DB_PORT_SRV=端口
DB_DATABASE_SRV=数据库
DB_USERNAME_SRV=名字
DB_PASSWORD_SRV=密码

3.在控制器调用
DB::connection(‘sqlsrv’)->table(‘表名’)->select(array(‘字段1’,‘字段2’))