关于php连接sqlserver 数据库

示例是php7.0 连接sql2012的

1.下载ODBC windows驱动 

Download Microsoft® ODBC Driver 11 for SQL Server® - Windows from Official Microsoft Download Center

2.下载php 连接sqlserver 的.dll

下载 Microsoft Drivers for PHP for SQL Server - PHP drivers for SQL Server | Microsoft Docs

把dll放到 php的ext扩展文件夹下

3.配置php.ini

增加

extension=php_pgsql.dll
extension=php_pdo_sqlsrv_7_nts_x64.dll
extension=php_sqlsrv_7_nts_x64.dll

extension=php_pdo_odbc.dll 

odbc一定要开启不然会报错无法获取sql的  hadle

4.重启 

        $user_liset=new UsersModel();

       var_dump($user_liset->getList()->toArray()) ;

测试打印数据